SELECT COUNT(*) AS total FROM fi_events n
WHERE news n.datatime >= 1175461200 AND n.datatime <= 1199138399 AND n.act > 9

Error (1064): 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 'n.datatime >= 1175461200 AND n.datatime <= 1199138399 AND n.act > 9' at line 2
Date: 02.04.2007 07:55:04