The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
SQL Query to get First post of users
Hello,
Am using the below query to get the post of the users registered during Jan 2015: Code:
SELECT a.title, a.username, a.postid FROM post a, user b WHERE a.userid = b.userid AND FROM_UNIXTIME (b.joindate) BETWEEN '2015-01-01' AND '2015-02-01' |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|