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