SELECT ifnull(lightbox.image_id, 0) as lightbox_id, images.* FROM images left join lightbox on (images.id = lightbox.image_id and lightbox.owner_id = -1) WHERE images.id = 0862/images/SPC0853 LIMIT 1 [nativecode=1054 ** Unknown column 'images' in 'where clause']