SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prixgros,promogros,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prixgros!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9322,6599,3827,6504,1814,9390,8589,5133,6601,6597,3191,6503,9388,9403,1809,5094,9382,5108,1811,9383,7943,3196,5132,9301,5987,6602,7947,9384,9303,5511,7217,6505,9523,9522,6506,8599,9517,8020,9510,9509,9507,7484,6124,6596,6603,7110,8019,7523,9389,6612,5111,9017,5656,6459,6004,6610,6142,7473,9304,7482,9016,7216,8595,6502,7488,9430,8562,5985,5967,7562,7940,6565,7951,6598,7377,6604,8569,8685,8597,5994,7565,6564,8586,8593,8612,8018,9302,7297,5966,7944,7298,8016,7295,5093,6146,7935,9398,6611,6171,7374,7477,6001,7946,7300,8568,5092,7218,5745,7949,7472,8588,6127,7486,7470,7564,7522,6609,7945,6145,7303,7938,7478,7294,6000,7955,6464,6607,7950,6143,7536,7475,8570,8598,8596,5991,8606,7476,6151,7309,5989,7942,8604,6155,6140,8017,8590,5969,6508,9314,9307,7538,9308,9316,9315,7210,7533,7936,7937,6566,7306,7941,5997,7485,7539,6139,7313,8587,7957,7290,7487,6647,6002,7534,7939,7311,5738,5107,6633,6613,7532,8010,6461,7378,7537,5965)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a