SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,7714,7576,8964,3140,2609,9038,8937,8954,8963,9039,3855,8955,2610,4591,5760,3027,8948,8660,8865,4663,5149,6157,6706,8819,8414,7644,6169,5816,8484,8873,8249,8246,8456,4678,8864,3028,8700,8352,6694,8470,8827,5182,4667,5190,8247,4147,5831,8825,8299,7677,3004,2598,8818,9240,4622,8245,9239,4143,7667,8706,6787,8420,8874,8439,4626,8866,3846,7890,3918,8789,9242,8820,9241,9238,9237,3179,8594,4279,9236,8697,4266,9235,7680,9234,8766,9233,8822,9232,3168,9231,7826,8683,8486,9230,7668,9228,3861,9227,8297,8592,8669,8787,9226,8767,6731,8707,8488,8312,7573,8765,8699,8298,3621,8656,8781,6375,4155,8424,7133,7480,8709,8673,7137,8626,6384,8674,8160,4429,8437,8643,8418,7952,5040,5950,8708,8698,8696,3362,8417,7239,5811,5004,8782,7822,7236,3254,8581,3170,6238,8671,6349,4497,7870,3171,3008,7716,8591,6362,7574,5009,8642,3007,8580,4432,5031,5535,8426,4485,6947,8585,6291,7150,4149,5542,8583,7954,8023,8573,8584,8577,8579,8438,3769,7669,7729,7682,8641,4250,5541,8578,3163,6390,7139,7142,8425,7238,6650,8311,4423,7268,7956,8302,7731,7732,8576,6513,8625,3610,8575,7241,8572,4422,3609,8303,7580,7724,7996,7997,7733,7725,5030,6691,6035,7258,3023,8515,7265,7828,8574,7715,7965,5759,6713,7135,7995,7643,7204,7964,6217,7235,8423,6361,7581,6692,6970,5537,6022,8128,5649,8487,6716,7690,8571,7727,8422,6501,8050,8257,4268,7563,7140,7821,7483,7642,7758,7753,6723,8162,8295,7959,8120,7179,8067,6690,4158,8304,8056,6484,7994,7335,6638,7254,6948,7253,7683,7823,7829,6652,6160,8516,7577,7152,7876,6352,8100,6365,7261,8165,8131,7257,6682,7953,7718,6637,6704,7756,7831,6661,6220,4587,7579,2606,7671,7726,8474,6688,6478,6509,8471,5757,8476,7681,8055,7679,8490,6707,6247,3026,7640,7260,7824,7262,6273,6340,5798,6646,3479,2608,6290,7665,5565,8328,6382,7825,7871,8489,7639,7830,7960,6709,7998,6708,7723,6286,6296,7578,7717,6972,3844,6705,8582,7267,2611,7572,4146,2825,5178,7747,8485,6818,4597,9088,6894,4612,3002,2602,6786,6655,7730,4491,7264,7319,4426,6949,7872,7336,8823,7966,7868,7889,7147,6364,6353,7177,7138,7474,7247,6642,6376,7873,8826,7748,8360,8357,7203,7259,8672,7263,6344,8051,8093,8259,7903,8475,8161,8129,7728,6680)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%' ORDER BY (prix*(100-promo)),produit,numErr153a