weird SQL error

[emin3m]

select count(postuserid) as thre from thread join `pppuninstall` as UT where dateline >= UT.install AND dateline <= UT.uninstall AND visible=1 and dateline<=222147483647 and firstpostid<>0 and postuserid=1 and dateline>=(select prev_dateline from user where userid=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 'select prev_dateline from user where userid=1)' at line 1
Error Number : 1064

i get this error when query is done on the website, but the sql runs without error on phpmyadmin
userid is primary key

am counting postuserid between install and uninstall times!

[chazzy]

you have 2 semi-colons?

[emin3m]

i dun think semi colon is the error creator