RootForum Community

Code: Select all

Invalid SQL:
SELECT COUNT(*) AS countFROM vb_threadWHERE visible IN (0,1,2)AND sticky IN (0,1)AND open <> 10AND dateline >= 1219788000;

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 'vb_threadWHERE visible IN (0,1,2)AND sticky IN (0,1)AND open <> 10AND dateline >' at line 1

Code: Select all

SELECT COUNT(*) AS count FROM vb_thread WHERE visible IN (0,1,2) AND sticky IN (0,1) AND open <> 10 AND dateline >= 1219788000;