SELECT DISTINCT Publications.idModele AS numMod, categorie, collection, titre, auteur, annee, nb_pages, resume, sommaire, motscles, isbn, commentaire, nouveaute, epuise, reimpression, ref, recompenses, temoignages, sur_place, prix_tarif, prix_offre, poids, ouacheter, errata FROM (((((Publications LEFT JOIN (SELECT * FROM Publications_variantes WHERE actIf = true) AS Publications_variantes ON Publications.idModele = Publications_variantes.idModele)) LEFT JOIN (SELECT * FROM Publications_linguistique WHERE langue=1) AS Publications_linguistique ON Publications.idModele = Publications_linguistique.idModele) LEFT JOIN (SELECT * FROM Publications_variantes_linguistique WHERE langue=1) AS Publications_variantes_linguistique ON Publications_variantes.idModele = Publications_variantes_linguistique.idModele And Publications_variantes.idVariante = Publications_variantes_linguistique.idVariante)) WHERE Publications.actif = true AND ( categorie = 20) ORDER BY annee DESC, prix_tarif ASC, prix_offre ASC, poids ASC

erreur de nomenclature