Notice: Error: Table 'oc_order_product' is marked as crashed and should be repaired
Error No: 1194
SELECT op.product_id, COUNT(*) AS total FROM oc_order_product op LEFT JOIN `oc_order` o ON (op.order_id = o.order_id) LEFT JOIN `oc_product` p ON (op.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= '2019-03-24 11:19:00' AND p2s.store_id = '0' GROUP BY op.product_id ORDER BY total DESC LIMIT 12 in /var/www/ on line 50