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