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=12687 AND (a1.property_StatusID='28719' OR a1.property_StatusID='28723' OR a1.property_StatusID='28720' OR a1.property_StatusID='28721' OR a1.property_StatusID='28722' OR a1.property_StatusID='28724' OR a1.property_StatusID='28719' OR a1.property_StatusID='28720' OR a1.property_StatusID='28721' ) AND (a1.property_TypeID='33526' OR a1.property_TypeID='33521' OR a1.property_TypeID='33522' OR a1.property_TypeID='33523' OR a1.property_TypeID='33524' OR a1.property_TypeID='33525' OR a1.property_TypeID='33520' ) OR (a1.property_CustomID='872' OR a1.property_CustomID='876' OR a1.property_CustomID='874' OR a1.property_CustomID='878' OR a1.property_CustomID='879' OR a1.property_CustomID='875' OR a1.property_CustomID='873' OR a1.property_CustomID='877' ) GROUP BY a1.property_ID ORDER BY c1.type_Title DESC , a1.property_ListPrice DESC LIMIT 0, 50
Table 'mod_ap_property' is marked as crashed and should be repaired