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,9238,8845,8763,7448,6880,8160,6959,7387,8949,9124,9324,9371,9380,9367,9288,2461,2991,9226,9368,9354,6384,9311,9242,9247,8787,9485,9492,9433,9487,9431,9439,9459,9473,9444,9443,9402,9441,9393,7329,8727,7952,8163,8772,7331,8757,8079,8768,9399,9392,9379,8818,9377,9376,9375,9373,9372,9370,9337,8851,9357,9356,9353,9352,8750,8749,7976,9349,8683,9347,9338,9331,3170,9326,9325,9296,9273,4368,9272,9258,9250,8608,9243,9153,8658,9197,9089,9195,9194,8734,9191,9147,9190,9188,8733,9184,6306,9104,9182,9180,9310,8000,9378,8171,9125,9122,8610,9141,9051,9098,8603,8600,9078,8873,8755,9132,7960,9248,9137,8084,8748,9033,8738,8654,8984,9052,8862,8990,9114,9048,8968,9041,8241,9061,8644,8426,8975,9166,6498,8982,8888,8887,8972,9023,8754,8602,8909,8340,3004,6964,9056,1294,8619,8889,8970,3163,9047,7978,8886,6694,2462,8339,9050,8700,8950,8999,8997,9081,8942,9080,8991,5831,8937,9049,8858,8983,7381,3846,8974,9053,8740,9055,8323,9159,9157,6853,9079,8529,8702,8969,8743,8784,8170,589,8695,8839,8985,8076,8976,8495,7411,3432,9059,8427,6966,8753,8231,8248,8852,9022,7866,8655,7386,7428,3027,8973,8723,8429,8428,8274,6487,8484,8432,8023,6881,8724,9156,8430,1818,6513,8508,7590,4456,9058,7813,5816,6490,8520,8433,7985,5182,8498,8481,8739,2602,4000,7658,8418,7619,8898,8473,8497,8625,7270,6733,7265,8088,7572,7417,9142,9099,9020,2003,8515,3844,7426,8941,7643,7168,7403,8169,8509,8759,8833,6160,6954,6238,1289,8786,5924,8758,4774,7871,8838,8760,8152,7875,2606,8238,7274,7259,8863,8092,7583,7271,8785,8494,8835,8844,6344,6484,7966,7768,8131,8103,8836,8273,8837,3649,7425,8087,8489,4426,7138,7953,8089)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a