The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
query problem
Hi, can someone suggest why this query isnt working?
SELECT thread.threadid, COUNT(post.postid) AS posts FROM thread INNER JOIN post ON thread.threadid = post.threadid WHERE (UNIX_TIMESTAMP()-post.dateline) < 86400 GROUP BY thread.threadid, COUNT(post.postid) ORDER BY COUNT(post.postid) DESC when i test it in phpMyAdmin i get an invalid use of group function error. cheers. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|