SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prixgros,promogros,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=1 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prixgros!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,7943,9390,6504,5094,9384,9389,6601,6503,5133,1814,7377,3191,3196,5108,5132,7947,9016,8599,6506,8569,9398,6461,7951,8588,6565,7216,7295,6603,8589,8612,7562,7306,7935,6602,6505,7946,8570,8590,7950,6564,5511,6502,7303,7309,7936,5093,5092,8604,7210,6604,6566,8596,7941,7937,6508,7313,8587,7957,7290,7378)  AND prix>45  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prixgros*(100-promogros)),produit,numErr153a