Опис

Продам новый комплект сцепления валео с одномассовым маховиком, 835035 подходит на различные автомобили концерна фольцваген. Комплект полностью новый. Комплект был преобретен , установлен на сто и после установки мастера поняли что он те подошел( досадная реальность) естественно после демонтажа продавец не принял его обратно потому как были следы установки. Отдаю дешевле чем купил.
Marka Model Typ Kod silnika Moc [kW] Moc [KM] Pojemność [cm3] Lata produkcji
AUDI A3 (8P1) 1.6 TDI CAYB 66 90 1598 2009.05 - 2012.08
AUDI A3 (8P1) 1.6 TDI CAYC 77 105 1598 2009.05 - 2012.08
AUDI A3 (8P1) 1.9 TDI BKC, BLS, BXE 77 105 1896 2003.05 - 2010.05
AUDI A3 kabriolet (8P7) 1.6 TDI CAYC 77 105 1598 2009.05 - 2013.05
AUDI A3 kabriolet (8P7) 1.9 TDI BLS 77 105 1896 2008.04 - 2009.10
AUDI A3 Sportback (8PA) 1.6 TDI CAYC 77 105 1598 2009.05 - 2013.03
AUDI A3 Sportback (8PA) 1.6 TDI CAYB 66 90 1598 2009.05 - 2013.03
AUDI A3 Sportback (8PA) 1.9 TDI BKC, BLS, BXE 77 105 1896 2004.09 - 2010.05
SEAT ALTEA (5P1) 1.6 TDI CAYC 77 105 1598 2009.10 -
SEAT ALTEA (5P1) 1.9 TDI BKC, BJB, BLS, BXE 77 105 1896 2004.04 -
SEAT ALTEA XL (5P5, 5P8) 1.9 TDI BKC, BLS, BXE 77 105 1896 2006.10 -
SEAT LEON (1P1) 1.6 TDI CAYC 77 105 1598 2010.02 - 2012.12
SEAT LEON (1P1) 1.9 TDI BKC, BLS, BXE 77 105 1896 2005.07 - 2010.12
SEAT TOLEDO III (5P2) 1.9 TDI BKC, BJB, BLS, BXE 77 105 1896 2004.10 - 2009.05
SKODA OCTAVIA II (1Z3) 1.6 TDI CAYC 77 105 1598 2009.06 - 2013.04
SKODA OCTAVIA II (1Z3) 1.9 TDI BKC, BJB, BLS, BXE 77 105 1896 2004.06 - 2010.12
SKODA OCTAVIA II Combi (1Z5) 1.6 TDI CAYC 77 105 1598 2009.06 - 2013.04
SKODA OCTAVIA II Combi (1Z5) 1.9 TDI BKC, BJB, BLS, BXE 77 105 1896 2004.09 - 2010.12
SKODA SUPERB II (3T4) 1.9 TDI BLS, BXE 77 105 1896 2008.03 - 2010.11
SKODA SUPERB II kombi (3T5) 1.9 TDI BLS, BXE 77 105 1896 2009.10 - 2010.11
SKODA YETI (5L) 2.0 TDI CFHA, CLCA, DFSA, CUUA 81 110 1968 2009.11 - 2017.12
VW CADDY III Furgon (2KA, 2KH, 2CA, 2CH) 1.9 TDI BJB, BLS 77 105 1896 2004.04 - 2010.08
VW CADDY III Furgon (2KA, 2KH, 2CA, 2CH) 1.9 TDI 4motion BLS 77 105 1896 2008.11 - 2010.08
VW CADDY III kombi (2KB, 2KJ, 2CB, 2CJ) 1.9 TDI BJB, BLS 77 105 1896 2004.04 - 2010.08
VW CADDY III kombi (2KB, 2KJ, 2CB, 2CJ) 1.9 TDI 4motion BLS 77 105 1896 2008.05 - 2010.08
VW GOLF PLUS (5M1, 521) 1.6 TDI CAYB 66 90 1598 2009.02 - 2013.12
VW GOLF PLUS (5M1, 521) 1.6 TDI CAYC 77 105 1598 2009.03 - 2013.12
VW GOLF PLUS (5M1, 521) 1.9 TDI BKC, BLS, BXE 77 105 1896 2005.01 - 2009.01
VW GOLF PLUS (5M1, 521) 1.9 TDI BRU, BXF, BXJ 66 90 1896 2005.05 - 2008.12
VW GOLF PLUS (5M1, 521) 2.0 TDI CBDC, CLCA 81 110 1968 2009.01 - 2013.12
VW GOLF V (1K1) 1.9 TDI BKC, BLS, BXE 77 105 1896 2003.10 - 2008.11
VW GOLF V (1K1) 1.9 TDI BRU, BXF, BXJ 66 90 1896 2004.05 - 2008.11
VW GOLF V (1K1) 1.9 TDI 4motion BKC, BLS, BXE 77 105 1896 2004.08 - 2008.11
VW GOLF V Variant (1K5) 1.9 TDI BLS, BXE 77 105 1896 2007.06 - 2009.07
VW GOLF V Variant (1K5) 1.9 TDI 4motion BLS 77 105 1896 2008.01 - 2009.07
VW GOLF VI (5K1) 1.6 TDI CAYC 77 105 1598 2009.02 - 2012.11
VW GOLF VI (5K1) 1.6 TDI CAYB 66 90 1598 2009.02 - 2012.11
VW GOLF VI (5K1) 2.0 TDI CBDC, CLCA 81 110 1968 2008.10 - 2012.11
VW GOLF VI Variant (AJ5) 1.6 TDI 4motion CAYC 77 105 1598 2009.07 - 2013.07
VW GOLF VI Variant (AJ5) 1.6 TDI CAYC 77 105 1598 2009.07 - 2013.07
VW GOLF VI Variant (AJ5) 1.6 TDI CAYB 66 90 1598 2009.12 - 2013.07
VW JETTA III (1K2) 1.6 TDI CAYC 77 105 1598 2009.06 - 2010.10
VW JETTA III (1K2) 1.9 TDI BKC, BLS, BXE 77 105 1896 2005.08 - 2010.10
VW PASSAT (3C2) 1.6 TDI CAYC 77 105 1598 2009.08 - 2010.07
VW PASSAT (3C2) 1.9 TDI BKC, BLS, BXE 77 105 1896 2005.03 - 2010.07
VW PASSAT (3C2) 2.0 TDI CBDC 81 110 1968 2008.11 - 2010.07
VW PASSAT Variant (3C5) 1.6 TDI CAYC 77 105 1598 2009.08 - 2010.11
VW PASSAT Variant (3C5) 1.9 TDI BKC, BLS, BXE 77 105 1896 2005.08 - 2010.11
VW PASSAT Variant (3C5) 2.0 TDI CBDC 81 110 1968 2008.11 - 2010.11
VW TOURAN (1T1, 1T2) 1.9 TDI AVQ 74 100 1896 2003.02 - 2004.05
VW TOURAN (1T1, 1T2) 1.9 TDI BKC, BLS, BXE 77 105 1896 2003.08 - 2010.05
VW TOURAN (1T1, 1T2) 1.9 TDI BRU, BXF, BXJ 66 90 1896 2004.11 - 2010.05
VW TOURAN (1T3) 1.6 TDI CAYB 66 90 1598 2010.05 - 2015.05
VW TOURAN (1T3) 1.6 TDI CAYC 77 105

Схожі оголошення

OK · 805.9 ms · SQL 13 (24 ms) · ES 3 (766.4 ms) · PHP 8.5.12 · 0.9 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 51.6 ms · знайдено 103571, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            9
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 117
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 180414510
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 0,
    "size": 8,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}
POST /abyhomcom/_search → 200 · 6.5 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 180414510
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 708.3 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 117
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    9
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2126,
                                    117,
                                    2101,
                                    2127,
                                    2129,
                                    2131,
                                    2132,
                                    2133,
                                    2716,
                                    2717,
                                    3072,
                                    3132,
                                    3133,
                                    3134,
                                    3135,
                                    3136,
                                    3137,
                                    3138,
                                    3139,
                                    3141,
                                    3142,
                                    3143,
                                    3144,
                                    3145,
                                    3146,
                                    3147,
                                    3148,
                                    3149,
                                    3150,
                                    3151,
                                    3152,
                                    3621,
                                    3645,
                                    3646,
                                    6101,
                                    6121,
                                    6125,
                                    6133,
                                    6167,
                                    6191,
                                    6198,
                                    6200,
                                    6208,
                                    6222,
                                    6224,
                                    6263,
                                    6278,
                                    6284,
                                    6304,
                                    6308,
                                    6311,
                                    6334,
                                    6347,
                                    6348,
                                    6368,
                                    6387,
                                    6403,
                                    6404,
                                    6432,
                                    6440,
                                    6451,
                                    6469,
                                    6477,
                                    6480,
                                    6490,
                                    6509,
                                    6527,
                                    6548,
                                    6561,
                                    6564,
                                    6577,
                                    6581,
                                    6590,
                                    6594,
                                    6613,
                                    6619,
                                    6624,
                                    6635,
                                    6645,
                                    6680,
                                    6686,
                                    6693,
                                    6698,
                                    6753,
                                    6773,
                                    6796,
                                    6800,
                                    6825,
                                    6850,
                                    6910,
                                    6958,
                                    6968,
                                    6970,
                                    6983,
                                    7013,
                                    7016,
                                    7017,
                                    7045,
                                    7046,
                                    7067,
                                    7086,
                                    7088,
                                    7095,
                                    7100,
                                    7113,
                                    7119,
                                    7142,
                                    7179,
                                    7195,
                                    7231,
                                    7239,
                                    7256,
                                    7272,
                                    7273,
                                    7274,
                                    7342,
                                    7350,
                                    7367,
                                    7381,
                                    7405,
                                    7456,
                                    7516,
                                    7524,
                                    7535,
                                    7538,
                                    7556,
                                    7565,
                                    7567,
                                    7568,
                                    7592,
                                    7597,
                                    7600,
                                    7622,
                                    7650,
                                    7679,
                                    7697,
                                    7729,
                                    7759,
                                    7802,
                                    7819,
                                    7823,
                                    7872,
                                    7873,
                                    7919,
                                    7940,
                                    7967,
                                    8024,
                                    8038,
                                    8048,
                                    8049,
                                    8069,
                                    8071,
                                    8089,
                                    8108,
                                    8120,
                                    8124,
                                    8156,
                                    8182,
                                    8196,
                                    8205,
                                    8219,
                                    8226,
                                    8281,
                                    8317,
                                    8342,
                                    8364,
                                    8371,
                                    8387,
                                    8401,
                                    8409,
                                    8546,
                                    8581,
                                    8591,
                                    8604,
                                    8623,
                                    8629,
                                    8646,
                                    8648,
                                    8659,
                                    8673,
                                    8691,
                                    8696,
                                    8707,
                                    8721,
                                    8737,
                                    8755,
                                    8785,
                                    8786,
                                    8794,
                                    8798,
                                    8800,
                                    8828,
                                    8840,
                                    8843,
                                    8886,
                                    8904,
                                    8926,
                                    8940,
                                    8980,
                                    9008,
                                    9045,
                                    9063,
                                    9096,
                                    9118,
                                    9144,
                                    9153,
                                    9157,
                                    9165,
                                    9176,
                                    9185,
                                    9188,
                                    9197,
                                    9207,
                                    9210,
                                    9211,
                                    9218,
                                    9226,
                                    9228,
                                    9284,
                                    9286,
                                    9349,
                                    9361,
                                    9366,
                                    9386,
                                    9388,
                                    9398,
                                    9445,
                                    9455,
                                    9545,
                                    9559,
                                    9570,
                                    9593,
                                    9624,
                                    9668,
                                    9687,
                                    9690,
                                    9704,
                                    9732,
                                    9733,
                                    9742,
                                    9765,
                                    9776,
                                    9786,
                                    9863,
                                    9865,
                                    9895,
                                    9905,
                                    9909,
                                    9953,
                                    9976,
                                    10021,
                                    10077,
                                    10090,
                                    10093,
                                    10098,
                                    10122,
                                    10164,
                                    10169,
                                    10174,
                                    10176,
                                    10196,
                                    10203,
                                    10208,
                                    10217,
                                    10224,
                                    10231,
                                    10238,
                                    10252,
                                    10266,
                                    10285,
                                    10309,
                                    10320,
                                    10330,
                                    10416,
                                    10425,
                                    10461,
                                    10475,
                                    10508,
                                    10524,
                                    10593,
                                    10605,
                                    10615,
                                    10674,
                                    10697,
                                    10707,
                                    10712,
                                    10730,
                                    10733,
                                    10749,
                                    10750,
                                    10773,
                                    10786,
                                    10815,
                                    10827,
                                    10841,
                                    10872,
                                    10922,
                                    10933,
                                    10949,
                                    10961,
                                    10962,
                                    10964,
                                    10978,
                                    10982,
                                    10991,
                                    11080,
                                    11117,
                                    11145,
                                    11229,
                                    11233,
                                    11240,
                                    11242,
                                    11257,
                                    11262,
                                    11268,
                                    11273,
                                    11283,
                                    11315,
                                    11333,
                                    11337,
                                    11358,
                                    11376,
                                    11389,
                                    11417,
                                    11430,
                                    11433,
                                    11453,
                                    11456,
                                    11464,
                                    11497,
                                    11532,
                                    11557,
                                    11577,
                                    11582,
                                    11608,
                                    11633,
                                    11695,
                                    11707,
                                    11713,
                                    11729,
                                    11768,
                                    11769,
                                    11805,
                                    11830,
                                    11835,
                                    11848,
                                    11861,
                                    11966,
                                    12052,
                                    12057,
                                    12090,
                                    12100,
                                    12154,
                                    12162,
                                    12164,
                                    12167,
                                    12168,
                                    12170,
                                    12185,
                                    12189,
                                    12222,
                                    12235,
                                    12257,
                                    12272,
                                    12306,
                                    12316,
                                    12332,
                                    12344,
                                    12388,
                                    12407,
                                    12432,
                                    12452,
                                    12463,
                                    12478,
                                    12483,
                                    12494,
                                    12523,
                                    12584,
                                    12585,
                                    12589,
                                    12591,
                                    12632,
                                    12643,
                                    12647,
                                    12650,
                                    12706,
                                    12711,
                                    12712
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.26 ms
SELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?) AND (1=1) [180414510] · 1.46 ms
SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [180414510] · 1.07 ms
SELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?,?,?,?,?,?,?,?) AND (1=1) [219548089,219548086,219547405,219547276,219546694,219546691,219546688,219546115] · 1.57 ms
SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?,?,?,?,?,?,?,?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [219546115,219546688,219546691,219546694,219547276,219547405,219548086,219548089] · 0.82 ms
SELECT c.* FROM `category` c ORDER BY c.id · 1.85 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.id IN (?) [117] · 0.7 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.45 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.id IN (?) [2126] · 0.39 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2126] · 0.41 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [117,2101,2127,2129,2131,2132,2133,2716,2717,3072,3132,3133,3134,3135,3136,3137,3138,3139,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3621,3645,3646,6101,6121,6125,6133,6167,6191,6198,6200,6208,6222,6224,6263,6278,6284,6304,6308,6311,6334,6347,6348,6368,6387,6403,6404,6432,6440,6451,6469,6477,6480,6490,6509,6527,6548,6561,6564,6577,6581,6590,6594,6613,6619,6624,6635,6645,6680,6686,6693,6698,6753,6773,6796,6800,6825,6850,6910,6958,6968,6970,6983,7013,7016,7017,7045,7046,7067,7086,7088,7095,7100,7113,7119,7142,7179,7195,7231,7239,7256,7272,7273,7274,7342,7350,7367,7381,7405,7456,7516,7524,7535,7538,7556,7565,7567,7568,7592,7597,7600,7622,7650,7679,7697,7729,7759,7802,7819,7823,7872,7873,7919,7940,7967,8024,8038,8048,8049,8069,8071,8089,8108,8120,8124,8156,8182,8196,8205,8219,8226,8281,8317,8342,8364,8371,8387,8401,8409,8546,8581,8591,8604,8623,8629,8646,8648,8659,8673,8691,8696,8707,8721,8737,8755,8785,8786,8794,8798,8800,8828,8840,8843,8886,8904,8926,8940,8980,9008,9045,9063,9096,9118,9144,9153,9157,9165,9176,9185,9188,9197,9207,9210,9211,9218,9226,9228,9284,9286,9349,9361,9366,9386,9388,9398,9445,9455,9545,9559,9570,9593,9624,9668,9687,9690,9704,9732,9733,9742,9765,9776,9786,9863,9865,9895,9905,9909,9953,9976,10021,10077,10090,10093,10098,10122,10164,10169,10174,10176,10196,10203,10208,10217,10224,10231,10238,10252,10266,10285,10309,10320,10330,10416,10425,10461,10475,10508,10524,10593,10605,10615,10674,10697,10707,10712,10730,10733,10749,10750,10773,10786,10815,10827,10841,10872,10922,10933,10949,10961,10962,10964,10978,10982,10991,11080,11117,11145,11229,11233,11240,11242,11257,11262,11268,11273,11283,11315,11333,11337,11358,11376,11389,11417,11430,11433,11453,11456,11464,11497,11532,11557,11577,11582,11608,11633,11695,11707,11713,11729,11768,11769,11805,11830,11835,11848,11861,11966,12052,12057,12090,12100,12154,12162,12164,12167,12168,12170,12185,12189,12222,12235,12257,12272,12306,12316,12332,12344,12388,12407,12432,12452,12463,12478,12483,12494,12523,12584,12585,12589,12591,12632,12643,12647,12650,12706,12711,12712] · 2.51 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [117,2101,2133,6334,2131,6133,2129,7272,3646,6208,3148,10231,3137,2717,6970,7274,2716,6224,3142,6198,6191,3147,3146,6263,3150,6304,6278,6348,3645,6284] · 10.91 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.56 ms