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