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 \'-20\' at line 1 SQL=SELECT id, name, alias, site, type, Catering, Bedrooms, Bathrooms, Resort, Quality, propertytype, summary, ski_in_out, hottub, sauna, logfire, woodstove, pool_indoor, pool_outdoor_year, pool_outdoor_summer, gym, shared_use, ( CASE WHEN availabilityURL LIKE \'%.ics%\' THEN CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2024-04-20\') THEN \'3\' ELSE \'2\' END ELSE CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2024-04-20\') THEN \'1\' ELSE \'0\' END END ) as availability FROM jos_hp_properties_new as p WHERE p.published = \'1\' AND p.site = \'chamonixskichalets.com\' AND ( weekly = \'X\' OR weekly = \'on\') AND ( Catering = \'Catered\' OR Catering = \'Optional Catered or Self Catered\' OR Catering = \'Self-Catered in Summer & Catered in Winter\' ) ORDER BY availability DESC, modified DESC LIMIT 20 OFFSET -20