[Robert Basil]

When I use:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title as forumtitle, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext, t.iconid, t.forumid
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumid
WHERE t.forumid
IN (82,89,83,134,135,136,13,14,23,16,17,18,20,21,22,2 4,130,129,125,116,19)
AND t.open = '1'
AND t.visible = '1'
GROUP BY f.title
ORDER BY t.dateline DESC, forumtitle DESC
LIMIT 0 , 100

The forums are not in order and the posts are not the last posts.

When I use:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title as forumtitle, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext, t.iconid, t.forumid
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumid
WHERE t.forumid
IN (82,89,83,134,135,136,13,14,23,16,17,18,20,21,22,2 4,130,129,125,116,19)
AND t.open = '1'
AND t.visible = '1'
GROUP BY f.title
ORDER BY t.dateline ASC, forumtitle DESC
LIMIT 0 , 100

The forums are in order but it's still showing the first posts (not the latest ones).