SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,7947,6504,3191,6503,9389,9423,9384,6602,7562,1814,7946,7943,5094,6601,8853,8588,8744,5108,7377,9524,9519,9518,9484,7216,9478,3196,7306,9327,8599,5133,8876,8855,8789,8612,5132,8782,6603,6506,6604,8125,8721,6505,9398,6142,9390,9016,8820,6502,8725,8879,5511,4423,7936,5092,6565,6564,6461,8765,4422,7303,7951,7935,8589,8766,8719,7295,8866,7941,8590,7309,8604,8569,6403,7236,8047,8126,7549,7950,8570,8783,5093,8718,8046,7550,8693,6508,8094,8640,7937,8596,6566,3023,3008,7551,7210,7355,7247,7352,5645,7548,7290,7308,7319,8095,8823,8694,7378,8051,7318,7357,8808,8055,8075,4491,8014,7353,7546,7253,7552,7166,7520,8587,7313,7957)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a