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,2104,9144,6879,7892,8966,9418,9416,9408,9119,9105,9054,9024,9145,8889,9032,8994,6968,9090,9150,9028,9229,9147,9149,8945,9106,9012,9146,9132,9114,9153,8913,9152,9148,9165,8997,9241,9031,9089,9151,8912,9125,9123,9122,9104,9055,9176,9069,9160,9002,8880,8993,4640,8243,9138,9137,9126,9124,8893,9004,4632,8992,9009,8991,9081,9080,8986,9098,9056,9051,8969,9047,9041,9039,8453,9159,9157,9057,8887,9025,9141,8241,9008,9007,7888,9003,7387,8462,3855,9000,9128,8999,9127,8995,8469,8909,9110,8984,8983,8461,8982,8981,6961,7893,7489,8891,8314,8972,8970,8989,7867,9061,9060,9059,8888,8323,8949,8499,8947,9053,9052,8940,6960,8939,9049,8936,9033,9100,8911,9027,8892,8465,8340,9019,6880,8886,8884,6232,6959,8315,6208,8233,8987,7606,8339,9129,8978,8885,9022,8950,7887,8559,6964,8974,8937,9166,8466,8240,9156,8480,6854,8250,8275,6169,7420,8452,8454,7384,6261,8467,9101,6963,9097,8322,8427,6966,8973,8510,7391,5329,8468,8664,8955,8739,9133,2609,3846,8230,9102,8460,8433,8316,1294,7632,9058,6962,4849,7814,7649,8226,1823,7588,8566,8463,8318,8235,8508,6240,7381,8526,8527,8437,8529,8470,8564,8976,8248,8246,8567,5336,3432,8420,5760,5422,7816,8414,2101,8943,8343,8341,5149,8213,7599,5817,8231,9167,589,8242,7923,3128,8429,7386,8525,9154,7586,8505,7650,8261,8276,2610,7866,8271,6737,7865,7857,8237,8432,8232,9079,8247,4264,8520,7811,8500,7590,8274,8335,5431,8484,8336,7589,6200,8473,8239,8985,8272,8332,8481,7633,8430,8228,6887,8456,8938,8898,5191,7585,8352,8338,8478,8223,7894,8528,7644,7815,6263,8418,8217,7011,6706,7400,7899,8214,7813,7619,8441,8406,7576,5816,6982,6692,8225,7379,8417,7598,3027,8438,7587,7596,8423,3254,6691,7620,8298,7828,5175,8425,7410,8234,8498,8440,8504,8479,3952,7452,6881,8497,6967,8381,8227,8386,6733,7490,8268,8337,6732,7658,9103,8488,8334,8267,8496,7672,6238,4922,3844,7022,6972,6886,8516,7624,8236,6885,8218,8477,9142,6199,8485,7776,8401,9020,7425,7822,7641,6688,5824,8422,7871,7607,7829,7591,8391,7584,7844,8220,8215,7775,7777,8262,8424,7812,6829,8216,7426,9099,5584,8474,8219,4920,8273,6040,1289,7491,8489,2464,2463,3881,5174,8515,6217,7875,8487,7583,5218,7903,8494,7768,7774,4268)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a