A Database Error Occurred

Error Number: 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 (visible_to = 'everyone' ) and video_type = 'user' AND object_assoc_videos.' at line 4

SELECT COUNT(*) AS `numrows` FROM (`object_assoc_videos`) JOIN `videos` ON object_assoc_videos.object_id = videos.id WHERE AND (visible_to = 'everyone' ) and video_type = 'user' AND object_assoc_videos.assoc = 'domain' AND object_assoc_videos.assoc_id = '2'