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