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