string(739) "Error: MySQL server has gone away
Error No: 2006
SELECT SQL_CALC_FOUND_ROWS op.product_id, COUNT(*) AS total, (SELECT AVG(rating) AS rating FROM review r1 WHERE r1.product_id = op.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, IF(p2s.store_quantity > 0 , 1, 0) as avail FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) LEFT JOIN `product` p ON (op.product_id = p.product_id) LEFT JOIN `product_to_store` p2s ON (p.product_id = p2s.product_id) LEFT JOIN `product_description` pd on pd.product_id = op.product_id WHERE o.order_status_id > '0' AND p.status = '1' AND p2s.store_date_available <= NOW() AND p2s.store_id = '0' GROUP BY op.product_id ORDER BY avail desc, total desc LIMIT 60,30"