Error: MySQL server has gone away
Error No: 2006
SELECT p.*, pd.description, a.*, vd.seo, p.image, p2s.price, p.product_id, p.image, pd.name, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND ps.store_id = '0' ) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM product p INNER JOIN product_variation a ON (p.product_id = a.product_id) INNER JOIN variation_description vd ON (vd.variation_id=a.variation_id) INNER JOIN product_description pd ON (p.product_id = pd.product_id) INNER JOIN product_to_store_alter p2s ON (p.product_id = p2s.product_id) WHERE p2s.product_id = p.product_id AND p2s.active = '1' AND p2s.store_id = '0' AND vd.variation_id = a.variation_id AND vd.variation_id = '2255' AND p.product_id = pd.product_id AND a.product_id = pd.product_id AND p2s.quantity > '0' AND p.product_id != '29515' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id ORDER BY a.product_id DESC LIMIT 8