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=12421 AND (a1.property_StatusID='27097' OR a1.property_StatusID='27098' OR a1.property_StatusID='27099' ) GROUP BY a1.property_ID ORDER BY a1.property_Rank ASC , a1.property_Rank ASC LIMIT 0, 35
Table './ai4_enterprise_db/mod_ap_property' is marked as crashed and should be repaired