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!