@rxurxu писал(а): @rxu
i found the problem why i was getting query limit issue. with your code, more than 1000 queries run on the index page. for example if i put 20 for category to hide, it runs the code below for [QUERY #868] times:
Код: Выделить всё
SELECT f2.*
FROM phpbb_forums f1
LEFT JOIN phpbb_forums f2 ON (f2.left_id BETWEEN f1.left_id AND f1.right_id)
WHERE f1.forum_id = 20
ORDER BY f2.left_id ASC
thank you,