SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,6879,2104,9090,9151,4632,9148,9153,9147,9089,9100,9418,9149,9054,9106,9119,9104,9038,9150,9078,7387,8316,9124,9152,2610,9069,9098,9416,9007,9123,9166,8997,9229,9125,9146,6964,4640,9028,6961,8990,9132,8243,9241,8913,3855,6963,6968,9128,1294,6880,8889,7471,8968,7489,7892,9126,8887,8893,9165,6962,8972,9012,5760,8939,9033,8339,8993,9003,8453,6959,8241,9408,9138,8886,8978,8992,8949,9027,8314,6208,9176,8323,9026,8912,1823,8888,9002,8480,8892,9048,9127,9004,9122,8982,8452,9061,9129,6960,8315,9057,8340,8242,9160,9052,8981,7893,9051,7381,7770,9023,8456,7606,8911,5149,9137,6169,9024,9060,9039,8343,4849,8989,8975,8341,5431,9025,8261,8974,9000,8529,9047,8942,7411,7888,8880,8240,9018,6966,8248,7867,8986,8991,8250,7422,2609,8987,6487,9022,7391,9041,9032,6232,8969,9159,9031,8429,7384,2101,8462,8495,8947,8984,9081,8484,9009,8231,9114,9008,8940,3004,8937,8465,8909,5329,9157,7865,8469,5831,8970,6694,8499,8318,8891,7386,3846,8995,8427,9167,8945,7420,8467,5422,6737,9101,8983,8955,8322,8428,8528,8943,3027,7866,8508,589,9080,6706,9050,9141,7599,8460,8936,8352,8454,3432,8999,8994,4264,9097,8432,6853,5375,4667,4622,5336,8246,8884,9049,9154,6854,8464,9056,7432,6881,7589,8950,9053,7887,7923,8466,7590,9133,8985,7857,8338,8664,8468,5817,8463,8414,8336,8500,8520,8229,8235,7650,7598,9055,8527,6240,9059,7814,6732,8478,7813,8233,8461,8504,8526,8225,7576,8271,8976,8430,8226,8230,8335,8274,6261,8232,8510,8739,9079,6490,8498,7428,8275,8228,9019,5191,8217,7632,8437,8214,7586,8239,7588,8973,7619,8386,8227,8470,8938,8885,8237,8433,7894,8473,8213,6967,7633,8247,9102,7811,8525,5182,6200,8420,7649,4000,2602,7658,3028,7585,8441,9058,7573,8332,8479,8418,8497,8493,8298,8268,8417,6263,5816,7644,8481,8840,7011,8276,5175,7816,6687,8488,8223,8438,7815,8272,7587,3254,7620,6982,8423,8234,7828,6691,7581,8898,7379,7390,8440,7389,7400,7385,7490,7410,6733,8337,7021,6885,7577,8941,9099,5924,7491,8357,8487,7026,8515,5384,6688,8477,8334,7414,7643,7025,2003,3952,5824,7776,8282,6829,8424,4612,8422,7426,7624,5178,4745,7642,8425,7583,7829,7875,8516,6749,8381,6692,3362,8215,9156,9103,5759,8009,8391,7672,8401,7774,7903,8485,8216,6786,3561,7388,4920)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a