SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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=2 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 volume!=4  AND produit IN(0,7947,1844,9220,9174,8791,9409,7833,9301,6503,9520,9076,9035,8882,9450,9423,9422,5138,9006,8019,9130,9164,9066,8924,9037,9036,9116,8919,9075,8931,8963,1814,9113,7835,6601,5133,8916,7832,9389,5094,6602,9030,8946,7943,8921,5132,7854,9202,5108,8853,5407,8899,3196,8781,9016,9117,6734,9158,8848,7521,6599,6850,7874,3789,6142,8875,5427,7377,5408,8327,8018,8879,3261,7239,8883,4591,8773,7062,7184,7004,7734,4423,7216,6612,8721,8719,7951,8325,8398,5884,6461,7712,8370,7709,7219,8375,6502,5875,4422,8589,8894,7737,6013,8783,8507,8326,8324,8491,7130,8569,8612,7735,5890,7161,8725,8364,5896,8408,8047,7858,7935,8016,7094,5426,4834,4042,7157,7851,5768,5438,6754,6755,8363,8017,7562,3610,6403,6000,6143,7850,8125,8144,7677,7550,8445,8652,8521,7538,8046,3008,3023,7706,7355,7235,7289,7398,6759,5997,7715,8808,7744,5471,4491,7539,5303,7378,4287,7203,8072,6740,5468,7063,7595,6633,7353,4158,8871,7671,8095,7520,3788,4759,7546,7253,5798,8295)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND ( promo!='0' OR prixo!='0') ORDER BY ( (CASE WHEN site IN (1,3,4) THEN 10 ELSE 0 END) +1000-num+promo + (CASE WHEN prixo=0 THEN 0 ELSE ((prixo-prix)/prixo*50 ) END ) ) DESC,produit DESC,numErr153a