SELECT a1.*, b1.status_Title, c1.type_Title, d1.* FROM `mod_ap_property` AS a1 LEFT JOIN (`mod_ap_property_status` AS b1) ON (a1.property_StatusID=b1.status_ID) LEFT JOIN (`mod_ap_property_type` AS c1) ON (c1.type_ID=a1.property_TypeID) LEFT JOIN (mod_ap_property_logo AS d1) ON (d1.photo_PID = a1.property_ID) WHERE a1.client_uid=13517 AND ( a1.property_StatusID='33737' OR a1.property_StatusID='33738' OR a1.property_StatusID='33739') GROUP BY a1.property_ID ORDER BY a1.property_ListPrice DESC , a1.property_RentalRate DESC LIMIT 0, 10
Table './ai4_enterprise_db/mod_ap_property' is marked as crashed and should be repaired