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 '1 GROUP BY `aic_property`.`property_ID` ORDER BY `aic_property`.`property_List' at line 13
SELECT `aic_property`.*,DATE_FORMAT(property_OpenHouseDate, '%M' ) as month, COALESCE(`aic_photo`.`photo_File`, '/images/house_sil.gif') as photo_File, COALESCE(`aic_photo`.`photo_Thumb`, '/images/house_sil.gif') as photo_Thumb, `aic_photo`.`photo_Title`, `aic_photo`.`photo_Alt` FROM `aic_property` LEFT JOIN `aic_photo` ON `aic_photo`.`photo_PropertyID` = `aic_property`.`property_ID` AND `aic_photo`.`SortOrder` <= 1 WHERE `aic_property`.`property_Approved` = 1 1 GROUP BY `aic_property`.`property_ID` ORDER BY `aic_property`.`property_ListPrice` DESC LIMIT 0, 10