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,6451,9383,9335,8877,6596,9377,7918,9388,9245,3827,7556,6349,7943,9284,9230,4149,9328,9225,9269,7664,9258,8044,6252,9324,7743,9333,9226,9310,6253,9406,9329,9445,9362,9305,9287,9254,7741,9095,9357,9414,9476,6454,9384,7457,7212,9241,9332,9339,9368,8380,9143,9331,6449,6443,9267,9398,7868,9358,7469,9361,9380,9322,8360,9447,9291,9409,9266,9277,6899,7459,9228,9430,9349,8483,9413,9390,9403,9290,9526,9360,9515,9342,9514,9513,9512,9382,9524,9116,9490,9522,9520,9420,9487,6442,9519,9419,9518,9486,9485,9517,9484,9483,9479,9281,9482,9481,9478,9347,9391,9480,9477,9463,9475,9327,9450,9448,9303,9474,9442,9473,9336,9472,9244,9425,9471,9461,9424,9423,9460,9422,9421,9459,9458,9457,9412,9453,9411,9452,9410,9325,9451,9449,9389,9364,9363,9446,9444,9265,9344,9443,8872,9441,9341,9440,8876,9439,9334,9438,8958,9437,9436,9304,9435,9434,9302,9433,9301,9242,9272,9432,9288,9248,9431,9017,9429,9206,9428,9205,9204,9427,9426,9202,8870,9247,9250,9014,9417,9415,9405,9280,9402,5133,9401,9400,5094,9399,6132,8897,9397,9396,9395,9243,9394,9274,9393,9016,9299,9392,8859,9381,9379,9378,8895,6504,9376,9375,8866,8896,9374,8879,9255,6601,9257,9373,9372,5108,9371,9370,8599,9367,9279,9359,9249,9356,8849,5132,9355,9354,9353,9352,5109,8788,9351,8842,9350,6503,5092,9348,8841,9237,8854,9346,8807,1814,9345,8612,8857,9343,8809,9338,8860,9337,9330,8875,9326,1809,8819,5111,8853,9313,9312,6124,6604,9311,8832,9300,6610,5511,6459,9298,9297,7110,7947,9296,1811,9293,8766,9292,8856,8834,8865,9286,8855,9285,3191,8731,8765,9233,8821,8848,6602,9283,8719,9282,8732,9273,8725,3196,8800,8685,9271,7482,6612,8798,8746,7377,8741,8790,9246,8820,9238,9236,9235,9234,7940,6565,8824,9232,8744,9231,8822,8852,8794,8776,9227,8745,8850,9201,9200,9199,6004,9198,9197,8687,8721,9196,6505,9195,9194,8699,9193,6599,7217,9192,7522,8570,9191,8774,9190,7295,9189,8735,5920,9188,9187,8698,9186,7216,9185,8589,9184,8686,7935,9183,8747,9182,7950,9181,5656,9180,7562,8789,8633,6461,8751,8569,8782,8722,8779,8781,8597,7946,8562,7236,5987,8696,8775,8595,8828,6127,6109,8878,7523,3621,8773,8718,2461,6506,6362,8670,8693,8703,8590,6508,8586,6611,5004,8845,2991,8697,8827,7470,8868,8624,7303,8780,8738,8704,6108,8778,8688,8604,9015,5950,8634,8799,8668,8864,7309,8739,7944,8851,8690,6502,8728,7218,8867,8736,7543,7565,8720,8742,8163,5093,7473,8873,8639,8858,7484,7951,8691,8830,8568,8861,7477,8846,8708,7955,7949,8724,7472,7387,8661,8763,8705,8723,8637,7545,6474,8792,8019,7478,8818,8962,8701,7322,8020,3002,8737,8874,6603,6384,8018,8757,8847,8662,4485,8839,8638,8692,6597,8749,6564,7297,5031,7328,5994,8673,7564,4422,8143,8768,7945,8734,5745,8740,6566,8126,8727,8684,5009,8017,8016,7451,6377,6609,8707,8640,8752,7956,8635,8080,7238,8700,8829,7954,7558,4423,8656,7936,7480,8024,7960,7294,8138,8587,8748,8596,6145,8601,8593,8743,8588,3123,7137,7549,7938,7313,7987,8665,8756,6495,8627,8631,5535,8767,7989,8753,8663,7393,8733,8166,6606,7293,7942,7571,6598,8770,7486,5966,7554,8777,8750,8652,8626,7210,8796,7476,7299,7544,7995,8167,7992,6171,5624,6415,8645,8622,3657,8123,7983,8787,3610,7976,8047,3769,7374,8716,8710,8754,4491,7488,8632,7408,8711,8628,4563,7551,8706,7787,8772,8606,8771,6412,8026,7171,6492,8598,7475,5967,7991,6464,8168,3609,7474,7493,4562,8576,7413,7329,3124,7542,7941,8160,8630,8013,5991,8592,8125,8001,8613,6403,7993,8641,8730,6491,8717,8674,7302,4429,8023,6151,7533,7361,7550,8122,6013,8171,3126,6318,7349,8729,7538,7395,6143,4432,7485,8647,7239,8028,7306,7937,8603,8074,7398,8683,7355,8654,5645,6405,7241,8118,6607,5969,8146,8002,6000,3122,8585,6413,7536,8004,6155,7247,7366,5989,8124,8076,7464,8303,7394,6302,3188,8669,8094,6007,6306,3129,8726,3008,8008,8144,7167,7539,8695,7235,8078,7458,7396,7352,7351,4368,7468,8119,7965,8709,7548,6408,7399,7964,8671,7307,8621,8046,8577,7981,7985,7406,5997,6291,8128,6633,8715,5481,8831,7541,6406,7532,8075,8659,6647,7996,6613,7952,5107,5738,7331,8077,6352,8591,3680,6390,7534,8643,8702,8614,7311,7971,8079,7312,6296,7980,6383,8039,6139,7363,5537,7357,8644,6501,8584,7449,6498,7690,8607,7546,8649,8642,8623,5696,8658,4497,8029,8014,7372,8100,1569,8655,7330,8608,6340,7365,7731,7253,8651,7371,8129,7177,8653,8097,8629,7537,8095,8694,8084,6509,7364,8112,7407,8610,8072,7368,7290,8646,8055,7367,8823,8145,8071,7725,8051,8137,7487,8600,6317,8120,8625,6364,8620,6499,6422,7318,6290,8636,8619,7203,7301,8618,7251,8302,3023,8224,6361,8617,7229,8010,8083,8783,8136,7939,8615,6365,8582,7957,7282,7308,7978,8871,7997,8611,8808,7173,8042,7362,8162,8609,7166,7204,7378,8575,7788,8037,7520,8005,8025,8602,7962,6312,6804,8170,7258,7172,8117,7291,6417,8175,4456,7405,3029,6407,8031,8034,7961,8135,2363,8027,6102,8797,8426,7552,7319,8087,8712,8033,7792,7274,7540,6642,8089,6484,7261,8605,6382,8161,7494,6082,8152,7510,6314,8836,7227,7984,7335,8259,8837,6301,8863,6331,8159,7966,6441,8142,6866,6800,8759,7963,6052,6332,8169,8150,8106,8238,6311,8151,7986,6592,8092,8713,8105,8035,8785,8085,8672,6458,8049,7263,8475,6341,7260,6313,8088,6648,8769,8795,6797,8131,8786,8758,7168,8116,8053,4426,8714,8580,7726,6096,8862,7373,8784,7972,8825,8833,7998,7844,8760,6101,8616,8571,8835,7336,7727,8011,8838,6344,7979,7262,7809,7259,8103,8826)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a