Error: Lost connection to MySQL server during query
Error No: 2013
SELECT c.* , cd.* #, count(p.product_id) AS `cnt` ,(SELECT COUNT(parent_id) FROM category WHERE parent_id = c.category_id AND status = '1' ) AS children FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) #INNER JOIN product p #ON p.p_category_id = c.category_id WHERE c.parent_id = '143' AND c.status = '1' AND cd.language_id = '1' HAVING ( c.category_id IN (SELECT p_category_id FROM product WHERE status=1) OR children > 0 ) #GROUP BY c.category_id ORDER BY c.sort_order, cd.name