This page loaded in 0.02253 seconds.
Queries: 2

SELECT * FROM `toplinks` ORDER BY `id` ASC

SELECT t.topic_id, t.forum_id, t.title, t.replies, t.views, t.last_reply_time, t.sticky, t.members_read, g1.colour AS m1colour, g2.colour AS m2colour, m1.member_id AS m1mid, m1.username AS m1username, m1.group, m2.group, m2.member_id AS m2mid, m2.username AS m2username FROM topics t INNER JOIN members m1 ON t.author = m1.member_id INNER JOIN members m2 ON t.last_reply_id = m2.member_id INNER JOIN groups g1 ON m1.group = g1.id INNER JOIN `groups` g2 ON m2.group = g2.id ORDER BY t.last_reply_time DESC LIMIT 10