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,4650,1840,9329,9328,8876,6599,1844,8877,9135,7161,8890,1814,8094,6597,8927,8446,7094,9034,9267,9277,6602,8855,3191,6503,1809,9524,9494,9503,9505,9504,9511,9523,9522,9510,9517,9507,9509,9450,9478,9484,9477,9479,9448,9425,9423,9424,3827,8853,8020,6604,6004,7157,9322,9139,6596,7473,6609,7571,5987,9403,9398,8815,9220,5111,9388,8930,9206,9384,9382,9344,9204,8662,8872,9342,1811,9334,9174,9327,8918,9303,8832,7470,7522,8929,7484,7605,9205,8857,6146,5092,8502,8047,7160,9202,6127,9121,5994,6610,8144,8924,6502,9068,6171,8663,8501,8792,8828,9179,8773,6612,9158,8126,6606,9117,5091,9115,8914,8875,8016,9093,5322,8774,5366,9130,9044,9043,4654,7549,9042,5135,7832,9013,8745,4653,8879,9010,9006,8859,1839,6000,9074,8848,9063,9116,2356,8915,7874,8775,9111,8860,9094,8971,6850,5316,8789,5427,7219,8894,5991,6124,5985,9011,5315,7523,5321,8708,5139,8854,5134,8794,5656,7110,2107,9091,8721,8019,5967,5470,6945,8719,7833,8018,3123,5136,5407,6001,6598,7835,4652,8776,8751,8746,7854,8998,8725,9113,8744,5433,8327,6611,6013,9110,3126,3122,6877,8017,8523,5473,6007,8491,8666,8668,7764,5966,7005,5140,7935,8366,4563,8598,6157,7184,9021,5137,8665,4834,5307,7946,3777,6210,8365,3124,8518,4042,9316,9315,9314,9307,6155,9112,8448,6140,8667,6006,8661,7858,8325,7981,9109,4485,5465,5444,7536,9108,8692,6020,8125,4562,6018,3188,3129,5408,7841,6143,8435,6145,5306,8434,5875,5439,5443,5438,5437,8324,7705,7928,8400,8747,5884,8407,7006,8718,5898,5899,8779,8010,8439,1812,8392,4043,2837,2838,4045,2839,4041,5896,4561,4037,8363,3789,8856,8570,8652,8143,5890,8443,8624,7603,7929,8797,7567,8507,8849,7735,8405,5354,8519,5426,7930,7533,6508,7569,7550,8280,8690,8693,8074,7983,6844,5343,5989,6846,8436,5409,7210,6837,7593,7609,8521,8221,8445,7551,5435,7667,6758,7628,7548,8517,7159,7637,8329,8278,7158,5434,4036,8506,6847,5440,5997,7289,5436,7307,6843,7162,6759,7485,7651,6845,7610,5965,5471,5301,5975,5976,5984,7630,5983,5982,7378,5303,5468,6139,7318,8072,8694,8279,8281,5968,8313,6002,7636,6842,8404,7635,6873,8444,6848,7612,7534,8871,8331,8277,8623,7980,8831,6633,8881,9136,7616,5873,8251,8252,7631,6878,7546,7595,7615,3788,5969,7288,8399,8403,7634,4491,8330,6841,8075,8077)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a