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,9322,9476,6599,3827,6504,9410,9419,8166,1814,9390,9344,8788,8589,5133,6601,6495,6597,3191,6503,9388,9403,6377,9420,8866,8809,8876,9448,9305,8870,9391,1809,5094,8872,9412,9423,9382,5108,1811,6474,8781,8842,9409,9383,8875,7943,8790,3196,8877,8895,8789,5132,8744,6132,9301,5987,9327,9363,9364,9424,9421,9422,8869,9450,9342,9329,6602,8774,7947,8841,9384,9303,5511,8782,7217,6375,9095,6505,6362,9528,8853,9527,9524,9523,9522,6506,9520,9519,9518,8599,9517,9425,9511,9477,9479,8020,9510,9509,4491,9507,8775,8848,9505,7484,9504,9503,9494,6124,8807,8879,9463,9358,9334,9447,9277,9014,6596,6603,8860,7110,5109,8732,9339,3123,8721,8019,8699,9336,7523,9389,5004,7954,8691,7531,6612,8167,5111,9017,5656,8832,9411,8820,9328,3008,6459,6004,6610,9309,6142,8708,7473,9304,8855,7482,9016,9204,9206,9205,9478,7216,8595,6502,9202,7488,3007,6476,9267,9442,6376,8765,9430,8562,8634,5985,8854,5009,5967,7562,4423,7239,7940,8668,8794,6565,7951,8773,6598,7377,6604,9484,6412,8569,8776,3609,8685,4422,8719,8126,8597,8897,7238,5542,5994,7565,3126,6564,9360,6007,8661,9143,8586,8665,3122,9116,8593,8612,8018,8697,9302,4563,8746,5031,7297,5966,7944,7298,8016,7295,6013,6415,8725,5093,6473,5541,8688,6146,7935,8857,8766,3124,9398,8698,6611,8635,6171,7374,8627,7477,8896,6001,8798,8718,9361,3610,7236,7946,7300,8568,8958,5092,6403,8696,8047,7218,5745,7474,7949,6035,7472,3140,8722,8703,8588,6127,7171,8633,7486,6475,8632,7470,7956,7564,6497,8745,7522,6609,8731,7945,8684,4485,8624,6020,6145,7303,8144,9341,7938,8663,8652,7478,7294,8859,6000,8747,7955,8637,5030,3129,6464,8662,6018,8125,8645,6607,5920,3188,8856,8585,7950,8143,8046,7133,6143,7536,9362,8822,6413,7406,3657,8638,8704,8849,8630,7475,8570,8598,8640,8631,8001,8596,5991,8687,8779,8720,8606,7476,6151,7309,5989,7942,6606,8751,8693,8604,6155,6140,8017,4562,8590,5969,7995,6508,9314,9307,8821,7538,8690,9308,8692,7550,7981,9316,8686,7460,9315,6496,8705,7395,7549,7210,8128,7349,8639,7551,7533,8044,8628,7250,7964,7936,8013,8074,7937,7965,6566,7571,7464,7355,7235,7787,8124,8024,8800,8824,8701,7241,7234,8008,7413,8002,7306,3094,5744,7352,7224,7247,7468,7393,7983,7394,7398,7941,5645,7463,8176,8094,7458,7351,7548,7289,7399,5997,6520,7408,7307,7485,7539,1569,6396,8097,6139,8823,7313,7792,7753,7243,8587,7152,8051,7957,7290,2363,3179,8072,8129,7203,8694,6364,7959,8831,6499,8162,8100,6493,7249,8071,8636,7552,8808,8014,7318,7487,7540,6647,7353,7308,8095,6340,6002,8120,6365,7534,7939,7311,7788,5738,7253,5696,5107,6633,6613,8075,7690,7532,8629,7248,7251,6361,8010,3023,8783,8797,6461,7520,8871,6501,7357,6352,6133,6509,8055,7319,7166,7378,7639,7177,7407,7245,7288,7537,7405,5965,6417,8025,8077,7546,8623,7980,8653)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a