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=1 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,9340,9335,9377,9245,2104,9144,6879,9254,8735,7892,9265,9356,9368,9526,8224,9490,9487,9486,9485,9483,9482,9481,9475,9480,9474,9473,9472,9446,9471,9461,9460,9459,9458,9255,9449,9444,9443,9441,9440,9439,9438,9437,9436,9435,9434,9433,9432,9431,9429,9428,9427,9426,9418,9417,9416,9415,9414,9408,9258,8622,9354,9119,9105,9054,8780,9269,8778,9024,9145,9244,6109,9226,8889,8742,2461,9032,8834,8736,7322,8741,8994,6968,9405,9402,9401,9400,9399,9397,9396,9395,9394,9393,9090,9392,9150,9028,9381,9380,6108,9229,9379,9376,9375,9147,9149,9373,9372,9371,9370,8945,9367,9359,9357,9355,9353,9106,9352,9351,9350,9349,9348,9012,9347,8737,9346,9199,9198,9197,9338,9196,9337,9195,9194,9193,9332,9192,9331,8830,9146,9191,9330,9326,9190,9325,9189,9324,9188,9313,9187,9312,9186,9311,9185,9132,9184,9183,9298,9182,9297,3621,9181,9296,9180,9293,9292,8673,9288,6384,9114,9280,9153,9279,8913,9152,9274,9273,9272,9271,9148,9266,9257,9250,9249,9165,9248,9247,8997,9246,8670,9243,9242,9241,9238,9237,7137,5950,9031,7451,9227,9225,2991,9089,8738,9310,9151,9291,8846,8163,8912,8819,8757,9125,9123,8626,9122,8756,8861,8827,9104,3769,8829,8845,9055,9228,8138,9176,9069,9160,8772,9378,9002,8880,5624,8796,8603,8993,8784,8763,4640,8243,9138,9137,8873,9126,8171,9124,8080,8893,7329,9004,4632,8850,8992,7952,9009,7987,8750,8787,8727,8749,7976,8991,9081,9080,7993,8986,8733,9098,8592,9056,8874,8768,9051,8969,9047,9041,9039,8453,9159,9157,9057,8887,9025,8858,9141,8241,9008,9007,7888,8123,9003,7387,8462,8658,3855,9000,9128,8999,9127,8995,8734,8469,8771,8909,9110,8984,8983,8777,8461,8982,8981,6961,7893,7489,8891,8314,8591,8972,8970,8989,8966,7867,9061,9060,8707,9059,8888,8323,8949,8499,8767,8947,9053,9052,8940,6960,8939,8671,8865,9049,8936,9033,9100,8911,9027,8892,8465,8340,9019,6880,8728,8886,8884,6232,8683,6959,8119,8315,8608,8619,6208,8233,8729,8621,8028,8987,7606,8851,8339,9129,8617,8726,8978,8730,8717,7992,7989,8885,8852,9022,8950,7887,8615,8709,8559,6964,8974,8079,8740,8937,7293,9166,8466,8240,9156,8118,8480,6854,8702,8753,8600,8250,8275,8743,6302,8655,7480,8818,8878,4368,6169,7331,7420,8452,4429,8160,8651,8611,8454,7384,8601,6261,8467,7299,8748,9101,8646,8862,8864,6963,7985,9097,8322,8427,8644,8607,7330,7991,8754,8610,6966,8647,8973,8510,7391,7996,8609,5329,8468,4497,8618,8847,8664,8955,8739,9133,2609,3846,8674,8122,7960,8230,6306,9102,8723,8460,8695,8433,8084,8145,8316,7493,8724,1294,7632,9058,6962,4849,7814,7649,8226,1823,7588,8566,8463,8318,8235,8508,6240,7381,8526,8527,8437,8825,8529,8669,8470,8027,8564,8649,7229,8976,8248,8246,8567,7172,5336,3432,8420,7971,6290,5760,5422,7816,8414,2101,8943,6406,8343,8341,5149,8213,7599,8136,6405,5817,8231,8076,8613,9167,589,8242,7923,3128,8429,7386,8525,9154,7586,8505,7650,8261,8276,2610,5481,6408,7866,8271,6737,6422,8042,7865,7857,8614,8237,3680,8602,8137,8432,8232,9079,8247,4264,8520,7811,8500,7590,8274,8335,5431,8484,6498,8336,7978,7589,7312,6200,3029,8473,8168,8239,6383,8985,7328,7173,8272,8332,8654,8481,7633,8430,8228,6887,8456,8938,8898,8170,5191,7585,8352,8338,8478,8223,7894,7291,8528,7644,7815,8426,6263,8418,8217,6312,7011,6706,7400,7899,8214,7813,7619,8441,8406,7576,5816,6982,8659,6692,8225,7379,8005,8417,7598,8117,3027,8438,7587,7596,8423,4456,3254,6691,7620,8298,7828,5175,8425,7410,8234,8498,8440,8504,8479,8135,3952,7452,6881,7301,6102,8497,6967,8381,8227,8386,6733,7490,8268,8337,6732,7658,9358,8023,8839,9103,8700,8752,8625,7449,7167,7997,7972,7258,8488,8833,8334,8267,7998,8116,8496,8758,7672,7168,6238,4922,3844,7022,6972,8053,6886,8516,4426,7624,8236,6885,8218,8477,9142,6199,8835,8485,7776,8401,9020,8011,7425,7822,8838,7641,7336,6688,5824,8422,7871,7607,7259,8103,8826,6344,7829,7591,8391,7584,7844,8220,8215,7775,7777,8262,8760,8616,8424,7812,6829,8216,7426,9099,5584,8786,8474,8152,7494,6382,8219,4920,8273,8836,8161,7227,7335,8837,8863,6331,7966,7984,6040,1289,7491,8489,2464,2463,3881,8605,8089,8087,7274,5174,8515,6217,7875,6484,8142,8487,8785,8085,8672,8049,6341,7583,8088,5218,7903,6648,8795,8131,8759,6052,8494,7768,8169,7774,4268,8238,7986,8092,6255,6257,9073,8965,9070,9072,6256,9071,6259,8840,4898,8196)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a