A fatal MySQL error occured.

Query:
SELECT count(*) FROM final_coupons C,final_listings L WHERE C.listing_id= AND C.listing_id=L.id AND L.status='active'

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 'AND C.listing_id=L.id AND L.status='active'' at line 4