A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

select * from film_wers where residential = "yes" and status ="1" and status ="1" and prime in ()

Filename: models/Film_model.php

Line Number: 30