SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND volume!=4  AND produit IN(0,9433,7545,3002,9371,9356,5950,2461,6109,7543,8584,8576,9378,8834,8031,8735,8080,9225,8617,9413,7556,9402,9399,9474,9395,9392,8757,9471,9393,9415,8736,9458,8734,9337,8865,8763,9358,9400,7554,9405,9325,6804,7961,9346,9397,3621,9293,9379,9313,8768,8741,9331,8754,9435,9359,2991,9437,9414,9269,8738,9274,9440,9428,9266,8727,9272,8755,9357,9242,8827,9355,8846,9436,9475,9380,9348,9326,8670,9438,9377,9297,9368,7450,3168,9396,9372,9394,9290,9340,8796,6108,9324,6106,9347,9245,9254,8873,9298,9417,8740,6384,9446,9481,9247,9271,9335,9373,9459,9376,9257,9284,8868,9268,9350,9367,8673,9287,9227,7451,9349,7328,9250,9432,9439,9441,9375,9353,9288,8818,8845,8844,9281,9427,9370,9381,8730,9332,9192,9292,8750,9226,9278,8163,8780,9352,9265,7952,9255,5040,9434,9279,9374,7137,7480,8867,6349,9311,7323,7448,8160,8787,8864,9401,7558,7449,9445,8733,9246,9354,9526,9515,7329,7411,9514,8168,9513,9512,9228,9499,9498,4368,9289,9495,9492,9491,9490,9487,8742,9486,8749,9485,9483,9482,8829,9480,8772,7993,7493,9473,9472,9461,3769,8756,9460,4429,9249,8170,3170,9234,9449,9444,9443,9282,8592,6406,9248,9243,8079,9312,9431,8851,8874,7322,6408,3171,9426,9191,9280,8671,9429,5535,8770,7299,2422,9188,9275,5624,8603,7330,8000,6302,7150,9182,8608,9201,9457,7976,9299,4497,8706,9187,9181,9194,9286,9351,8709,7331,7541,9283,8695,7542,9338,6306,9406,9333,7991,8621,9330,8611,6290,8607,7960,8647,8600,6405,9296,7987,8123,7267,8861,8717,8615,8753,8171,9015,7296,9276,8748,8778,9273,9345,9343,9270,8858,7139,9258,9244,9310,8767,9300,6390,8651,8622,8726,9238,9237,9285,7971,8027,8609,8601,9200,8771,9199,9198,8737,9197,8591,9453,9196,8137,9452,9195,8715,9451,9193,8145,8649,9190,8710,8702,9189,8084,9186,8683,9185,9184,8026,9183,6291,8669,8674,9180,8619,6296,9236,8777,9235,6492,9233,9232,9231,8138,8658,8643,7268,8830,8656,8581,8878,5537,8620,8626,8646,8578,8728,8303,8828,8819,8642,8654,8602,8426,8119,7368,8700,8122,7731,7229,8644,8716,8573,9291,8583,8655,7962,8610,9241,8743,7387,8850,8792,7978,8582,8962,7544,6318,7142,8707,8711,6498,8579,7366,8039,8112,8729,7515,8572,7992,3163,6553,8618,8118,8574,8028,8852,6491,7204,6422,8659,8175,8577,8034,8076,7725,7555,8847,7363,8575,8037,7293,8839,8224,8029,7314,8038,7282,2462,8040,7172,9456,9455,9454,7989,8799,7364,8724,8042,8641,8146,8136,8752,8023,8723,7361,7996,7222,8302,8004,7220,8613,7985,6562,5649,3029,7325,4432,7362,7173,3680,4456,8614,6317,7312,7372,8229,1818,8739,6513,7291,7167,5481,7258,7365,8045,8078,7135,8117,7276,7519,6383,6312,7367,8083,7301,7396,8005,6407,8625,7371,7302,6102,7270,8135,7997,7233,7265,7202,8786,8116,8106,7724,8053,8833,7231,8758,8760,8838,8571,7727,7198,8150,7281,8142,6326,8152,7138,6382,5565,8011,8616,7199,6314,7979,7526,7260,7494,7272,7274,8759,8259,6344,6458,7283,8085,6484,7728,6866,7335,7499,8103,8087,8088,8475,8159,7211,7213,6797,8092,7271,8605,6648,7336,7844,8169,7168,6800,7726,6581,7261,8714,6592,8785,8835,8836,8713,8863,8672,8795,8826,7259,6331,8769,6642,8131,7263,6441,8837,8712,6558,7963,7510,7972,7373,6022,8825,6096,8784,8862,8033,8580,7262,7953,7273,8049,6052,8009,8035,8132,6311,7966,8151,8238,6301,7984,7200,8089,7504,3649,7809,7998,7230,7227,7986,6341,8161,6313,6595,8105,6082,7264,6332,6627,4426,6582,6101)  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