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 produit IN(0,5950,7893,7299,9257,9395,9449,7991,6963,2104,9340,9028,8945,9144,9054,9004,9176,9145,2609,6879,8319,7888,9105,4640,7892,6961,6968,8913,8453,1823,5760,3855,2610,8995,9008,7887,9032,6962,7867,7816,7894,7923,9127,9003,9228,9149,9027,9154,9241,8880,6169,9126,5329,9274,9330,7391,9293,6706,9265,8456,8338,9475,6883,7589,9002,6960,9332,9245,7576,9313,9255,9486,8893,9254,9481,7384,8250,9461,8878,8341,9460,9440,7818,9359,6864,8891,8225,6472,9292,8850,8504,9031,6967,9271,8884,3621,9246,8499,8438,6109,7586,8230,8861,6108,8827,7585,8846,8527,7649,8239,8510,8441,6200,7599,8235,8480,8268,8232,7633,8478,5175,7587,7815,6888,8526,8332,8752,8828,3254,6871,7493,8214,7987,8271,8829,8080,8123,7993,7989,8742,7992,8830,8771,8614,8276,8792,8213,8707,8505,8796,7293,8237,8778,8145,8122,8770,8613,8479,8119,8336,6691,8673,8234,3128,8337,8641,7291,7396,7312,8425,6972,8236,7491,7986,7494,4268,6217,8049,7227,7984,8795,6866,6284,5174,5824,7596,7335,8424,8220,8215,8496,8391,8216,6688,8487,8219,7584,7829)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%62%' AND ( promo!='0' OR prixo!='0') ORDER BY (id-(20*num)) DESCErr153a