Changeling
From Edge of Darkness Wiki
Main ● Lost ● Changeling: The Lost ● Changeling
m |
m |
||
Line 20: | Line 20: | ||
{{#get_db_data:db=nwod | {{#get_db_data:db=nwod | ||
|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) JOIN user ON (user.username = thread.lastposter) | |from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) JOIN user ON (user.username = thread.lastposter) | ||
- | |where=thread.forumid IN (9,209,243) group by thread.title order by thread.lastpost desc LIMIT 20 | + | |where=thread.forumid IN (9,209,243) AND thread.open = 1 AND thread.lastpost >= UNIX_TIMESTAMP()-30*24*60*60 group by thread.title order by thread.lastpost desc LIMIT 20 |
|data=ctlforum=forum.title AS forum, ctlthread=thread.title, ctldate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, ctlposter=thread.lastposter, ctlpostcount=count(postid), ctlpostid=post.postid, ctlforumid=thread.forumid, ctluserid=user.userid | |data=ctlforum=forum.title AS forum, ctlthread=thread.title, ctldate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, ctlposter=thread.lastposter, ctlpostcount=count(postid), ctlpostid=post.postid, ctlforumid=thread.forumid, ctluserid=user.userid | ||
}} | }} |
Revision as of 03:27, 8 August 2016
|