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=2 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,5366,6504,1840,7947,4654,1844,9220,7833,8812,9301,6503,9523,9522,9517,5969,8882,8815,8933,4650,5138,8900,2356,8019,1839,8920,8924,9303,8919,8918,8931,9322,1814,5134,1809,7835,6601,5133,8935,9304,9403,9398,7832,9390,8599,9389,9388,9384,5094,6602,5091,8926,4653,1811,7943,5135,8921,5132,4652,3827,7854,5108,9017,3777,5322,5407,8899,5139,3191,3196,7217,9016,8020,5136,6734,8434,7521,6604,6599,6850,6506,5473,8448,7874,3789,8366,6142,5140,7764,5427,7711,7484,5092,5985,7377,5408,8327,5315,8018,7009,7303,5316,5987,8562,5137,7841,6004,6124,7062,7184,6877,7004,7734,6505,6610,6597,7059,7216,6612,7710,2107,5111,5307,8365,5321,6603,7951,8325,6146,5967,8398,5884,6461,7712,7736,8370,6598,7709,7219,8375,5656,6502,7006,5875,8392,8589,5306,7737,4554,7523,6882,8507,8326,1812,8324,6564,7309,8491,7130,8569,8612,7928,7735,7486,5511,5433,7946,7374,6739,5890,6171,8593,8598,6001,8364,7488,7298,8408,6565,6127,7858,6609,7944,7935,8570,8016,7297,7048,8435,6210,5966,5470,5426,7300,7851,5768,5438,7567,5444,6754,8400,6755,5343,6874,8604,8596,8436,8363,8568,8017,7536,7562,6508,6000,8590,7950,6143,8606,7131,7294,8588,6151,8685,5437,6607,7930,6155,6140,5093,7533,7936,7295,7929,7569,5991,7937,7538,5409,8010,7941,7706,5435,5989,5434,5997,5436,7534,7744,5471,7311,7067,7939,7056,7487,6139,5301,6002,7049,7539,7485,5303,7378,6740,5468,7957,8399,7063,5873,6613,5107,6633,5738,7532,7537,6876,6875,3788)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prixgros*(100-promogros)),produit,numErr153a