A fatal MySQL error occured.

Query:
SELECT distinct pmd_listings .id , pmd_listings .* FROM pmd_listings JOIN pmd_listings_categories on pmd_listings.id = pmd_listings_categories.list_id WHERE cat_id IN (7702) 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 'status = 'active'' at line 1