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,9250,9371,9151,6879,7952,6109,9273,8845,4632,6968,9148,9147,9176,9100,9129,9097,9089,9090,9150,9165,8993,9104,2104,8974,8975,9166,9124,9028,9054,9050,9141,9167,9026,8968,9078,9012,9022,9159,9101,9007,9157,9153,8972,9123,9061,9102,9018,6964,9114,9127,9055,9126,6880,9049,9225,9128,9079,8889,9033,9152,8990,8909,9119,9059,2609,9324,9004,9160,4640,9081,4849,8452,8976,9000,9106,9069,9132,9048,9138,9060,3855,9038,8462,8997,9098,9146,8978,8453,7489,9154,6963,9310,7865,9023,8241,6961,9002,9149,8943,9133,8912,8465,8243,2610,9408,8991,6881,9137,8938,6959,9241,9418,3027,9080,9051,9357,9266,8240,9125,9331,6208,4264,8973,8939,8989,9039,8999,9226,8985,8840,8495,7888,8885,6962,8316,9471,8469,9380,9397,8942,9416,5760,9272,9395,7381,9349,9025,9057,8339,8242,9393,6732,9024,9244,9402,9358,9056,9019,9228,8314,8468,5149,8970,9325,9248,7866,9291,7867,6854,6263,9156,7892,9288,9347,9229,9526,6966,9449,1823,8340,8984,9242,9243,9269,7770,5375,9379,8955,9490,9052,9487,6853,9486,9437,9485,8386,9399,9433,9483,9417,9482,9432,9481,9431,9480,9376,9475,9247,9474,8937,9473,9472,9047,9368,9373,9461,9245,9279,9460,9356,9459,8949,9458,8460,8983,8987,8994,9378,9446,8886,9027,9377,9444,9265,9443,9258,9414,8893,9441,9337,9440,9439,9401,9438,5329,9436,9435,8484,9041,9298,6232,8995,9434,8892,9394,9396,8940,9429,9428,9392,9427,9426,5431,9053,9415,9372,9280,5336,9405,9338,9355,9354,8891,9400,8529,6706,8945,7422,9122,8338,9274,9350,9351,8464,9381,8947,9332,9255,9254,9257,9032,8248,9375,9181,7471,9296,9313,9370,9249,1294,7894,9367,9031,9312,9359,8418,8315,8992,9353,6694,9352,7816,8982,9003,9237,8454,9348,9346,8950,9340,9271,8432,9335,2101,9330,9326,7923,9058,9311,8467,9184,3028,9297,9293,8246,8322,9292,6169,8834,8428,9008,5817,8250,9238,8969,8888,8981,8343,7893,9188,9246,8911,8878,8427,7391,8463,8318,8936,8986,8323,9227,8466,8887,2991,8880,7011,8865,4667,5831,9191,8852,7384,9190,8757,9189,8225,2461,9187,9009,5422,8851,9186,9185,8528,589,6967,9183,9182,8226,9180,7811,8735,8913,8473,8741,6261,8461,7420,8819,8247,6960,5816,8456,8884,8864,8429,7589,8508,8873,7576,8497,8341,7644,8898,8352,7813,8755,8827,8670,8734,8736,8414,7599,8272,8430,7386,6737,8525,8768,8728,7619,6240,4622,7814,6106,8700,8763,6108,7887,8818,8488,7585,8223,7590,3621,3846,8420,8417,8228,8433,3004,8858,3432,8227,8727,8740,3168,8738,8261,5182,8481,7387,6384,8847,8493,7650,8230,8861,7450,8733,8168,8232,8336,8163,8478,7328,5191,8480,8756,8874,8498,8850,8160,6487,6200,8839,5950,8739,7857,8846,7400,7649,7960,8829,6687,8440,8748,8275,8767,7606,8601,6982,8796,7451,8438,8233,8664,8647,7322,8743,7448,8723,8753,7480,8777,6490,8298,8239,8772,8754,7411,8724,8500,5040,8470,8750,8787,4429,8504,8441,8268,8276,8844,6405,3952,8520,4368,3170,7588,8213,8683,8654,8217,7428,8499,8752,8231,8830,6302,8000,8737,8138,7389,8730,7410,7432,3769,8671,8780,7329,8669,8214,2422,7620,7331,7449,8510,6406,8729,6408,8771,8526,5624,7598,8274,7971,8171,8079,7976,7137,8080,8608,8076,5175,8673,7490,7658,7493,6306,7379,8707,8674,8709,8695,7587,8479,8621,3680,8726,3254,7573,7330,2462,8717,4497,7229,7299,8607,8614,8603,7991,8332,8655,8527,8123,7815,6498,7385,8600,8170,8610,8437,6290,7390,8702,8423,7993,8084,8118,7987,7150,8237,7875,8235,8625,8626,8137,7992,8649,7989,8592,4000,7586,7632,8644,8028,8622,8122,7997,8618,8271,6733,8602,1818,7167,8611,8027,3163,8426,7996,7323,7301,8615,8613,8646,8145,7172,8119,7978,6691,7828,8117,8229,8609,7325,7581,8224,8619,6749,8023,8337,8234,6422,8045,7296,8136,7633,8335,7276,7173,8042,7222,7985,8591,8135,6513,7265,7135,7314,6383,7258,8005,6312,7312,7270,7291,3029,7774,3561,5924,6829,7426,7776,8862,5824,8216,9099,8334,3362,8786,8424,8381,5759,8215,8401,7577,9103,8784,8425,7642,8152,7624,7414,8616,7199,8477,7903,4920,7388,4745,8169,8391,7026,7021,7829,8487,7672,6688,8837,6692,5178,7583,7986,7168,7643,7025,7972,6022,2602,7491,5384,6484,8422,6885,6786,8357,8009,8485,8282,8516,8941,4612,8515,8238,8825,2003)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%61%' AND ( promo!='0' OR prixo!='0') ORDER BY ( (CASE WHEN site IN (1,3,4) THEN 10 ELSE 0 END) +1000-num+promo + (CASE WHEN prixo=0 THEN 0 ELSE ((prixo-prix)/prixo*50 ) END ) ) DESC,produit DESC,numErr153a