SELECT * FROM photos WHERE photo_gallery = 1 * - p.id SELECT g.gallery_id, p.id, p.path FROM photo_gallery g, photos p WHERE p.photo_gallery = g.gallery_id AND g.leadphotos = p.id AND g.gallery_id = 1