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,9250,9371,7952,6109,9273,8845,9225,9324,9310,9241,9357,9266,9331,9226,9471,9380,9397,9272,9395,9349,9393,9244,9402,9358,9228,9325,9248,9291,9288,9347,9526,9449,9242,9243,9269,9379,9490,9487,9486,9437,9485,9399,9433,9483,9417,9482,9432,9481,9431,9480,9376,9475,9247,9474,9473,9472,9368,9373,9461,9245,9279,9460,9356,9459,9458,9378,9446,9377,9444,9265,9443,9258,9414,9441,9337,9440,9439,9401,9438,9436,9435,9298,9434,9394,9396,9429,9428,9392,9427,9426,9415,9372,9280,9405,9338,9355,9354,9400,9274,9350,9351,9381,9332,9255,9254,9257,9375,9181,9296,9313,9370,9249,9367,9312,9359,9353,9352,9237,9348,9346,9340,9271,9335,9330,9326,9311,9184,9297,9293,9292,8834,9238,9193,9188,9246,8878,9227,9199,9198,9197,2991,9196,9195,8865,9194,9192,9191,8852,9190,8757,9189,2461,9187,8851,9186,9185,9183,9182,9180,8735,8741,8819,8864,8873,8827,8670,8734,8736,8768,8728,8700,8763,6108,8818,3621,8858,8727,8740,8738,7387,6384,8847,8861,8733,8168,8163,7328,8756,8874,8850,8160,8839,5950,8739,8846,8749,7960,8829,8748,8767,8601,8796,7451,8647,7322,8743,8723,8753,7480,8777,8772,8754,8724,8750,8787,4429,6405,4368,8683,8654,8752,8830,6302,8737,8138,8730,3769,8671,8780,7329,8669,7331,7449,6406,8729,6408,8771,5624,7971,8171,8079,8778,7976,7137,8080,8608,8076,8673,7493,6306,8742,8707,8674,8709,8695,8621,3680,8726,7330,8717,4497,7229,7299,8607,8614,8603,7991,8655,8123,6498,8600,8170,8610,6290,8659,8702,7993,8084,8118,7987,8625,5481,8626,8137,7992,8649,7989,8592,8658,8644,8028,8622,8122,7997,8618,8617,8602,7167,8611,8027,8426,8651,7996,7301,8615,8613,7293,8646,8145,7172,8119,7978,8117,8609,8224,8619,8023,6422,4456,8136,7173,8042,7985,8591,8135,6383,7258,8005,6312,7312,6102,7291,3029,8862,8758,8786,8835,6382,8759,8784,8760,8152,8616,8169,8011,7998,8837,4426,8116,7844,8672,8836,7986,7494,6648,8826,8053,7168,8863,8087,8131,7274,6344,6052,7972,8049,8795,8785,8085,7966,6484,7336,7984,6341,8833,8088,8089,7259,8838,7335,8238,8605,6331,8142,7227,8161,8825,8092,8103)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%' AND ( promo!='0' OR prixo!='0') ORDER BY ( (CASE WHEN site IN (1,3,4) THEN 10 ELSE 0 END) +1000-num+promo + (CASE WHEN prixo=0 THEN 0 ELSE ((prixo-prix)/prixo*50 ) END ) ) DESC,produit DESC,numErr153a