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,7382,8342,9377,9245,7556,8319,6349,2104,9144,8031,7961,6804,9284,6879,9254,7545,8735,8576,7897,7892,9265,9356,9368,8960,8175,9526,8224,9515,9514,9513,9512,7543,7898,9490,9487,9486,9485,9483,9482,9481,9475,9480,9474,9473,9472,9446,9471,9461,9460,9459,9458,9457,9453,9452,9451,9255,9449,9445,9444,9443,9441,9440,9439,9438,9437,9436,9435,9434,9433,9432,9431,9429,9428,9427,9426,9418,9417,9416,9415,9414,9413,6859,9408,9258,7542,9374,8622,9092,9354,7558,9119,9105,9054,9345,8780,9269,8778,9024,8711,9145,9281,3002,9244,9333,6109,9226,8889,8742,2461,9032,9234,8834,8736,9406,7322,8741,8994,6968,9405,9402,9401,9400,9399,9397,9396,9395,9394,9282,9393,9090,9392,9150,9134,8656,9028,9381,9380,6108,9229,9379,9376,9343,9375,9175,9147,9015,9149,9287,9373,9233,9372,9371,9370,8945,9367,9359,9357,9355,9353,9106,9352,9351,8867,9286,9235,9299,9350,9349,9348,9012,9201,9347,9200,8737,9346,9199,9198,7554,9197,9236,9231,9232,9338,9196,9283,8959,9337,6492,9195,9194,9193,9332,9192,9331,8830,9146,9191,9330,9326,9190,9062,9325,9189,9324,9188,9313,9187,9312,9186,9311,9185,9132,9184,9183,9298,9182,9297,3621,9181,9296,9180,9293,9292,8673,9288,6384,9114,9280,9153,9279,8913,9152,9274,9273,9272,9271,9148,9266,9257,5535,9250,9249,9300,9165,9248,9247,8997,9246,8670,9243,9242,9241,9238,9237,7137,5950,9031,7451,9227,9225,8799,2991,9089,8738,8962,9310,9151,9291,8846,8163,8912,7922,8819,8757,8447,9125,9123,8626,9122,8321,8584,8868,9285,8756,5537,7366,8861,8706,8827,9104,3769,8829,8845,9055,9228,8138,8449,9176,9069,9160,8772,9378,9002,8880,8577,5624,8796,8303,8603,8993,8784,8763,4640,8243,9138,9137,8873,8643,9126,7921,8171,9124,8080,8893,7329,9004,4632,8850,8992,7952,9009,7987,8750,9290,8787,7541,8727,8749,7976,8991,9081,9080,7993,8986,8733,8642,9098,8592,9056,8874,8768,9051,8969,9047,9041,9039,8453,9159,9157,7495,9057,8039,8887,9025,8858,9141,8241,9008,9007,7888,8123,9003,7387,8029,7363,8462,6291,8658,3855,9000,6257,9128,8999,9127,8995,8734,8469,6255,8771,6296,8909,9110,9001,8984,8983,8777,8461,8982,8981,6961,7893,7489,8891,8314,8591,8972,8970,8989,7896,8966,8770,7867,9061,9060,8707,9059,8888,8323,7895,8949,8499,8767,8947,9053,7726,9052,8940,6960,8939,8671,8865,9049,8580,8936,9033,9100,8911,9027,8892,8465,8660,8340,9019,6880,6284,8026,8728,8886,8884,6232,8683,8828,6959,8119,8315,7731,8608,8619,6208,8233,8729,8621,8028,8987,7606,8575,8851,8339,9131,9129,7368,8617,8726,8978,8730,8717,7992,7989,7729,8885,8852,7725,9022,8950,8146,7887,8615,8709,9077,8559,8037,6964,8974,8079,8740,8937,7293,9166,8466,8240,9156,8034,8118,8480,6854,8702,7226,8753,8600,8250,8522,8275,8743,6302,8655,7480,8818,8878,4368,6169,7331,7420,8452,8397,7204,7544,4429,8160,8651,8611,8454,7384,8601,6261,8641,8467,7299,8748,9101,8646,8620,8862,8864,6963,7985,9097,8322,6888,8427,8644,8607,7330,7991,8754,8610,6966,8647,6491,8973,8510,7391,7996,8609,5329,8468,4497,7424,8618,6390,8847,8664,8955,8739,7361,9133,2609,3846,8674,8122,8004,7960,8230,6306,8792,6318,6955,9102,8723,8460,6883,8695,8433,8084,8145,8316,5326,7493,8724,1294,7818,7632,7383,9058,6962,7592,4849,7814,7649,8226,1823,7588,8566,8463,8318,8235,8508,6240,6472,7381,8526,8527,8437,8825,8529,8669,8470,8027,8564,4432,8649,7229,8976,8248,8246,8567,7172,5336,3432,8420,7971,6290,5760,5422,7816,8414,2101,8943,8486,6406,8343,8341,5149,8213,7599,8136,6405,5817,8231,8076,8613,9167,589,8242,7923,3128,8429,7386,8525,9154,7372,7586,6868,8505,7650,8261,8276,2610,5481,6408,7866,8271,8455,6737,6422,8042,7365,7282,3861,7865,6096,7857,8614,8237,3680,8602,8137,8432,8232,9079,8247,4264,8520,7811,8500,7590,8274,8335,5431,8484,6204,8302,6498,8336,7978,7589,7444,7312,6200,3029,8473,7427,7367,8168,8239,6383,7362,8985,7328,7396,4205,7173,8272,8332,8654,8481,7633,8430,8228,6887,3918,8456,6864,8938,8898,8170,7364,5191,7585,8352,8338,8478,8223,7894,8264,7291,8528,5332,7644,7815,8426,6263,6727,7302,6650,8078,8418,6958,8217,6312,7011,6706,7400,7899,8214,7813,7619,8441,8406,7371,7576,5816,6982,8659,7429,6692,7782,8225,7379,8005,8417,7598,8117,3027,6317,8438,7587,5325,7596,7781,8423,4456,3254,7783,8222,6691,7620,8298,7828,5175,8425,7410,8234,6407,8498,8440,8504,8479,8135,3952,7373,7452,6881,7301,8083,6102,8497,6668,6967,8381,8227,8386,6733,7490,8268,8337,6732,6871,7658,9358,8023,8839,9103,8700,8752,8625,7449,7167,7997,7972,7258,7870,8488,8431,8833,8334,8267,7998,8582,6671,7423,8116,8714,8496,8710,6818,8758,7672,7168,7434,6238,6941,4922,3844,7022,6972,8053,6886,8516,4426,7624,8236,6885,8218,8477,9142,6942,8112,6199,8835,7727,8485,7776,8401,9020,8011,7425,7822,8838,7641,7336,6688,5824,8422,7871,7607,7979,7262,7809,7259,8103,8826,6344,7829,7591,8391,7584,7844,8220,8215,7775,7777,8262,8760,6101,9088,8616,8424,7812,8204,6667,6829,7659,8571,8216,7426,9099,5584,8786,8474,6926,7510,8152,7494,6382,8219,6082,4920,8273,6314,8836,8161,7227,7335,8259,8837,8196,6301,8863,6331,8159,7966,6441,7984,8715,6040,1289,7491,8716,8489,2464,2463,3881,8712,8605,6642,8033,8089,8087,7261,7274,5174,8515,6217,7875,6484,8142,8487,7660,8035,8785,8085,8672,6458,8049,7263,8475,6341,8105,7962,7260,7583,8088,5218,7903,6648,7817,8769,8795,6797,8131,6313,8713,7730,5330,8759,7963,6052,6332,8494,7768,8169,7774,6866,6800,8150,5827,8106,7392,4268,8238,6311,8151,7986,6592,8092,6983)  AND beret=0 AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a