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,9151,6879,4632,6968,9054,6964,2104,9104,9089,9148,9090,9100,9147,9150,9152,9153,9149,9012,9119,8316,8993,9146,9098,9069,8997,9007,1294,7387,9124,9160,2610,8889,9123,9229,8243,9241,9138,9106,9408,8887,8972,4640,9114,7489,9033,8991,9418,9416,9137,8462,9126,9125,8986,9028,3855,8241,9132,9176,8912,9002,9051,9129,6961,6880,6963,8246,8886,8940,9039,9061,6959,8340,9165,8992,9004,1823,8460,8939,8469,8892,9031,9024,9041,9128,8949,8982,8981,9141,8893,8453,9166,9000,8468,8947,6208,8465,9052,9025,8484,8339,7606,8966,8467,8452,8315,7892,6962,6854,9060,8314,9122,7381,8984,8323,5760,8969,8242,8978,5149,9127,8343,8989,6966,8888,9056,8318,9081,6232,5431,9009,8999,9133,8261,9097,8480,8911,8240,8250,7867,8936,7865,8248,8937,8913,8987,8466,6960,9057,9157,8970,9008,8529,8909,7893,9003,9080,9159,9144,7888,8505,8463,9047,2101,7650,6169,8943,589,7384,8974,8950,9022,8461,8995,8427,9032,7391,6737,9059,9145,4849,8983,6261,8226,5329,9049,7590,5422,9154,9055,7866,8322,2609,9101,3846,9110,8432,3432,8454,8880,4264,7386,7420,8341,8664,8231,8559,9027,8429,9167,7599,7589,5336,6240,8499,8500,7857,8994,8233,8414,3027,8352,8336,9105,8456,8508,9079,9053,8566,6706,7598,8945,8976,6881,8528,9019,5817,8338,8564,8504,8430,7814,8884,7813,8985,8478,8955,7923,8520,8274,8232,7887,8228,8527,8891,7894,7588,8247,8526,8230,8433,8225,9102,8510,8235,6732,8525,5816,7585,8567,8239,8885,9156,8406,7811,3128,8335,8973,6263,8938,8481,7619,8739,8227,8418,8437,5191,8217,6200,7649,8470,8420,7632,8275,8386,8417,6967,9058,8237,8271,8473,8214,8213,7011,8276,7576,7816,7633,7586,8272,8441,7658,8498,6982,8223,6887,8438,7644,8497,8298,7620,8479,5175,8337,8898,7379,7587,8423,3254,8332,7815,8268,7828,6692,8440,6691,7410,8234,7899,7400,7490,6733,8488,3952,7596,7452,7491,2464,2463,8422,6885,7583,8273,6238,6040,4922,5218,7022,8494,6199,5584,8262,7812,7768,8485,8516,8267,3881,7875,8515,8496,7844,9020,7584,8424,8215,8401,6217,9103,8425,8381,9099,8219,9142,6972,7774,6829,6886,7426,7776,7591,3844,5824,4268,8216,5174,8334,7641,7607,7829,7775,8487,7672,6688,8391,7822,8489,7777,7871,7425,8220,7624,1289,8474,8477,8236,7903,4920,8218)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a