Fehler

MySQL: Unknown column 'b.locid' in 'on clause'
SELECT a.*, b.photo, b.id AS thisphotoid, b.folder, b.tb_prefix, c.titel, c.headline, c.id AS thisalbumid, b.locid, d.location FROM st_fa_comments AS a, st_fa_fotos AS b, st_fa_alben AS c LEFT JOIN st_fa_locations AS d ON b.locid = d.id WHERE c.siteid=0 AND b.albid=c.id AND a.photoid=b.id AND b.status='a' ORDER BY a.datum DESC LIMIT 3