SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,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 prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,1840,8791,9067,8812,9035,8815,2356,1839,9164,9171,9064,9222,8920,8929,9139,9037,8810,9093,9036,9075,9043,8931,8869,8935,8908,8916,8917,8926,8971,8921,9224,3777,8813,8899,8964,3140,9179,5136,8434,7521,7864,6850,8910,5473,8954,8448,3789,8366,5140,7764,7863,9096,5315,7009,3261,5316,5137,7841,7184,7004,7734,8523,5321,7712,7219,8392,8894,5306,8507,8326,8324,7133,8491,7130,7735,4656,8364,8435,6210,5470,5426,5768,4155,5343,8436,8446,8363,7131,4663,8443,5437,7677,6974,5409,7667,7862,7890,8221,7669,7680,7706,7668,6773,5436,7716,4266,7610,5471,7753,6249,8313,5301,4287,6740,8399,7615,7825,6286,6705,4158,5278,7717,8257,7616,4597,6996,7639,7000)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a