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,6763,6109,8843,9307,6610,6106,9314,6520,9456,9308,9494,9455,9511,9509,9454,9506,9491,9505,9504,9502,9527,9528,9501,9523,9503,9500,9510,9492,6611,9507,9497,5322,9316,9498,9315,5744,9499,5745,6598,9496,5966,9495,1811,3827,2104,6612,1318,7944,6108,5109,9017,7450,1809,7448,9014,6132,4632,5111,7942,6232,6459,7374,5336,6597,4650,4640,1814,8606,6609,6749,5985,5132,7202,5133,5108,3952,8568,7452,7110,6124,4922,2107,2464,6133,8132)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a