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=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,7647,7868,7462,7459,3479,6899,7873,6655,9365,9084,9366,8483,9369,6723,6259,9278,8362,5190,7492,9289,9525,6443,4149,7469,9230,6680,7919,6932,7664,9270,8385,7800,7673,7743,6944,9268,6716,9276,7918,9275,7830,4143,9404,7917,7592,4626,9107,8372,8371,7856,6255,6253,8358,4147,8383,8384,9086,8258,7763,8256,4250,8378,8380,8311,8447,8254,7916,7920,8416,8255,6256,8415,7927,8377,8355,8345,8361,7767,7741,3463,9083,8253,7771,8421,7212,6947,8260,1288,7778,8344,8379,8356,8351,8349,9082,8346,9161,8348,8967,6938,6858,1281,8347,8359,6713,7732,7456,6449,7826,4257,6454,7742,8396,8450,8353,7023,7733,7621,7594,7661,7926,7457,7597,8442,6709,6894,4146,7889,6922,9136,8312,7803,7925,7622,6258,7662,7801,7748,7747,8350,5937)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a