Forum

SELECT @id_cat:= c.id, c.id AS cid, c.id_parent, c.name, c.rewrited_name, c.description AS subname, c.url, c.last_topic_id, t.id AS tid, t.idcat, t.title, t.last_timestamp, t.last_user_id, t.last_msg_id, t.nbr_msg AS t_nbr_msg, t.display_msg, t.STATUS, m.user_id, m.display_name AS login, m.level AS user_level, m.groups, v.last_view_id,
                (SELECT COUNT(*) FROM phpboost_forum_topics
                        WHERE idcat IN (
                                @id_cat,
                                (SELECT GROUP_CONCAT(id SEPARATOR ',') FROM phpboost_forum_cats WHERE id_parent = @id_cat), 
                                (SELECT GROUP_CONCAT(childs.id SEPARATOR ',') FROM phpboost_forum_cats parents
                                INNER JOIN phpboost_forum_cats childs ON parents.id = childs.id_parent
                                WHERE parents.id_parent = @id_cat)
                        )
                ) AS nbr_topic,
                (SELECT COUNT(*) FROM phpboost_forum_msg
                        WHERE idtopic IN (
                                (SELECT GROUP_CONCAT(id SEPARATOR ',') FROM phpboost_forum_topics WHERE idcat = @id_cat), 
                                (SELECT GROUP_CONCAT(t.id SEPARATOR ',') FROM phpboost_forum_topics t LEFT JOIN phpboost_forum_cats c ON t.idcat = c.id WHERE id_parent = @id_cat)
                        )
                ) AS nbr_msg
                FROM phpboost_forum_cats c
                LEFT JOIN phpboost_forum_topics t ON t.id = c.last_topic_id
                LEFT JOIN phpboost_forum_view v ON v.user_id = '5639' AND v.idtopic = t.id
                LEFT JOIN phpboost_member m ON m.user_id = t.last_user_id
                WHERE c.id IN ('0', '68', '48', '104', '74', '72', '73', '70', '23', '154', '7', '69', '66', '129', '75', '51', '183', '131', '79', '3', '105', '6', '184', '185', '187', '188', '189', '190', '191', '192', '186', '193', '206', '194', '195', '205', '197', '196', '198', '199', '200', '201', '202', '203', '204', '172', '87', '96', '90', '15', '44', '65', '47', '46', '4', '8', '20', '19', '41', '40', '67', '18', '49', '1', '50', '2', '110', '16', '13', '14', '11', '10', '9', '12')
                ORDER BY c.id_parent, c.c_order