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 (4, 1) AND `ROOMS`.`ISARC` = '0' ) ) ORDER BY' at line 60 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`.`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`.`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 `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` ON `ipoteka_types`.`id` = `ROOMS`.`ipoteka_types_id` LEFT JOIN `LANDTYPES` AS `LANDTYPES` ON `LANDTYPES`.`ID` = `ROOMS`.`LANDTYPE_ID` WHERE ( ( `ROOMS`.`COUNTRY_ID` IN (10000143,66,10000141,85,73,10000129,62,59,39,10000108,10000107,97,84,10000145,80,10000100,77,10000105,10000106,31,27,26,91,92,10000012,10000139,10000138,86,1,2,12,10000130,7,21,6,5,4,3,14,1500098,10000076,10000077,10000078,10000140,10000098,10000103,10000123,10000127,95,70,69,68,65,63,88,10000065,10000063,93,71,72,94,10000073,10000071,64,81,79,78,76,75,89) AND `ROOMS`.`ROOMTYPE_ID` IN (25,26,27,2,3,5,30,37,32,33,34,35,36,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 (4, 1) AND `ROOMS`.`ISARC` = '0' ) ) ORDER BY `ROOMS`.`LAST_UPDATE` DESC LIMIT 0, 30