Database Query Error:
Original Query:
SELECT a.*, m.firstname, m.lastname, p.pid, COUNT(DISTINCT p.id) AS count
					FROM `photo_albums` AS a
					LEFT JOIN `friends` AS f ON ((f.f_id =  AND a.mid = f.u_id) OR (f.u_id =  AND a.mid = f.f_id))
					LEFT JOIN `photo_album_photos` AS p ON ( a.id = p.aid )
					LEFT JOIN `members` AS m ON (m.id = a.mid)
					WHERE a.mid !=  AND p.pid = (SELECT `pid` FROM `photo_album_photos` WHERE `aid` = a.id ORDER BY `cover` DESC, `id` DESC LIMIT 0, 1)
					AND a.id = p.aid
					GROUP BY a.id
					ORDER BY a.last_update DESC

Error:
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 a.mid = f.u_id) OR (f.u_id =  AND a.mid = f.f_id))
					LEFT JOIN `photo_alb' at line 3