SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,9433,9476,7545,6599,3002,3827,9371,6504,9356,9410,5950,9419,2461,8166,6109,1814,7543,9390,8584,9344,8576,8788,9378,8589,8834,5133,8031,6601,8735,6495,8080,6597,9225,3191,8617,6503,9413,9388,7556,9403,9402,6377,9399,9420,9474,8866,9395,8809,9392,8876,8757,9448,9471,9305,9393,8870,9415,9391,8736,1809,9458,5094,8734,8872,9337,9412,8865,9423,8763,9382,9358,5108,9400,1811,7554,6474,9405,8781,9325,8842,6804,9409,7961,9383,9346,8875,9397,7943,3621,8790,9293,3196,9379,8877,9313,8895,8768,8789,8741,5132,9331,8744,8754,6132,9435,9301,9359,5987,2991,9327,9437,9363,9414,9364,9269,9424,8738,9421,9274,9422,9440,8869,9428,9450,9266,9342,8727,9329,9272,6602,8755,8774,9357,7947,9242,8841,8827,9384,9355,9303,8846,5511,9436,8782,9475,7217,9380,6375,9348,9095,9326,6505,8670,6362,9438,9528,9377,8853,9297,9527,9368,9524,7450,9523,3168,9522,9396,6506,9372,9520,9394,9519,9290,9518,9340,8599,8796,9517,6108,9425,9324,9511,6106,9477,9347,9479,9245,8020,9254,9510,8873,9509,9298,4491,9417,9507,8740,8775,6384,8848,9446,9505,9481,7484,9247,9504,9271,9503,9335,9494,9373,6124,9459,8807,9376,8879,9257,9463,9284,8868,9334,9268,9447,9350,9277,9367,9014,8673,6596,9287,6603,9227,8860,7451,7110,9349,5109,7328,8732,9250,9339,9432,3123,9439,8721,9441,8019,9375,8699,9353,9336,9288,7523,8818,9389,8845,5004,8844,7954,9281,8691,9427,7531,9370,6612,9381,8167,8730,5111,9332,9017,9192,5656,9292,8832,8750,9411,9226,8820,9278,9328,8163,3008,8780,6459,9352,6004,9265,6610,7952,9309,9255,6142,5040,8708,9434,7473,9279,9304,9374,8855,7137,7482,7480,9016,8867,9204,6349,9206,9311,9205,7323,9478,7448,7216,8160,8595,8787,6502,8864,9202,9401,7488,7558,3007,7449,6476,9445,9267,8733,9442,9246,6376,9354,8765,9526,9430,9515,8562,7329,8634,7411,5985,9514,8854,8168,5009,9513,5967,9512,7562,9228,4423,9499,7239,9498,7940,4368,8668,9289,8794,9495,6565,9492,7951,9491,8773,9490,6598,9487,7377,8742,6604,9486,9484,8749,6412,9485,8569,9483,8776,9482,3609,8829,8685,9480,4422,8772,8719,7993,8126,7493,8597,9473,8897,9472,7238,9461,5542,3769,5994,8756,7565,9460,3126,4429,6564,9249,9360,8170,6007,3170,8661,9234,9143,9449,8586,9444,8665,9443,3122,9282,9116,8592,8593,6406,8612,9248,8018,9243,8697,8079,9302,9312,4563,9431,8746,8851,5031,8874,7297,7322,5966,6408,7944,3171,7298,9426,8016,9191,7295,9280,6013,8671,6415,9429,8725,5535,5093,8770,6473,7299,5541,2422,8688,9188,6146,9275,7935,5624,8857,8603,8766,7330,3124,8000,9398,6302,8698,7150,6611,9182,8635,8608,6171,9201,7374,9457,8627,7976,7477,9299,8896,4497,6001,8706,8798,9187,8718,9181,9361,9194,3610,9286,7236,9351,7946,8709,7300,7331,8568,7541,8958,9283,5092,8695,6403,7542,8696,9338,8047,6306,7218,9406,5745,9333,7474,7991,7949,8621,6035,9330,7472,8611,3140,6290,8722,8607,8703,7960,8588,8647,6127,8600,7171,6405,8633,9296,7486,7987,6475,8123,8632,7267,7470,8861,7956,8717,7564,8615,6497,8753,8745,8171,7522,9015,6609,7296,8731,9276,7945,8748,8684,8778,4485,9273,8624,9345,6020,9343,6145,9270,7303,8858,8144,7139,9341,9258,7938,9244,8663,9310,8652,8767,7478,9300,7294,6390,8859,8651,6000,8622,8747,8726,7955,9238,8637,9237,5030,9285,3129,7971,6464,8027,8662,8609,6018,8601,8125,9200,8645,8771,6607,9199,5920,9198,3188,8737,8856,9197,8585,8591,7950,9453,8143,9196,8046,8137,7133,9452,6143,9195,7536,8715,9362,9451,8822,9193,6413,8145,7406,8649,3657,9190,8638,8710,8704,8702,8849,9189,8630,8084,7475,9186,8570,8683,8598,9185,8640,9184,8631,8026,8001,9183,8596,6291,5991,8669,8687,8674,8779,9180,8720,8619,8606,6296,7476,9236,6151,8777,7309,9235,5989,6492,7942,9233,6606,9232,8751,9231,8693,8138,8604,8658,6155,8643,6140,7268,8017,8830,4562,8656,8590,8581,5969,8878,7995,5537,6508,8620,9314,8626,9307,8646,8821,8578,7538,8728,8690,8303,9308,8828,8692,8819,7550,8642,7981,8654,9316,8602,8686,8426,7460,8119,9315,7368,6496,8700,8705,8122,7395,7731,7549,7229,7210,8644,8128,8716,7349,8573,8639,9291,7551,8583,7533,8655,8044,7962,8628,8610,7250,9241,7964,8743,7936,7387,8013,8850,8074,8792,7937,7978,7965,8582,6566,8962,7571,7544,7464,6318,7355,7142,7235,8707,7787,8711,8124,6498,8024,8579,8800,7366,8824,8039,8701,8112,7241,8729,7234,7515,8008,8572,7413,7992,8002,3163,7306,6553,3094,8618,5744,8118,7352,8574,7224,8028,7247,8852,7468,6491,7393,7204,7983,6422,7394,8659,7398,8175,7941,8577,5645,8034,7463,8076,8176,7725,8094,7555,7458,8847,7351,7363,7548,8575,7289,8037,7399,7293,5997,8839,6520,8224,7408,8029,7307,7314,7485,8038,7539,7282,1569,2462,6396,8040,8097,7172,6139,9456,8823,9455,7313,9454,7792,7989,7753,8799,7243,7364,8587,8724,7152,8042,8051,8641,7957,8146,7290,8136,2363,8752,3179,8023,8072,8723,8129,7361,7203,7996,8694,7222,6364,8302,7959,8004,8831,7220,6499,8613,8162,7985,8100,6562,6493,5649,7249,3029,8071,7325,8636,4432,7552,7362,8808,7173,8014,3680,7318,4456,7487,8614,7540,6317,6647,7312,7353,7372,7308,8229,8095,1818,6340,8739,6002,6513,8120,7291,6365,7167,7534,5481,7939,7258,7311,7365,7788,8045,5738,8078,7253,7135,5696,8117,5107,7276,6633,7519,6613,6383,8075,6312,7690,7367,7532,8083,8629,7301,7248,7396,7251,8005,6361,6407,8010,8625,3023,7371,8783,7302,8797,6102,6461,7270,7520,8135,8871,7997,6501,7233,7357,7265,6352,7202,6133,8786,6509,8116,8055,8106,7319,7724,7166,8053,7378,8833,7639,7231,7177,8758,7407,8760,7245,8838,7288,8571,7537,7727,7405,7198,5965,8150,6417,7281,8025,8142,8077,6326,7546,8152,8623,7138,7980,6382,8653,5565,8011,8616,7199,6314,7979,7526,7260,7494,7272,7274,8759,8259,6344,6458,7283,8085,6484,7728,6866,7335,7499,8103,8087,8088,8475,8159,7211,7213,6797,8092,7271,8605,6648,7336,7844,8169,7168,6800,7726,6581,7261,8714,6592,8785,8835,8836,8713,8863,8672,8795,8826,7259,6331,8769,6642,8131,7263,6441,8837,8712,6558,7963,7510,7972,7373,6022,8825,6096,8784,8862,8033,8580,7262,7953,7273,8049,6052,8009,8035,8132,6311,7966,8151,8238,6301,7984,7200,8089,7504,3649,7809,7998,7230,7227,7986,6341,8161,6313,6595,8105,6082,7264,6332,6627,4426,6582,6101)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND ( promo!='0' OR prixo!='0') ORDER BY (id-(20*num)) DESCErr153a