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 dt_start > CURDATE() AND am_avail > 0 AND am_price_best_pp > 0 ' at line 19
SELECT * FROM ( SELECT AP.*, A.id_accom_type, A.nm_accom, A.am_rating, A.am_capacity, A.id_grade, R.id_resort, R.nm_resort, R.id_country FROM sw_accom_room_type_price AP LEFT JOIN sw_accom A ON (A.id_accom = AP.id_accom AND A.fl_accom_active = 1) LEFT JOIN sw_resort R ON (R.id_resort = A.id_resort) LEFT JOIN sw_country C ON (R.id_country = C.id_country) WHERE ( dt_start BETWEEN '2019-11-01' AND '2020-04-30' AND AP.id_accom IN () ) AND dt_start > CURDATE() AND am_avail > 0 AND am_price_best_pp > 0 AND am_price_best_pp_was > 0 AND am_price_best_pp <= am_price_best_pp_was AND brochure_code NOT IN (152,151) AND brochure_code != "" AND id_process IN (6,7,8) ORDER BY dt_start ASC, am_price_best_pp ASC ) AS tmp_tbl GROUP BY id_accom,dt_start,am_duration ORDER BY dt_start ASC, am_price_best_pp ASC
Line 112 of /home/skiworld/website/current/page_templates/last_minute_offers.php