MySQL Query Error

select * from lbcms_news where `show`=1 and `recover`=0 and id= limit 1
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 'limit 1' at line 1