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 produit IN(0,7993,7647,9344,9424,9328,9329,9353,8483,9250,9326,9342,9266,7592,9450,9245,9423,9355,9258,9334,9425,9247,9115,9267,8915,9093,9116,9044,9043,9034,9010,9354,9011,7621,7594,9350,7597,8442,9135,9254,9042,9349,9136,9257,9091,9340,7622,8796,9327,9001,9348,8780,9013,8890,8872,8774,9330,9331,9351,9357,9117,9356,9179,8755,9246,9359,9338,8772,8848,9335,8750,8861,9255,9007,9094,8997,7299,9243,8079,9426,8773,7976,8654,9092,9352,8913,8080,8846,9332,8998,8889,7987,8887,9265,8893,7991,9249,9248,8775,7296,9033,9003,8615,9244,9138,8886,8123,8748,8912,8047,8888,9002,8480,8145,8892,9004,8829,8797,8794,9160,9134,7981,8126,8744,7606,8143,8911,9137,8446,8624,9000,8830,8880,8622,8248,8621,8747,8619,8125,8443,8693,9041,9032,9159,8501,8770,9031,8280,8144,8753,8849,8231,9114,8777,9008,8445,8663,8519,8405,7983,8909,8329,8652,8499,8074,8891,8521,8995,8771,8655,7628,8517,8506,7603,7978,8221,7599,8278,8999,8994,7637,7289,8884,7589,7612,7590,7631,8277,8695,8119,7610,8338,8279,8881,7318,8743,8336,8500,8653,8520,7630,8229,7636,8224,8075,8235,7650,7598,8527,7992,8118,8847,8313,8478,8233,8504,8526,8225,8620,7651,8271,8281,8226,8230,8122,8335,8274,8222,8072,8618,8232,8752,8694,7989,8739,7288,8498,7615,8275,8330,8228,8331,7634,7314,8623,8613,8217,7632,8522,8251,8214,7985,7586,8077,7595,7588,7619,8403,8850,8252,8444,7312,8404,8227,8871,8885,8095,8237,7635,8614,7616,7308,8213,8097,7633,8525,7649,7585,8441,8332,8479,8497,7291,8268,8481,7301,8276,8078,8223,8117,8272,7587,7620,8234,8440,7302,8337,8616,8477,8334,8282,7624,7583,8215,8401,8216,7986,8769,7979)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a