SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es txt,prix,promo,prixo, photo, 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,7139,8031,7961,6804,7921,8572,9131,4432,8799,8582,9236,5649,9281,8706,3002,7556,9515,9514,9513,9512,8656,7545,9287,8643,9290,9175,8581,8342,8522,8583,7542,5535,7554,8642,9286,6291,9299,7268,7541,8576,7544,9282,6296,6390,7267,6492,9283,7726,9457,9456,9455,8578,7368,7226,9454,9453,8579,9452,9001,6859,9451,9445,8573,8577,8711,8960,7897,5537,8959,7142,6491,8584,9406,7922,9345,9343,9092,9300,7220,7416,9285,8574,9015,7898,6318,7725,9200,9235,9234,9233,8303,8660,7895,9062,6553,8447,8039,5326,9232,8575,9231,7366,7515,8037,6204,4678,8034,8397,3989,8321,8038,6562,7363,7282,8302,7364,8962,9134,7204,8040,8476,4205,7424,7555,7896,8004,7361,6317,6955,7437,7362,6096,7446,8029,8222,7495,7436,7430,7383,7365,7729,7444,7372,3918,7438,6727,8083,8264,5332,7782,7447,7442,7302,5325,8078,6958,7783,7367,7519,6407,7371,7441,7427,7781,7429,7373,7435,7233,6650,7443,6668,7419,6818,7724,7440,8033,6181,6926,7423,6314,7434,6582,7017,7979,7660,7727,8475,8710,8714,8571,6642,9088,5827,6667,8112,7392,7264,6326,6627,6671,7659,7263,6942,6983,8713,6175,6082,6919,6816,7445,5330,6646,6941,8106,6332,6581,7730,7526,7261,8132,7260,6311,6592,7504,8151,7230,7499,7498,7963,7870,8580,6101,7809,8431,8159,6797,6800,8259,8712,7962,8716,6301,8175,6595,6313,6441,6458,8715,8035,7262,7211,7510,8105,7728,6558)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a