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,8449,7558,7543,9413,7731,7382,9284,9201,8867,9374,8031,7961,6804,7921,9131,4432,8799,8582,9236,9281,8706,3002,7556,9515,9514,9513,9512,8656,7545,9287,8643,9290,9175,8342,8522,7542,5535,7554,8642,9286,6291,9299,7541,8576,7544,9282,6296,6390,6492,9283,7726,9457,7368,7226,9453,9452,9001,6859,9451,9445,8577,8711,8960,7897,5537,8959,6491,8584,9406,7922,9345,9343,9092,9300,9285,9015,7898,6318,7725,9200,9235,9234,9233,8303,8660,7895,9062,8447,8039,5326,9232,8575,9231,7366,8037,6204,8034,8397,8321,7363,7282,8302,7364,8962,9134,7204,4205,7424,7896,8004,7361,6317,6955,7362,6096,8029,8222,7495,7383,7365,7729,7444,7372,3918,6727,8083,8264,5332,7782,7302,5325,8078,6958,7783,7367,6407,7371,7427,7781,7429,7373,6650,6668,6818,8033,6926,7423,6314,7434,7979,7660,7727,8475,8710,8714,8571,6642,9088,5827,6667,8112,7392,6671,7659,7263,6942,6983,8713,6082,5330,6941,8106,6332,7730,7261,7260,6311,6592,8151,7963,7870,8580,6101,7809,8431,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 (prix*(100-promo)),produit,numErr153a