No valid database connection 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 'AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodatio' at line 3 SQL=SELECT @id:=a.id AS id, a.id, a.title, a.min_capacity, a.max_capacity, a.price_summer, a.price_winter, a.price_summer_type, a.price_winter_type, a.price_summer_period, a.price_winter_period,
a.price_summer_food, a.price_winter_food, phones, GROUP_CONCAT(CONCAT(i.title,'@@',i.img) ORDER BY i.ordering) AS icons, (SELECT ordering FROM r10_rjacc_accomodation_ordering
WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodation_id=@id) AS ordering, (SELECT recommend FROM r10_rjacc_accomodation_recommend
WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodation_id=@id) AS recommended,
(SELECT small FROM r10_rjacc_images WHERE accomodation_id=@id AND winter=1 ORDER BY ordering ASC LIMIT 1) AS photo
FROM r10_rjacc_accomodations AS a
LEFT JOIN r10_rjacc_icons_accomodations AS ia ON a.id=ia.accomodation_id
LEFT JOIN r10_rjacc_icons AS i ON ia.icon_id=i.id
WHERE a.state=1 AND (a.valid_to>='2012-02-09' OR a.valid_to='0000-00-00') AND a.id IN (SELECT accomodation_id FROM r10_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND recommend=1)
GROUP BY a.id
ORDER BY ordering
No valid database connection 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 'AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodatio' at line 3 SQL=SELECT @id:=a.id AS id, a.id, a.title, a.min_capacity, a.max_capacity, a.price_summer, a.price_winter, a.price_summer_type, a.price_winter_type, a.price_summer_period, a.price_winter_period, a.price_summer_food, a.price_winter_food, phones, GROUP_CONCAT(CONCAT(i.title,'@@',i.img) ORDER BY i.ordering) AS icons, (SELECT ordering FROM r10_rjacc_accomodation_ordering WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodation_id=@id) AS ordering, (SELECT recommend FROM r10_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodation_id=@id) AS recommended, (SELECT small FROM r10_rjacc_images WHERE accomodation_id=@id AND winter=1 ORDER BY ordering ASC LIMIT 1) AS photo FROM r10_rjacc_accomodations AS a LEFT JOIN r10_rjacc_icons_accomodations AS ia ON a.id=ia.accomodation_id LEFT JOIN r10_rjacc_icons AS i ON ia.icon_id=i.id WHERE a.state=1 AND (a.valid_to>='2012-02-09' OR a.valid_to='0000-00-00') AND a.id NOT IN (SELECT accomodation_id FROM r10_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND recommend=1) GROUP BY a.id ORDER BY title
No valid database connection 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 'AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodatio' at line 3 SQL=SELECT @id:=a.id AS id, a.id, a.title, a.min_capacity, a.max_capacity, a.price_summer, a.price_winter, a.price_summer_type, a.price_winter_type, a.price_summer_period, a.price_winter_period, a.price_summer_food, a.price_winter_food, phones, GROUP_CONCAT(CONCAT(i.title,'@@',i.img) ORDER BY i.ordering) AS icons, (SELECT ordering FROM r10_rjacc_accomodation_ordering WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodation_id=@id) AS ordering, (SELECT recommend FROM r10_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND accomodation_id=@id) AS recommended, (SELECT small FROM r10_rjacc_images WHERE accomodation_id=@id AND winter=1 ORDER BY ordering ASC LIMIT 1) AS photo FROM r10_rjacc_accomodations AS a LEFT JOIN r10_rjacc_icons_accomodations AS ia ON a.id=ia.accomodation_id LEFT JOIN r10_rjacc_icons AS i ON ia.icon_id=i.id WHERE a.state=1 AND (a.valid_to>='2012-02-09' OR a.valid_to='0000-00-00') AND a.id NOT IN (SELECT accomodation_id FROM r10_rjacc_accomodation_recommend WHERE section_id= AND category_id=0 AND subcategory_id=-1 AND subsubcategory_id=-1 AND recommend=1) GROUP BY a.id ORDER BY title
