Error: Table 'jpocproduct' is marked as crashed and should be repaired
Error No: 1194
SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM jpocreview r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating FROM jpocproduct p LEFT JOIN jpocproduct_description pd ON (p.product_id = pd.product_id) LEFT JOIN jpocmanufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN jpocstock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN jpocproduct_to_category pc ON (p.product_id = pc.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p.quantity <> 0 AND pd.language_id = '2' AND ss.language_id = '2' AND pc.category_id IN (200909,911,200910,1053,1054,1057,1056,1055,1058,110005,110006,110007,110008,110009,110010,110011,110012,1124,1126,1128,1129,1127,110013,110014,110015,1125,1130,1131,10097,18117,18118,18119,18120,18121,18122,18102) GROUP BY p.product_id ORDER BY p.date_available DESC, p.sort_order ASC, p.product_id DESC LIMIT 18