SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=2 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,7993,9284,9234,8757,8867,7543,9290,6109,9353,8706,6879,2104,9376,7382,3002,9281,9393,9225,9287,7556,7545,6106,8738,9250,6349,7558,9526,9282,8342,9402,9326,9395,9337,9293,9292,9413,9090,9151,7328,9458,3171,7541,9286,9471,9266,9175,7450,7554,4632,6108,2461,9245,6804,9148,9428,3621,9429,9415,9474,9283,9300,9433,8736,9153,9346,2991,9399,9379,8735,9147,4429,9355,9258,9392,9459,9271,9269,5535,9406,9247,8834,9378,3168,9285,8734,9089,9274,9439,8768,9298,9181,9062,9397,9449,9405,9436,9100,6384,9377,9400,9418,9242,9191,8741,9461,5950,9226,8827,9460,9354,9149,9313,8727,9457,9414,9446,9401,8959,9015,9054,9372,9368,9350,9311,9106,7480,9254,9349,8670,9119,9257,9340,9417,9324,9104,8868,9038,8796,9150,9236,8865,8163,7451,9078,9371,7542,9325,9001,9370,9345,9343,9358,9374,9435,9348,9396,8780,8160,9438,9437,7137,9434,8673,9299,8754,7387,8316,5040,9381,9515,9513,8656,9512,9490,9333,9330,8740,9124,9487,9486,9485,9331,8643,6390,9472,9380,9152,7323,7897,9227,8844,9394,9373,9351,9427,2610,9189,9357,7448,9356,9069,8755,9246,9359,9338,9235,7493,9233,8772,9232,9272,9231,9288,9335,9347,9098,8750,9367,6302,8861,7139,4368,8170,9297,8960,9416,8763,9255,7449,7329,9187,9007,9123,9483,9482,9481,9480,9475,9473,8447,9237,3769,9166,7267,8997,8581,9273,8845,9312,9229,9444,9443,9188,9441,9440,9125,8449,7299,9432,9431,7952,9146,7331,9445,7898,9243,8079,9184,9426,7976,9279,6964,8654,4640,8874,9092,7922,7960,9375,7416,9028,9131,5624,8671,6961,8990,9132,8243,9241,2422,9228,9352,3170,6306,9280,8913,3855,7226,7268,8080,8846,6963,6968,8583,9332,6296,9200,7895,7368,9128,8573,1294,6492,9296,9185,6408,8600,9183,6880,8889,9452,7330,9180,6405,7971,7471,8968,8730,7489,8592,7892,9126,8818,7731,6406,7987,8321,8603,5326,8887,9265,8893,8733,8756,8873,9165,7991,9249,8426,7322,8787,8137,7544,9238,6291,4497,6962,8972,8608,9248,8864,9012,9190,5760,9186,8939,8642,9453,9310,9451,9182,7296,9033,8962,8339,8993,9003,8453,8615,6204,6959,9244,8647,8241,9408,9138,8027,8886,8123,8572,6553,8978,8992,8578,8949,8748,9027,8314,6208,8591,7515,8610,9176,8323,9026,8303,8851,8912,8709,1823,8584,8888,9002,8480,8145,8609,8892,9048,9127,9004,9122,8982,8452,8829,9061,8726,8302,8039,7150,8319,9129,8607,8577,6960,8315,9057,8171,8340,8242,7896,9160,9134,9052,5649,7437,6859,8683,8611,8981,7893,9051,8576,7381,7770,9023,8456,7606,6290,8911,8138,5149,8397,9137,7363,8674,6169,9024,9060,9039,8343,4849,8989,8975,8341,5431,9025,8037,7725,8660,8261,8974,9000,8830,8579,8529,9047,8942,7411,7888,8034,8084,8575,8880,8240,9018,6966,8622,8601,8248,7867,8986,8621,8991,8619,8250,8029,8702,7422,2609,4432,8669,8987,6487,9022,8476,7391,7366,9041,9032,6232,8969,9159,8819,8770,9031,8429,7384,2101,8462,8495,8947,8984,9081,8753,9291,8484,9009,8231,9114,8649,7229,8777,6955,9008,8767,8574,8940,7142,3004,8937,6562,8465,8909,5329,9157,7865,8469,5831,8970,6694,8499,8318,8891,7386,3846,8995,8427,8771,8858,6498,7204,8038,7220,9167,8945,8000,7420,8467,5422,8026,8728,6737,8655,8004,9101,8983,8955,8322,8428,8700,8528,8943,6318,3027,4205,7866,8508,7555,7978,589,9080,6706,8175,9050,8711,9141,7599,8460,8936,8352,8454,3432,8999,8994,4264,9097,8432,6853,5375,4667,4622,8737,5336,8246,8884,8040,9049,9154,6854,8023,8464,9056,7432,4678,6881,8644,3163,3989,7589,8950,7729,9053,6422,8602,7887,7923,8466,7590,9133,8168,7996,8985,8695,8119,8717,7857,8338,8664,8468,5817,8463,8743,8414,8336,8646,8500,8520,8229,8486,8224,8235,7650,8707,7598,9055,8527,6240,7992,9059,8118,8626,8847,7814,8852,8028,7282,8042,6732,3029,8478,7813,8233,8461,8504,8526,8225,8620,7576,8271,8878,8976,8430,7361,7921,8226,8230,8122,8335,8274,8222,7364,8618,6261,8232,8752,8510,7222,7989,8739,9079,6490,8498,6472,7428,8076,8839,8275,8228,8724,7424,7314,9019,8613,5191,8217,7632,8522,8437,8214,7985,7586,8239,7588,8973,7619,7383,8136,6317,8386,7442,8850,8723,8729,7436,7312,2462,8227,8470,7167,8938,7362,8885,8237,8614,8433,1818,8146,7894,8473,7325,7446,8213,3680,7430,3861,6967,7633,6864,8247,7173,9102,7811,8525,7447,9077,5182,6200,8420,7438,7258,7649,3918,4000,7444,2602,7658,8045,3028,7372,7585,8625,7365,8641,8441,7782,7972,8264,5332,9058,7573,7441,8332,8479,8455,7997,8418,8497,7519,7291,6513,6727,8493,8298,8268,6958,8417,6263,7783,7781,7265,5816,7644,8481,8840,7172,7011,7301,8276,5175,7816,6407,6687,5293,8078,8488,6383,7135,8223,6312,8438,7815,6650,7429,8117,7367,8272,7371,8005,7587,3254,7620,5325,6871,6982,7276,8423,6868,8234,7828,6691,7581,8083,8898,7379,7390,7233,7435,7427,8440,7389,7400,7302,7385,8135,7443,7490,7270,7410,6733,6668,8337,7504,7423,7021,6885,7577,6595,8941,9099,5924,7491,8169,7419,8357,8487,7724,7026,8616,8152,8515,5384,8837,6800,6688,8477,8334,7434,7414,8033,7643,8786,6484,8159,7025,2003,3952,6667,5824,7168,7776,8282,6829,8424,4612,7727,8571,8422,7426,7624,7440,5178,7498,4745,7642,8425,7583,6866,7829,7875,6101,8516,6749,7017,8381,6692,3362,7373,8215,7870,6022,9156,6096,9103,6284,8862,8784,8825,8580,7726,5759,8009,8391,7672,7445,8238,7392,6919,7730,8401,7774,7903,8485,6983,8216,6786,6181,3561,7986,7659,5330,8769,9088,7199,7388,4920,6314,7979)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a