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