The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Question about query syntax
I'm trying to pull the last 3 posts from a few forums and then sort the by the forum's name. Here is what I have so far:
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 ( 19, 116 ) AND t.open = '1' AND t.visible = '1' ORDER BY forumtitle DESC LIMIT 0 , 3 The code above only pull 3 total posts from the forums, any ideas on how to pull the last 3 posts from each forum? Thanks in advance! |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|