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,9383,6596,9388,3827,9220,1844,7943,8919,6945,7110,4650,5656,8931,9382,7842,8327,7709,8924,9302,8019,9522,9517,5138,5366,9322,9390,7476,8562,6504,7482,7470,6459,1839,5094,6850,1840,9384,5111,7153,9389,7945,7475,6004,7522,7478,9303,6611,7521,6601,7006,6503,8586,7833,5745,4652,7218,5133,9301,6127,1814,2356,7377,7477,7949,7832,3191,9304,8900,5091,9430,8921,3196,8928,7473,8933,8365,7004,9403,5108,8882,1809,5322,5132,7184,8597,7947,7523,6599,8920,8326,6124,7938,5136,8016,9016,8599,5473,7712,4653,5139,6734,8593,8918,7008,6610,8595,6597,5315,6506,8569,7940,7068,6609,9017,5134,1811,7874,7944,7219,9398,7009,7565,7564,6461,4654,8899,8926,7854,7764,6612,8398,5135,8020,7005,5994,8367,7131,6755,5987,5316,8364,7734,5140,8363,7736,5433,8935,7737,7955,7750,7059,7951,5444,7217,8568,7711,5307,8408,7841,8588,8815,8324,6145,6565,8812,7130,7858,7472,7486,5966,8366,5443,7216,5137,5306,7942,8923,2107,7294,6171,8375,7705,7048,6754,6598,5967,6000,6464,5470,6877,5321,8606,1812,7374,6739,7536,8685,7297,6151,5439,5438,5437,8598,6143,6607,6155,7928,8325,5890,7835,7930,5407,7484,7295,6603,8434,4554,8589,8612,6882,7562,7306,7851,7935,6210,8448,6602,8018,7929,6505,7946,8570,6846,5875,8590,7950,5427,8435,6844,8436,6564,5991,5511,5768,6502,5435,7062,5408,7303,7538,7309,7936,8370,5093,5092,8392,8604,7061,5884,6874,5434,5409,5354,8400,7010,8491,7706,7210,6604,7488,5426,6566,6847,3789,8507,7735,5436,8596,5343,7941,7937,7539,5997,5989,8017,5440,7533,7485,8010,6843,6508,7939,5873,7313,8587,7063,5471,7957,7290,7487,5468,7378,5301,7056,6845,6740,6875,6876,7744,7067,6842,7534,5303,6633,7710,6841,6647,5738,5107,6613,7532,7311,7154,8399,7537,5969,3788,6139)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prixgros*(100-promogros)),produit,numErr153a