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