SELECT t1.*, COUNT(DISTINCTROW t3.`id`) num_links FROM `dir_categories` t1 LEFT JOIN `dir_flat_structure` t2 ON t1.`id` = t2.`id_parent` LEFT JOIN `dir_links` t3 ON t2.`id_category` = t3.`id_category` AND t3.`status` = 'active' LEFT JOIN `dir_categories` t4 ON t1.`id_parent` = t4.`id_parent` WHERE t4.`id` = '81' AND t1.`id` <> '81' AND t1.`status` = 'active' GROUP BY t1.`id` ORDER BY `order`<br />Lost connection to MySQL server during query