Вот конечный рез-ат:
- Код: Выделить всё • Развернуть
$sql_sets = "SELECT forums.id AS forumID,
forums.title AS forumTitle,
forums.description AS forumDesc,
forums.moders AS forumModers,
forums.section_id AS forumSecID,
forums.parent_forum AS forumParForum,
forums.icon AS forumIcon,
forums_themes.id AS lastThemeID,
forums_themes.title AS lastThemeTitle,
forums_posts.id AS lastPostID,
forums_posts.date AS lastPostDate,
forums_posts.author_id AS lastPostAuthor,
forums_posts.deleted AS lastPostDeleted,
users.id AS userID,
users.username AS userName,
(SELECT count(*) FROM forums_themes WHERE forums_themes.forum_id = forums.id) AS themesCount,
(SELECT count(*) FROM forums_posts WHERE forums_posts.forum_id = forums.id) AS postsCount
FROM forums
LEFT JOIN forums_themes ON forums_themes.forum_id = forums.id
LEFT JOIN forums_posts ON forums_posts.forum_id = forums.id
LEFT JOIN users ON users.id = forums_posts.author_id
WHERE forums.section_id = '".$row['id']."' AND forums.parent_forum = 0
GROUP BY forums.id ORDER BY forums.id
LIMIT ".$row_all_forums[0];