SELECT Publications.Id,Publications.Photo_mini, Publications.Photo, Publications.Photo_texte, Fiches.Repertoire FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Repertoire_No = 2137989472 ORDER BY Publications.Tri desc,Publications.Entree desc,Publications.Id desc;
Cliquer pour agrandir #Output.Photo_texte#
Cliquer pour agrandir #Caricature.Photo_texte#

UPDATE publications SET clic = Clic + 1 WHERE Id=#Caricature.Id#