[Hades-1]

i cant figure out why im getting this error.

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reputation) AS `reputation`,
SUM(gxboxlive.gold) AS `gold`
FROM
`vb_user` AS user
LEFT JOIN
`vb_userfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`vb_gxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN()

AND
field7 != ''
AND
user.posts >= '0'
AND
user.lastvisit >= '1171043851'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

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 ')

AND
field7 != ''
AND
user.posts >= '0'
AND
user.lastvisit' at line 13
Error Number : 1064
Date : Saturday, February 9th 2008 @ 11:57:32 AM
Script : http://xboxnode.com/beta/zone/index.php
Referrer : http://xboxnode.com/beta/zone/admincp/index.php?do=head
IP Address : 71.124.221.69
Username : steve
Classname : vb_database