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