SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,9472,9471,8757,8741,9178,7323,9415,8736,7493,9152,8738,9414,7322,9090,9418,7449,9416,9461,9024,9490,9487,9486,9460,9485,9459,9458,8843,9153,7558,9149,9076,9125,7330,8756,7885,9122,8814,8815,9089,8524,9028,7486,9075,8812,8768,7886,9176,8754,8811,6961,9127,7489,6283,9124,9123,6968,9025,6962,9126,8810,8316,8740,8242,8241,8813,8323,6959,8319,8250,8340,6960,8314,8341,8243,8343,5920,8342,8339,6882,8447,9023,9027,6966,7391,9026,8733,8248,7325,8240,8315,8321,7484,8459,7533,8400,8457,7428,7488,9022,6880,7416,8318,7381,7536,6874,8529,6317,7386,7567,8322,7930,8528,6881,6967,7538,7446,7447,7569,7383,6864,6868,7390,7410,7400,7490,6871,7429,7379,7389,7435,7443,7452,7539,7380,7025,7423,6873,7440,7426,7434,7534,8399,7491,7403,7537,6876,7026,7417,7494,6875,7487,7425)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a