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