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