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