Help me pleaseeeee!!!
Error report:
Code:
Database error in vBulletin 3.8.0:
Invalid SQL:
SELECT user.*, COUNT(video.videoid) AS videocount
FROM video AS video
LEFT JOIN user AS user ON(user.userid = video.userid)
WHERE NOT ISNULL(user.userid)
GROUP BY video.userid
ORDER BY videocount DESC
LIMIT a;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 7
Error Number : 1064
Request Date : Friday, January 23rd 2009 @ 08:22:24 PM
Error Date : Friday, January 23rd 2009 @ 08:22:24 PM
Script : http://www.xxxx.com/forum/video.php
Referrer :
IP Address : 88.xxx.xxxx.134
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.58