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=2 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,9344,8576,8788,9378,8589,8834,5133,6601,8735,6495,8080,6597,9225,3191,6503,9413,9388,7556,9403,9402,6377,9399,9420,9474,8866,9395,8809,9392,8757,9448,9471,9305,9393,8870,9415,9391,8736,1809,9458,5094,8734,8872,9337,9412,8865,9423,8763,9358,5108,9400,1811,7554,6474,9405,8781,9325,8842,6804,9409,9346,8875,9397,7943,3621,8790,9293,3196,9379,8877,9313,8895,8768,8789,8741,5132,9331,8744,8754,6132,9435,9301,9359,5987,2991,9327,9437,9363,9414,9364,9269,9424,8738,9421,9274,9422,9440,8869,9428,9450,9266,9342,8727,9329,9272,6602,8755,8774,9357,7947,9242,8841,8827,9384,9355,9303,8846,5511,9436,8782,9475,7217,9380,6375,9348,9095,9326,6505,8670,6362,9438,9377,8853,9297,9368,9524,7450,9523,3168,9522,9396,6506,9372,9520,9394,9519,9290,9518,9340,8599,8796,9517,6108,9425,9324,6106,9477,9347,9479,9245,8020,9254,8873,9298,4491,9417,8740,8775,6384,8848,9446,9481,7484,9247,9271,9335,9373,6124,9459,8807,9376,8879,9257,9284,8868,9334,9268,9447,9350,9277,9367,9014,8673,9287,6603,9227,7451,9349,5109,7328,8732,9250,9339,9432,3123,9439,8721,9441,8019,9375,8699,9353,9336,9288,7523,8818,9389,8845,5004,8844,7954,9281,8691,9427,7531,9370,6612,9381,8167,8730,5111,9332,9017,5656,9292,8750,9411,9226,8820,9278,9328,8163,3008,8780,9352,6004,9265,6610,7952,9309,9255,6142,5040,8708,9434,9279,9304,9374,8855,7137,7480,9016,8867,6349,9206,9311,9205,7323,9478,7448,7216,8160,8787,6502,8864,9202,9401,7488,7558,3007,7449,6476,9445,9267,8733,9442,9246,6376,9354,8765,9526,9515,8562,7329,8634,7411,5985,8854,8168,5009,9513,5967,9512,7562,9228,4423,7239,4368,8668,9289,8794,6565,7951,8773,9490,6598,9487,7377,6604,9486,9484,6412,9485,8569,9483,9482,3609,8829,8685,9480,4422,8772,8719,7993,8126,7493,9473,9472,7238,9461,5542,3769,8756,9460,3126,4429,6564,9249,9360,8170,6007,3170,9234,9143,9449,9444,8665,9443,3122,9282,9116,8592,8593,6406,8612,9248,8018,9243,8697,8079,9312,4563,9431,8851,5031,8874,7297,7322,5966,6408,7944,3171,7298,9426,8016,9191,7295,9280,6013,8671,6415,9429,8725,5535,5093,8770,6473,7299,5541,2422,8688,9188,6146,9275,7935,5624,8857,8603,8766,7330,3124,8000,9398,6302,8698,7150,9182,8635,8608,6171,7374,9457,8627,7976,9299,4497,6001,8706,9187,8718,9181,9361,3610,9286,7236,9351,7946,8709,7300,7331,8568,7541,8958,9283,5092,8695,6403,7542,8696,9338,8047,6306,9406,9333,7474,7991,8621,6035,9330,8611,3140,6290,8722,8607,8703,7960,8588,8647,6127,8600,7171,6405,8633,9296,7486,7987,6475,8123,8632,7267,8861,7956,8717,8615,6497,8753,8171,9015,6609,7296,8731,9276,8748,8684,4485,9273,8624,9345,6020,9343,9270,7303,8858,8144,7139,9341,9258,9244,8663,9310,8652,8767,9300,7294,6390,8859,6000,8622,8747,8726,9238,9237,5030,9285,3129,7971,8027,8609,6018,8601,8125,9200,8645,8771,6607,5920,3188,8737,8856,8585,8591,7950,9453,8143,8046,8137,7133,9452,6143,7536,9362,9451,8822,6413,8145,8649,3657,9190,8704,8702,8849,9189,8630,8084,9186,8570,8683,8598,9185,8640,9184,8631,8026,8001,9183,8596,6291,5991,8669,8687,8674,9180,8720,8619,8606,6296,9236,6151,8777,7309,9235,5989,6492,9233,9232,9231,8693,8138,8604,6155,8643,6140,7268,8017,8830,4562,8656,8590,8581,5969,8878,7995,6508,8620,8626,8646,8578,7538,8728,8303,8819,7550,8642,7981,8654,8602,8686,8426,7460,8119,7368,6496,8700,8122,7731,7229,8644,8128,7349,8573,8639,9291,8583,7533,8655,8044,8628,8610,7250,9241,7964,8743,7936,7387,8013,8850,8074,7937,7978,7965,8962,7544,7464,6318,7355,7142,7235,8707,7787,8711,8124,6498,8579,7366,8039,8701,7241,8729,7234,7515,8008,8572,7992,8002,3163,6553,3094,8618,8118,7352,8574,7224,8028,7247,8852,7468,7204,7983,6422,7398,8175,7941,8577,5645,8034,7463,8076,8176,7725,7555,7458,8847,7351,7363,8575,7289,8037,5997,8839,8224,8029,7314,7485,8038,7539,7282,1569,2462,6396,8040,8097,7172,6139,8823,7792,7989,7753,7243,7364,8724,7152,8042,8051,8641,7957,8146,8136,2363,8752,3179,8023,8072,8723,8129,7361,7203,7996,8694,7222,6364,8302,7959,8004,7220,6499,8613,8162,7985,8100,6562,6493,5649,7249,3029,8071,7325,4432,7362,8808,7173,8014,3680,7318,7487,8614,7540,6317,7312,7353,7372,7308,8229,8095,1818,6340,8739,6002,6513,8120,7291,6365,7167,7534,7939,7258,7311,7365,7788,8045,5738,8078,7253,7135,5696,8117,5107,7276,6633,7519,6613,6383,8075,6312,7690,7367,7532,8083,8629,7301,7248,7251,8005,6361,6407,8010,8625,3023,7371,8783,7302,8797,6461,7270,7520,8135,8871,7997,6501,7233,7357,7265,6352,8786,6509,8055,7319,7724,7166,7378,7639,7177,7245,7288,8571,7537,7727,6417,8025,8077,7546,8152,8623,8653,8616,7199,6314,7979,6484,6866,8159,8169,7168,6800,7726,8769,8837,7972,7373,6022,8825,6096,8784,8862,8033,8580,8009,8238,7504,7986,6595,6101)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a