Got error 28 from storage engine
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_Featured` = 1 GROUP BY `aic_property`.`property_ID` ORDER BY `aic_property`.`SortOrder` ASC LIMIT 0, 10