SELECT *,a.decor AS adecor,a.dessin as adessin,a.ident AS aident,a.tarif as atarif,a.prix2 as aprix2,a.photo AS aphoto,a.nom AS anom,a.new as anew,a.dispo as adispo,a.stock as astock,d.new as dnew,c.new as cnew,b.nom as bnom,b.ident as bident,c.nom AS cnom,d.nom AS dnom,d.ordre as dordre,z.ident as zident,z.ordre as zordre,z.nom as znom,z.nomrw as znomrw FROM (fdp_article AS a,cat_biscuit AS b,fdp_collection as z) LEFT JOIN fdp_sdecor AS c ON (c.dds=0 AND a.dessin=c.ident) LEFT JOIN fdp_decor AS d ON (d.dds=0 AND a.decor=d.ident and d.collection=z.ident) left JOIN cat_format AS f ON f.ident=SUBSTRING(a.ident,4,3) LEFT JOIN cat_forme AS g ON g.ident=b.forme LEFT JOIN fdp_tarif AS l ON l.ident=a.tarif WHERE a.dds=0 and boutique=1 AND b.dds=0 AND b.ident=biscuit AND noaccent_com LIKE '%nouveau%' and d.ordre<>0 ORDER BY a.new desc,case when a.dispo>=1 then 1 else 2 end,a.dispo desc,g.ordre,f.ordre,b.ident,z.ordre,d.ordre,a.decor,a.dessin asc