SELECT Publications.Id,Publications.photo, Publications.titre, Publications.Photo, Publications.Photo_texte, Fiches.Repertoire
FROM Publications, Fiches
WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Repertoire_No = 2137988401 and Publications.classement='Humour'
ORDER BY Publications.Tri desc,Publications.Entree desc,Publications.Id desc;
UPDATE publications
SET clic = Clic + 1
WHERE Id=#agricomhumour.Id#