SELECT Fiches.Web, Publications.Id, Publications.width, Publications.height, Publications.Photo, Publications.Titre, Publications.Description, Publications.Photo1, Publications.Divers1_t, Publications.Divers1, Publications.Photo2, Publications.Divers2_t, Publications.Divers2, Publications.Photo3, Publications.Divers3_t, Publications.Divers3, Publications.Photo4, Publications.Divers4_t, Publications.Divers4, Publications.Photo5, Publications.Divers5_t, Publications.Divers5, Publications.Photo6, Publications.Divers6_t, Publications.Divers6, Publications.Photo7, Publications.Divers7_t, Publications.Divers7, Publications.Photo8, Publications.Divers8_t, Publications.Divers8, Publications.Photo9, Publications.Divers9_t, Publications.Divers9, Publications.Photo10, Publications.Divers10_t, Publications.Divers10, Publications.Photo11, Publications.Divers11_t, Publications.Divers11, Publications.Photo12, Publications.Divers12_t, Publications.Divers12, Publications.Photo13, Publications.Divers13_t, Publications.Divers13, Publications.Photo14, Publications.Divers14_t, Publications.Divers14, Publications.Photo15, Publications.Divers15_t, Publications.Divers15, Publications.Photo16, Publications.Divers16_t, Publications.Divers16, Publications.Photo17, Publications.Divers17_t, Publications.Divers17, Publications.Photo18, Publications.Divers18_t, Publications.Divers18, Publications.Photo19, Publications.Divers19_t, Publications.Divers19, Publications.Photo20, Publications.Divers20_t, Publications.Divers20, Publications.url1, Publications.url2, Publications.url3, Publications.url4, Publications.url5, Publications.url6, Publications.url7, Publications.url8, Publications.url9, Publications.url10, Publications.url11,Publications.url12, Publications.url13, Publications.url14, Publications.url15, Publications.url16, Publications.url17, Publications.url18, Publications.url19, Publications.url20 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.niveau5='1' AND Publications.Entree <= #CreateODBCDate("#now()#")# ORDER BY Publications.Tri desc;

#attributes.Titre#