.

Алматы: 8 /727/ 390 79 05

Мобиль.: 8 747 390 79 09

 Астана:  8/717/247 29 22

 

на 15.09.2016
USD - 342.50
EUR - 384.95
  • ГОРЯЩИЕ ТУРЫ В ЕВРОПУ
  • ГОРЯЩИЕ ТУРЫ В АЗИЮ
  • ГОРЯЩИЕ ТУРЫ В АМЕРИКУ
No data displayed on the module. Please check some parameters in the module settings again!
Тур
Post by: admin
13.Feb.2014
Be the first to comment!
  Тур " Классическая Италия"   Посещение городов: РИМ - ВАТИКАН - НЕАПОЛЬ - ПОМПЕИ - ФЛОРЕНЦИЯ - СИЕНА - ПИЗА - ВЕНЕЦИЯ - РЕСПУБЛИКА САН МАРИНО   
Азия
Ознакомьтесь с самыми выгодными предложениями в Азию
Туры в ОАЭ из городов РК
Post by: admin
15.Feb.2014
Be the first to comment!
Туры в ОАЭ, туры в Дубаи   Ознакомьтесь - это наши самые лучшие туры в ОАЭ. В течении многих лет наша профессиональна команда подбирала и разрабатывала для Вас самые лучшие
Error
  • Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM pkwpc_content AS a LEFT JOIN pkwpc_categories AS c ON c.id = a.catid LEFT JOIN pkwpc_users AS ua ON ua.id = a.created_by LEFT JOIN pkwpc_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM pkwpc_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN pkwpc_categories as parent ON parent.id = c.parent_id LEFT JOIN pkwpc_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM pkwpc_categories AS cat JOIN pkwpc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN pkwpc_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-11-22 12:29:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-11-22 12:29:33') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.ordering, a.created DESC LIMIT 0, 1 Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM pkwpc_content AS a LEFT JOIN pkwpc_categories AS c ON c.id = a.catid LEFT JOIN pkwpc_users AS ua ON ua.id = a.created_by LEFT JOIN pkwpc_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM pkwpc_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN pkwpc_categories as parent ON parent.id = c.parent_id LEFT JOIN pkwpc_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM pkwpc_categories AS cat JOIN pkwpc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN pkwpc_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-11-22 12:29:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-11-22 12:29:33') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.ordering, a.created DESC
Hide Main content block

Почему работать с туроператором Sun Holidays - это выгодно:

Получите все преимущества на рынке туризма вместе с нами. Став нашим агентом Вы имеете возможность:

bp

Лучшие цены

Туроператор Sun Holidays имеет эксклюзивные контракты на отели с лучшими ценами по всему миру. Став нашим агентов Вы получаете преимуществе на рынке туризма для Ваших клиентов.

bonus icon

Бонусы

Наша бонусная программа позволит зарабытывать агенту не зависимо от комиссии компании отличные бонусы!

ob-icon

Наша система он-лайн бронирования позволит Вам быть в курсе самых актуальных туров.

Перейти на он-лайн

train

ЖД билеты

Сотрудничество с нами позволит Вам приобредать все наземные услуги в Европе от железнодорожных билетов до трансферта.

icon-passport

Визовый центр

Наш визовый центр поможнт оформить Вашим клиентам Шенген визу до 3-х лет.