sabret00the
07-23-2004, 04:51 PM
why won't this query work
SELECT thread.lastpost,thread.title,thread.lastposter,use r.userid,thread.threadid,thread.forumid,thread.ico nid,forum.title AS ftitle,
FROM thread
LEFT JOIN forum ON (forum.forumid = thread.forumid)
LEFT JOIN user ON (user.username = thread.postusername)
WHERE thread.forumid NOT IN (20,17,18,74,95)
ORDER BY thread.lastpost desc
i'm basically trying to grab a list of the most recently replied to thread
SELECT thread.lastpost,thread.title,thread.lastposter,use r.userid,thread.threadid,thread.forumid,thread.ico nid,forum.title AS ftitle,
FROM thread
LEFT JOIN forum ON (forum.forumid = thread.forumid)
LEFT JOIN user ON (user.username = thread.postusername)
WHERE thread.forumid NOT IN (20,17,18,74,95)
ORDER BY thread.lastpost desc
i'm basically trying to grab a list of the most recently replied to thread