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 > \'2020-08-12\') THEN \'3\' ELSE \'2\' END ELSE CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2020-08-12\') 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 id NOT IN ("242", "953", "1454", "1452", "1445", "1444", "1451", "1444", "950", "1441", "1514", "1359", "1514", "1443", "1443", "942", "1456", "942", "1455") AND id IN ("517", "1479", "442", "961", "1369", "246", "964", "115", "316", "1522", "100", "123", "1494", "726", "70", "1371", "228", "1372", "141", "1430", "81", "296", "86") AND ( weekly = \'X\' OR weekly = \'on\') ORDER BY availability DESC, modified DESC LIMIT 20 OFFSET -20
22 Results found. 

Chalets available for Christmas 2018

Chalets available for Christmas 2018

Call for more information

No Property exists
22 Results found.