A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND vd.show_villa_catalogue =1 GROUP BY vd.id ORDER BY vd.iSleeps ,maxRa...' at line 6

SELECT vd.id, vd.tName, vd.tFolderName,vd.display_price, vd.tRef, loc.tName AS tLocationName,loc.id AS locId, vd.tCurrency,vd.tLinkKeywords, vd.tShortDescription2, vd.iCommission,CASE WHEN vd.iSleeps IN (0,1,2,3,4,5) THEN '5' WHEN vd.iSleeps IN (6,7) THEN '6' WHEN vd.iSleeps IN (8,9) THEN '8' WHEN vd.iSleeps IN (10,11) THEN '10' WHEN vd.iSleeps IN (12,13) THEN '12' WHEN vd.iSleeps IN (14) THEN '14' WHEN vd.iSleeps IN (15,16,17,18,19) THEN '15' WHEN vd.iSleeps IN (20,21,22,23,24) THEN '20' ELSE '25' END AS iSleeps, vd.bSwimmingPool, vd.bInternet, vd.bWifi, vd.bAirConditioning, vd.destination, vd.min_rate AS minRate, vd.max_rate AS maxRate FROM villas_details AS vd LEFT JOIN locations AS loc ON (loc.id = vd.iLocation) LEFT JOIN villas_availability AS va ON (vd.id = va.iPropertyID) WHERE bPublished=1 AND loc.iRegionID in () AND vd.show_villa_catalogue =1 GROUP BY vd.id ORDER BY vd.iSleeps ,maxRate, minRate asc

Filename: /home/304182.cloudwaysapps.com/zbjpdsauvj/public_html/models/mainmodel.php

Line Number: 2183