SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,2104,1840,7897,7916,4650,7918,7919,7382,4654,6879,7006,7917,1839,7892,4632,9174,5366,7898,1844,9151,9147,9502,9501,9508,9500,9506,9497,9496,9150,2356,7922,7833,7835,7832,6964,7521,4640,4653,5322,6963,4652,9148,6850,3777,8518,8434,8448,1823,5316,7184,5408,6208,6232,7841,2107,7387,5321,7893,7888,8523,7005,7928,5315,3789,6877,7226,7384,5433,2101,7422,1812,5422,5329,5326,8435,5354,7420,7895,7887,7411,5336,5343,7471,8436,7432,7930,7921,6846,7929,6284,7896,6844,7424,7437,5435,5409,7923,5434,6847,5440,5436,6843,7442,3788,7436,7495,7444,7430,6848,7438,7894,5332,6841,6842,5325,7441,6845,6878,7427,7385,7388,7419,7414,7392,7445,6866,5330)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a