SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,9335,9396,7450,9461,9370,6106,5624,8240,4632,6964,9376,9225,7328,9151,9310,9297,9379,9242,9269,9331,9417,9148,9258,9397,8834,9501,9526,9500,9499,9495,9496,9487,9485,9483,9482,8736,9480,9427,9439,9433,9434,9438,9436,9437,9460,9338,6966,9312,8674,9371,9372,9100,9147,9393,8734,8768,9380,9104,9399,9324,9153,9353,9325,9401,8727,9394,7451,9402,9367,7449,8754,9368,9192,3769,9227,6384,9250,8316,8845,9266,7480,9378,8163,8755,9181,6302,2422,5040,4368,6408,9069,9166,8079,9150,7330,9248,8865,8750,9078,9472,9471,9459,9458,9435,6405,9432,9431,9428,9426,7137,9007,9415,9414,9400,9381,8170,8864,9152,9377,7971,9373,9375,9357,9355,9354,7150,9132,9352,9351,9350,9349,9348,7489,9326,8654,6406,9418,8671,9138,9296,9416,8600,8027,9288,9024,9039,9048,9247,9124,9243,8171,9237,9199,9198,9197,9196,9195,9194,8975,9193,9190,9189,9188,9187,9186,9185,9129,6306,8858,9184,8861,9183,9182,8246,8748,9180,8969,8452,6208,9000,8780,9004,8763,8683,8772,8339,8726,6232,9165,9176,8323,8315,9026,8873,7229,8647,6854,7865,7770,8601,9023,8695,7381,8749,8343,9244,9160,8495,8936,8658,8874,9125,8314,9122,8649,8655,8997,8887,8138,5431,6737,2101,9291,8619,4849,9018,8042,9038,8753,9033,5149,8617,9080,7422,8886,8862,8622,6487,8318,8970,9059,8028,8888,9050,5422,7590,5375,8615,7420,9159,8465,9061,7857,8982,8621,6422,9052,9097,9157,5336,7650,8429,8972,8847,8322,8618,8603,9025,8947,8427,8464,8602,4264,9022,8940,8939,9101,8702,9019,8991,5817,8414,8943,8777,6240,8743,8609,9047,8950,8118,8942,3680,7978,8500,8611,8591,9141,8352,8076,6498,8995,8994,8983,9081,7985,9053,8137,8508,8974,8909,4667,8839,8646,8247,7814,8528,8231,7258,7606,4456,9102,8626,9156,6732,8261,5191,9167,7432,6263,7588,6513,8228,8955,8430,8976,9079,7222,8226,8274,8136,7619,7811,4000,7135,8045,6490,8724,8938,8420,8227,7173,7598,9058,8525,7996,5481,8386,8739,6687,8023,8473,8272,8298,8498,8723,6312,8275,8135,7620,8898,7390,7573,8005,7972,8497,8423,7379,8223,6102,8117,6383,7997,7828,7410,7581,7400,7490,7389,7270,6733,8440,8488,7202,3952,7452,6749,6331,7777,8273,8863,7273,8089,5218,8826,7641,7021,7129,8844,8142,7642,6344,7271,8785,8672,6923,8835,8009,5384,7138,7231,8516,8085,6341,8837,7274,7336,7414,8605,7607,8836,8262,7775,6052,8169,7199,7998,8267,8494,7426,5759,8838,6273,7624,8758,8509,7776,4745,8477,7812,8401,8941,9142,9020,6382,8282,8381,9103,8784,7380,7591,8474,8422,8116,7388,8224,7774,8786,8011,6199,1289,8833,5178,7844,7403,4612,7672,8759,6829,7026,8760,7281,8218)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a