SELECT guild_id,SUM(points) AS n, guild_name, user_name, guild_crest FROM ( SELECT guild_id, 1, 1782360000, COUNT(*) AS points FROM Guild_membercard WHERE user_joined >= 1782360000 GROUP BY guild_id UNION SELECT guild_id, 2, 1782360000, COUNT(*) AS points FROM Guild_membercard WHERE user_lastseen >= 1782360000 GROUP BY guild_id UNION SELECT guild_id, 3, 1782360000, COUNT(*) AS points FROM Guild_forum_t WHERE thread_dateposted >= 1782360000 GROUP BY guild_id UNION SELECT guild_id, 4, 1782360000, COUNT(*) AS points FROM Guild_img WHERE date_created >= 1782360000 GROUP BY guild_id ) AS a INNER JOIN Guild_guilds USING(guild_id) INNER JOIN e107.e107_user ON guild_owner_id = user_id GROUP BY guild_id ORDER BY n DESC [close]