SQL_ERROR: SELECT * FROM travel_offer WHERE travel_offer.id = '2000'' SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2000''' at line 1 SQL_ERROR: SELECT stravel_offer.id, travel_offer.title, travel_offer.route, travel_offer.days_cnt, travel_offer.nights_cnt, travel_offer.description, travel_offer.htmldoc, travel_offer.more_info, travel_offer.transport_type_id, travel_offer.travel_offer_type_id, travel_offer.dest_location_id, MIN(travel_price_table.best_price) AS price, travel_price_table.currency_id, simage.name AS image, /* snode.name AS node_name,*/ stravel_offer.owner_user_group_id, scompany.id company_id, scompany.name company_name, company.legal_name company_legal_name, company.phone company_phone, company.url company_url, company.email company_email, company.address company_address FROM sys_object stravel_offer LEFT JOIN travel_offer ON (stravel_offer.id = travel_offer.id) LEFT JOIN sys_object simage ON (travel_offer.image_id = simage.id AND simage.sys_object_type_id = '30') LEFT JOIN sys_object scompany ON (stravel_offer.owner_user_group_id = scompany.owner_user_group_id AND scompany.sys_object_type_id = '79') LEFT JOIN company ON (scompany.id = company.id), sys_object stravel_price_table LEFT JOIN travel_price_table ON (stravel_price_table.id = travel_price_table.id)/*, sys_object ssys_object_node LEFT JOIN sys_object_node ON (ssys_object_node.id = sys_object_node.id), sys_object snode*/ WHERE stravel_price_table.parent_sys_object_id = stravel_offer.id AND /* ssys_object_node.parent_sys_object_id = stravel_offer.id AND*/ /*sys_object_node.node_id = '1726' AND snode.id = sys_object_node.node_id AND*/ stravel_offer.is_deleted = 0 AND stravel_price_table.is_deleted = 0 AND /* ssys_object_node.is_deleted = 0 AND snode.is_deleted = 0 AND*/ stravel_price_table.sys_object_type_id = '44' AND stravel_offer.sys_object_type_id = '80' AND /* ssys_object_node.sys_object_type_id = '28' AND snode.sys_object_type_id = '27' AND*/ stravel_offer.id = '2000'' GROUP BY stravel_offer.id ORDER BY stravel_offer.id SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2000'' GROUP BY stravel_offer.id ORDER BY stravel_offer.id' at line 48 SQL_ERROR: SELECT simage.id, simage.name FROM sys_object ssys_object_image LEFT JOIN sys_object_image ON (ssys_object_image.id = sys_object_image.id), sys_object simage WHERE ssys_object_image.parent_sys_object_id = '2000'' AND simage.id = sys_object_image.image_id AND ssys_object_image.is_deleted = 0 AND ssys_object_image.is_hidden = 0 AND ssys_object_image.sys_object_type_id = '29' AND simage.sys_object_type_id = '30' ORDER BY ssys_object_image.seq SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '29' AND simage.sys_object_type_id = '30' ORDER BY ssys_object_image.seq' at line 8 SQL_ERROR: SELECT travel_date.id, travel_date.travel_period_id, travel_date.depart_date, travel_date.depart_hour, travel_date.arrive_date, travel_date.arrive_hour, travel_date.back_date, travel_date.back_hour, travel_date.return_date, travel_date.return_hour, travel_date.number_avail, travel_date.number_total, travel_date.number_reserved, travel_date.travel_date_type_id, travel_date.valid_from, travel_date.valid_until, travel_date.wdays, stravel_date.name as depart_date_name FROM sys_object stravel_date LEFT JOIN travel_date ON (stravel_date.id = travel_date.id) WHERE stravel_date.parent_sys_object_id = '2000'' AND stravel_date.is_deleted = 0 AND (depart_date > '2010-09-05 00:14:09' OR valid_from> '2010-09-05 00:14:09')AND stravel_date.sys_object_type_id = '35' ORDER BY depart_date SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2010-09-05 00:14:09' OR valid_from> '2010-09-05 00:14:09')AND stravel_date.s' at line 23 SQL_ERROR: SELECT stravel_price_table.id, travel_price_table.title, travel_price_table.price1_comment, travel_price_table.price2_comment, travel_price_table.price3_comment, travel_price_table.price4_comment, travel_price_table.price5_comment, travel_price_table.price6_comment, travel_price_table.price7_comment, travel_price_table.price8_comment, travel_price_table.price9_comment, travel_price_table.price10_comment, depart_date, stravel_price_table.comment FROM sys_object stravel_price_table LEFT JOIN travel_price_table ON (stravel_price_table.id = travel_price_table.id) LEFT JOIN sys_object stravel_date ON (travel_price_table.travel_date_id = stravel_date.id AND stravel_date.sys_object_type_id = '35' AND stravel_date.is_deleted = 0) LEFT JOIN travel_date ON (stravel_date.id = travel_date.id) WHERE stravel_price_table.parent_sys_object_id = '2000'' AND stravel_price_table.is_deleted = 0 AND stravel_price_table.sys_object_type_id = '44' SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '44'' at line 19 SQL_ERROR: SELECT hotel1.id, travel_offer_hotel.id as travel_offer_hotel_id, hotel1.id as hotel_id, travel_offer_hotel.best_price, travel_offer_hotel.currency_id, travel_offer_hotel.other_notes, hotel1.title, hotel1.url, hotel1.hotel_category_id, hotel1.location_id, hotel1.location, hotel1.url, hotel2.title hotel2_title, hotel2.url hotel2_url, hotel2.hotel_category_id hotel2_hotel_category_id, hotel2.location_id hotel2_location_id, hotel2.location hotel2_location, hotel2.url hotel2_url, hotel3.title hotel3_title, hotel3.url hotel3_url, hotel3.hotel_category_id hotel3_hotel_category_id, hotel3.location_id hotel3_location_id, hotel3.location hotel3_location, hotel3.url hotel3_url, travel_offer_hotel.other_notes, stravel_offer_hotel.comment, shotel1.owner_user_group_id, slocation.name as bg_name, simage.name AS image FROM sys_object shotel1 LEFT JOIN hotel hotel1 ON (hotel1.id = shotel1.id) LEFT JOIN sys_object simage ON (hotel1.image_id = simage.id AND simage.sys_object_type_id = '30') LEFT JOIN sys_object slocation ON (slocation.id = hotel1.location_id) LEFT JOIN location ON (slocation.id = location.id AND slocation.sys_object_type_id = '66'), sys_object stravel_offer_hotel LEFT JOIN travel_offer_hotel ON (stravel_offer_hotel.id = travel_offer_hotel.id) LEFT JOIN hotel hotel2 ON (travel_offer_hotel.city2_hotel_id = hotel2.id) LEFT JOIN hotel hotel3 ON (travel_offer_hotel.city3_hotel_id = hotel3.id) WHERE stravel_offer_hotel.parent_sys_object_id = '2000'' AND travel_offer_hotel.hotel_id = hotel1.id AND stravel_offer_hotel.is_deleted = 0 AND stravel_offer_hotel.is_hidden = 0 AND shotel1.sys_object_type_id = '102' AND stravel_offer_hotel.sys_object_type_id = '81' GROUP BY hotel1.id, hotel2.id, hotel3.id ORDER BY travel_offer_hotel.best_price SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '102' AND stravel_offer_hotel.sys_object_type_id = '81' GROUP BY hotel1.id, ' at line 38 SQL_ERROR: SELECT location.id, location.bg_name FROM sys_object stravel_offer_location LEFT JOIN travel_offer_location ON (stravel_offer_location.id = travel_offer_location.id), sys_object slocation LEFT JOIN location ON (slocation.id = location.id) WHERE stravel_offer_location.parent_sys_object_id = '2000'' AND travel_offer_location.location_id = location.id AND stravel_offer_location.is_deleted = 0 AND slocation.sys_object_type_id = '66' AND stravel_offer_location.sys_object_type_id = '82' SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '66' AND stravel_offer_location.sys_object_type_id = '82'' at line 8 SQL_ERROR: SELECT stravel_offer.id, stravel_offer_hotel.id travel_offer_hotel_id, travel_offer.title, travel_offer.more_info, stravel_offer.comment, price1_comment, price2_comment, price3_comment, price4_comment, price5_comment, price6_comment, price7_comment, price8_comment, price9_comment, price10_comment FROM sys_object stravel_offer LEFT JOIN travel_offer ON (stravel_offer.id = travel_offer.id), sys_object stravel_offer_hotel LEFT JOIN travel_offer_hotel ON (stravel_offer_hotel.id = travel_offer_hotel.id), /*sys_object stravel_price_row LEFT JOIN travel_price_row ON (stravel_price_row.id = travel_price_row.id), travel_date,*/ sys_object ssys_object_node LEFT JOIN sys_object_node ON (ssys_object_node.id = sys_object_node.id) WHERE stravel_offer.id = stravel_offer_hotel.parent_sys_object_id AND stravel_offer.id = '2000'' AND /*stravel_price_row.parent_sys_object_id = stravel_offer_hotel.id AND travel_date.id = travel_price_row.travel_date_id AND*/ ssys_object_node.parent_sys_object_id = stravel_offer.id AND ssys_object_node.is_deleted = 0 AND ssys_object_node.is_hidden = 0 AND /* stravel_price_row.sys_object_type_id = '45' AND*/ stravel_offer.sys_object_type_id = '80' AND ssys_object_node.sys_object_type_id = '28' AND stravel_offer_hotel.sys_object_type_id = '81' SQL_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '45' AND*/ stravel_offer.sys_object_type_id = '80' AND ssys_object_node.sys_o' at line 27
Warning: Cannot modify header information - headers already sent by (output started at /export/web/online/system-4.8/modules/libs/inc/lib/db.inc:31) in /export/web/online/system-4.8/apps/imtour/imtour-site/www/i.php on line 46
- Imtour Tour
Начало
Почивки