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,1840,4654,1844,9220,7833,8812,8882,8815,8933,4650,5138,8900,2356,1839,8920,8924,8919,8918,8931,5134,7835,8935,7832,5091,8926,4653,5135,8921,4652,7854,3777,5322,5407,8899,5139,5136,6734,8434,7521,6850,5473,8448,7874,3789,8366,5140,7764,5427,7711,5408,8327,5315,7009,5316,5137,7841,7062,7184,6877,7004,7734,7059,7710,2107,5307,8365,5321,8325,8398,5884,7712,7736,8370,7709,7219,8375,7006,5875,8392,5306,7737,8507,8326,8324,8491,7130,7735,5433,6739,5890,8364,8408,7858,7048,8435,6210,5470,5426,7851,5768,5438,5444,6754,6755,5343,6874,8436,8363,7131,5437,5409,7706,5435,5434,5436,7744,5471,7067,7056,5301,7049,5303,6740,5468,7063,5873,3788)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a