SELECT Publications.Id, Publications.Photo, Publications.Photo1, Publications.Photo2, Publications.Photo3, Publications.Photo4, Publications.Photo5, Publications.Photo6, Publications.Photo7, Publications.Photo8, Publications.Photo9, Publications.Photo10, Publications.Photo11, Publications.Photo12, Publications.Photo13, Publications.Photo14, Publications.Photo15, Publications.Photo16, Publications.Photo17, Publications.Photo18, Publications.Photo19, Publications.Photo20, Fiches.Web FROM Publications INNER JOIN Fiches ON Fiches.Repertoire_No=Publications.Repertoire_No WHERE Publications.Repertoire_No = #attributes.Repertoire_no# AND Publications.Actif='3' AND Publications.niveau3='photos' AND Publications.Tri = '999999' ORDER BY Publications.Id desc;