SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo,CASE WHEN isable!=0 THEN photo WHEN wi1!=3 AND photo1_3!="" THEN photo1_3 WHEN wi1!=1 AND photo1_2!="" THEN photo1_2 ELSE photo END 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 prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9220,1844,8919,6945,8931,7842,8327,7709,8924,5138,9174,9037,6850,7153,7521,7833,7832,8921,8928,7004,8882,7184,9218,8326,7712,6734,9164,9158,9035,9130,7068,9117,7874,7219,9076,9075,9066,8914,8899,9036,9030,7854,9006,8398,8367,8930,6755,8364,8916,7734,4042,8363,8963,8894,8883,7737,9116,7750,8408,8324,7130,7858,8791,8375,7705,6754,4834,8946,9113,5438,8325,5890,7835,5407,7850,7851,3261,4591,5875,5427,6837,5768,7157,7062,5408,8370,5884,8491,7706,6758,5426,3789,8507,7735,7094,7307,6759,7715,8445,8521,7677,7063,5471,5468,4287,6740,7744,7671,5303,5798,7595,3788,4158,4759,6838)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a