[SQL] SELECT t.*, COUNT(ut.user_id) AS follower_count FROM d_topic t LEFT JOIN d_user_topic ut ON ut.topic_id = t.id GROUP BY t.id ORDER BY follower_count DESC | Params: [] [SQL] SELECT i.*, u.name AS author_name, u.username AS author_username, u.avatar_url AS author_avatar FROM d_idea i left JOIN d_user u ON u.id = i.user_id WHERE i.is_draft = 0 AND FIND_IN_SET(?, REPLACE(i.hashtags, ',', ',')) ORDER BY i.dt_created DESC LIMIT ? OFFSET ? | Params: ["philosophy",20,0] [SQL] SELECT u.*, COUNT(DISTINCT i.id) AS idea_count FROM d_user u LEFT JOIN d_idea i ON i.user_id = u.id AND i.is_draft = 0 GROUP BY u.id ORDER BY idea_count DESC LIMIT ? | Params: [5]