2-claude-alessandrini
3-alessandrini-12-
SELECT ART.ID_Article, MATCH(ART.ART_Auteur) AGAINST ('+claude* +alessandrini* ' IN BOOLEAN MODE) AS Poids, ART_TempsReappro FROM article ART, view_article VIA, architecture_article ARA, declinaison_article DEA WHERE DEA.ID_Article = ART.ID_Article AND ART.ID_Article = VIA.ID_Article AND ARA.ID_Article = ART.ID_Article AND ART_Diffusion = '1' AND (MATCH(ART_Auteur) AGAINST ('+claude* +alessandrini* ' IN BOOLEAN MODE)) GROUP BY ART.ID_Article HAVING Poids > 0 ORDER BY Vte6M DESC, ART_AnneeParution DESC, ART_MoisParution DESC Les livres de l'auteur claude alessandrini sur Unithèque.com