Error: Server shutdown in progress
Error No: 1053
SELECT DISTINCT p.product_id , p.tax_class_id , pd.name AS name , p.image , p.price , p.model , m.name AS manufacturer , ss.name AS stock , (SELECT AVG(r.rating) FROM `review` r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating , COUNT(*) AS cnt FROM `order_product` op INNER JOIN `order` o ON o.order_id = op.order_id INNER JOIN `product` p ON op.product_id = p.product_id LEFT OUTER JOIN `product_description` pd ON p.product_id = pd.product_id LEFT OUTER JOIN `product_to_store` p2s ON p.product_id = p2s.product_id LEFT OUTER JOIN `manufacturer` m ON p.manufacturer_id = m.manufacturer_id LEFT OUTER JOIN `stock_status` ss ON p.stock_status_id = ss.stock_status_id WHERE o.customer_id IN ( SELECT o.customer_id FROM `order_product` op INNER JOIN `order` o ON o.order_id = op.order_id WHERE op.product_id = '1577' GROUP BY o.customer_id) AND p.product_id != '1577' AND pd.language_id = '2' AND p2s.store_id = '0' AND ss.language_id = '2' AND p.date_available <= NOW() AND p.status = '1' GROUP BY op.product_id ORDER BY COUNT(*) DESC LIMIT 0, 8;