This page loaded in 0.01243 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
WHERE
t.replies >= 10
ORDER BY
t.last_reply_time DESC
