SELECT ga . * , u.name AS creator, (
SELECT COUNT( * )
FROM galleryAlbumImage
WHERE albumID = ga.albumID
AND published =1
) AS imagecount
FROM galleryAlbum AS ga
LEFT JOIN user AS u
USING ( userID )
WHERE ga.albumID =
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 '' at line 10