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