SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo,CASE WHEN isable!=0 THEN photo WHEN wi1!=2 AND photo1_2!="" THEN photo1_2 WHEN wi1!=4 AND photo1_4!="" THEN photo1_4 ELSE photo END photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,5985,9424,6598,9448,8933,3007,9277,9267,4654,4653,8708,9504,7217,9503,9328,5009,5967,8900,5134,9523,7238,9341,6146,5135,5966,8774,6001,9412,9403,7298,8915,7711,8854,9115,7048,8696,7300,7981,7059,9304,9011,6739,6007,5307,6882,8857,7536,8585,8944,6157,6607,8859,8439,9091,7567,8856,8598,7533,8013,6685,9316,2598,6140,9315,7241,3094,6361,7485,6684,6949,7532,6873,7487,7166,8162,7177,7243,6002,7758,8881,1569,7056,7049,3179,8403,8281,7001,7690,6417,4799,3446,6876,7537,7683,3998,8653,6863,6690,4587,6878)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND ( promo!='0' OR prixo!='0') ORDER BY (id-(20*num)) DESCErr153a