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=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,7558,7543,9413,7731,9284,9201,8867,9374,8031,7961,6804,4432,8799,8582,9236,9281,8706,3002,7556,9515,9514,9513,9512,8656,7545,9287,8643,9290,7542,5535,7554,8642,9286,6291,9299,7541,8576,7544,9282,6296,6390,6492,9283,7726,9457,7368,9453,9452,9451,9445,8577,8711,5537,6491,8584,9406,9345,9343,9300,9285,9015,6318,7725,9200,9235,9234,9233,8303,8039,9232,8575,9231,7366,8037,8034,7363,7282,8302,7364,8962,7204,8004,7361,6317,7362,6096,8029,7365,7372,8083,7302,8078,7367,6407,7371,7373,8033,6314,7979,7727,8475,8710,8714,8571,6642,8112,7263,8713,6082,8106,6332,7261,7260,6311,6592,8151,7963,8580,6101,7809,8159,6797,6800,8259,8712,7962,8716,6301,8175,6313,6441,6458,8715,8035,7262,7510,8105)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND ( promo!='0' OR prixo!='0') ORDER BY (id-(20*num)) DESCErr153a