getData: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 `ROOMS`.`OPERTYPE_ID` IN (1) AND `ROOMS`.`ISARC` = '0' ) ) ORDER BY `R' at line 63 SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `ROOMS`.`ID` AS `ROOMS___ID`, `ROOMS`.`ID` AS `ROOMS___ID_raw`, `ROOMS`.`exist_photo` AS `ROOMS___exist_photo`, `ROOMS`.`exist_photo` AS `ROOMS___exist_photo_raw`, `ROOMS`.`ipoteka_types_id` AS `ROOMS___ipoteka_types_id_raw`, `ipoteka_types`.`type_name` AS `ROOMS___ipoteka_types_id`, `ROOMS`.`OPERTYPE_ID` AS `ROOMS___OPERTYPE_ID_raw`, `OPERTYPES`.`OPERTYPE` AS `ROOMS___OPERTYPE_ID`, `ROOMS`.`location` AS `ROOMS___location`, `ROOMS`.`location` AS `ROOMS___location_raw`, `ROOMS`.`price_view` AS `ROOMS___price_view`, `ROOMS`.`price_view` AS `ROOMS___price_view_raw`, `ROOMS`.`ROOMTYPE_ID` AS `ROOMS___ROOMTYPE_ID_raw`, `ROOMTYPES`.`ROOMTYPE` AS `ROOMS___ROOMTYPE_ID`, `ROOMS`.`square` AS `ROOMS___square`, `ROOMS`.`square` AS `ROOMS___square_raw`, `ROOMS`.`material` AS `ROOMS___material`, `ROOMS`.`material` AS `ROOMS___material_raw`, `ROOMS`.`floor_floors` AS `ROOMS___floor_floors`, `ROOMS`.`floor_floors` AS `ROOMS___floor_floors_raw`, `ROOMS`.`COUNTRY_ID` AS `ROOMS___COUNTRY_ID_raw`, `COUNTRIES`.`COUNTRY` AS `ROOMS___COUNTRY_ID`, `ROOMS`.`contact_view` AS `ROOMS___contact_view`, `ROOMS`.`contact_view` AS `ROOMS___contact_view_raw`, `ROOMS`.`ORIENT_ID` AS `ROOMS___ORIENT_ID_raw`, `ORIENTS`.`ORIENT` AS `ROOMS___ORIENT_ID`, `ROOMS`.`REMARK` AS `ROOMS___REMARK`, `ROOMS`.`REMARK` AS `ROOMS___REMARK_raw`, `ROOMS`.`ISARC` AS `ROOMS___ISARC`, `ROOMS`.`ISARC` AS `ROOMS___ISARC_raw`, `ROOMS`.`PRICE` AS `ROOMS___PRICE`, `ROOMS`.`PRICE` AS `ROOMS___PRICE_raw`, `ROOMS`.`photo1` AS `ROOMS___photo1`, `ROOMS`.`photo1` AS `ROOMS___photo1_raw`, `ROOMS`.`photo2` AS `ROOMS___photo2`, `ROOMS`.`photo2` AS `ROOMS___photo2_raw`, `ROOMS`.`photo3` AS `ROOMS___photo3`, `ROOMS`.`photo3` AS `ROOMS___photo3_raw`, `ROOMS`.`photo4` AS `ROOMS___photo4`, `ROOMS`.`photo4` AS `ROOMS___photo4_raw`, `ROOMS`.`photo5` AS `ROOMS___photo5`, `ROOMS`.`photo5` AS `ROOMS___photo5_raw`, `ROOMS`.`photo6` AS `ROOMS___photo6`, `ROOMS`.`photo6` AS `ROOMS___photo6_raw`, `ROOMS`.`favorites` AS `ROOMS___favorites`, `ROOMS`.`favorites` AS `ROOMS___favorites_raw`, `ROOMS`.`ipoteka_types_id` AS `ROOMS___ipoteka_types_id_raw`, `ipoteka_types_0`.`type_name` AS `ROOMS___ipoteka_types_id`, `ROOMS`.`LANDTYPE_ID` AS `ROOMS___LANDTYPE_ID_raw`, `LANDTYPES`.`LANDTYPE` AS `ROOMS___LANDTYPE_ID`, `ROOMS`.`area_S` AS `ROOMS___area_S`, `ROOMS`.`area_S` AS `ROOMS___area_S_raw`, `ROOMS`.`ID` AS slug , `ROOMS`.`ID` AS `__pk_val` FROM `ROOMS` LEFT JOIN `ipoteka_types` AS `ipoteka_types` ON `ipoteka_types`.`id` = `ROOMS`.`ipoteka_types_id` LEFT JOIN `OPERTYPES` AS `OPERTYPES` ON `OPERTYPES`.`ID` = `ROOMS`.`OPERTYPE_ID` LEFT JOIN `ROOMTYPES` AS `ROOMTYPES` ON `ROOMTYPES`.`ID` = `ROOMS`.`ROOMTYPE_ID` LEFT JOIN `COUNTRIES` AS `COUNTRIES` ON `COUNTRIES`.`ID` = `ROOMS`.`COUNTRY_ID` LEFT JOIN `ORIENTS` AS `ORIENTS` ON `ORIENTS`.`ID` = `ROOMS`.`ORIENT_ID` LEFT JOIN `ipoteka_types` AS `ipoteka_types_0` ON `ipoteka_types_0`.`id` = `ROOMS`.`ipoteka_types_id` LEFT JOIN `LANDTYPES` AS `LANDTYPES` ON `LANDTYPES`.`ID` = `ROOMS`.`LANDTYPE_ID` WHERE ( ( `ROOMS`.`COUNTRY_ID` IN (10000105,73,77,80,84,85,1,91,92,97,10000012,10000100,86,10000106,10000107,10000108,10000129,10000130,10000138,10000139,10000141,10000143,10000145,2,39,59,31,62,27,26,21,14,66,12,7,6,5,4,3,10000127,10000123,10000140,10000103,10000098,10000078,10000063,10000077,10000076,10000073,64,72,70,75,76,69,78,79,68,81,65,10000071,88,89,63,93,94,95,1500098,71,10000065) AND `ROOMS`.`ROOMTYPE_ID` IN (2,3,5,25,26,27,30,32,33,34,35,36,37,39,40,41,42,44,45,46,48,50,51,52,53,54,55,56,57,59) AND `ROOMS`.`PRICE` >= 0 AND `ROOMS`.`PRICE` <= 999999999 AND `ROOMS`.`ROOMTYPE_ID` IN () AND `ROOMS`.`OPERTYPE_ID` IN (1) AND `ROOMS`.`ISARC` = '0' ) ) ORDER BY `ROOMS`.`LAST_UPDATE` DESC LIMIT 0, 30