Опис

Продам нові картриджі турбін

E&E turbo TD03-000 4100 грн

Підходить до таких автомобілв
• Opel Astra H 1.7 CDTI Z17DTH 1.7L 100KM/73kW 01.2004 - 12.2006
• Opel Combo C 1.7 CDTI Z17DTH 1.7L 100KM/73kW 01.2004-
• Opel Corsa C 1.7 CDTI Z17DTH 1.7L 100KM/73kW 01.2004 - 12.2006
• Opel Meriva A 1.7 CDTI Z17DTH 1.7L 101KM/74kW 01.2003-
E&E turbo GT15-001 4000 грн
Підходить до таких автомобілв

• Mitsubishi Carisma 1.9 DI-D MP F8Q 1.9L 102KM/75kW 09.199*********04
• Mitsubishi Space Star 1.9 DI-D F9Q DG4A 1.9L 102KM/75kW 01.2001 - 12.2005
• Opel Movano A 1.9 DTI F9Q 1.9L 101KM/74kW 01.2000 - 12.2003
• Opel Vivaro 1.9 DTI F9Q 1.9L 101KM/74kW 01.2000-
• Renault Laguna II 1.9 dCi F9Q 1.9L 101KM/74kW 01.2000-
• Renault Master II 1.9 dCi F9Q 1.9L 102KM/75kW 01.2000-
• Renault Megane I 1.9 dCi F9Q 1.9L 102KM/75kW 01.2000-
• Renault Primastar dCi F9Q 1.9L 102KM/75kW 01.2000-
• Renault Scenic I 1.9 dCi F9Q 1.9L 102KM/75kW 01.2000-
• Renault Trafic II 1.9 dCi F9Q 1.9L 101KM/74kW 01.2001-
• Volvo S40 I 1.9 D F9Q 1.9L 102KM/75kW01.2000 - 12.2004
• Volvo V40 1.9 D F9Q 1.9L 102KM/75kW 01.2000 - 12.2004

E&E turbo GT25-000 3600 грн

Підходить до таких автомобілв
VOLKSWAGEN LT 28-35 II Bus (2DB, 2DE, 2DK) 05/199*********06 05/2001 - 06/2006 2.8 TDI 116/158 AUH, BCQ
VOLKSWAGEN LT 28-46 II Box (2DA, 2DD, 2DH) 05/199*********06 04/2002 - 07/2006 2.8 TDI 116/158 AUH, BCQ
VOLKSWAGEN LT 28-46 II Platform/Chassis (2DC, 2DF, 2DG, 2DL, 2DM) 06/199*********06 04/2002 - 07/2006 2.8 TDI 116/158 AUH, BCQ

Powertechturbo 786997 4100 грн

Підходить до таких автомобілв
Nissan:
NV400 2.3 dCi 100 (74 kW / 100 PS)
NV400 2.3 dCi 110 (81 kW / 110 PS)
NV400 2.3 dCi 125 (92 kW / 125 PS)
Primastar 2.0 dCi 66 kW / 90 PS
Primastar 2.0 dCi (84/85 kW – 114/115 PS)
Opel:
Movano B 2.3 CDTI 100/101 PS (74 kW)
Movano B 2.3 CDTI 110 PS (81 kW)
Movano B 2.3 CDTI 125 PS (92 kW)
Vivaro I 2.0 CDTI 66 kW / 90 PS
Vivaro I 2.0 CDTI (84/85 kW – 114/115 PS)
Renault:
Master III 2.3 dCi 100 (74 kW / 100 PS)
Master III 2.3 dCi 110 (81 kW / 110 PS)
Master III 2.3 dCi 125 (92 kW / 125 PS)
Trafic II 2.0 dCi 66 kW / 90 PS
Trafic II 2.0 dCi (84/85 kW – 114/115 PS)
Двигун:
2.3 M9T | 2.0 M9R

Powertechturbo 543598******4100 грн

Renault Clio II 1.5 dCi K9K-700 65HP 2000-2005
Renault Kangoo I 1.5 dCi K9K-700 65HP 2000-2005
Renault Kangoo I 1.5 dCi K9K-700 65HP 2003
Renault Clio II 1.5 dCi K9K-702 82HP 2001-2005
Renault Kangoo I 1.5 dCi K9K-702 80HP 2001
Renault Megane II 1.5 dCi K9K-702 82HP 2001
Dacia Logan 1.5 dCi K9K-700 65HP 2000
Nissan Almera 1.5 dCi K9K-260 82HP 2001
Nissan Micra 1.5 dCi K9K-260 82HP 2001
Suzuki Jimny 1.5 DDiS K9K 65HP 2003

Powertechturbo 543598******4100 грн

Підходить до таких автомобілв
Citroen Biper,
Citroen Nemo,
Fiat Doblo,
Fiat Fiorino III,
Fiat Idea,
Fiat Panda,
Fiat Punto II,
Lancia Musa,
Lancia Ypsilon,
Opel Agila B,
Opel Combo C,
Opel Corsa D,
Opel Meriva A,
Peugeot Bipper,
Suzuki SWIFT III,
Suzuki Splash,
Vauxhall Corsa
Номер турбіни: 54359880005
Код двигуна: 16v Multijet, Z13DTJ
Об'єм двигуна: 1.3 JTD, 1.3, 1.3 CDTI, 1.3 HDI, 1.3 DDIS
Потужність: 51 кВт-69 к.с., 55 кВт-75 к.с.

Детальні фото картриджів висилаю додатково
Відправляю по Україні

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

OK · 464 ms · SQL 13 (18.9 ms) · ES 3 (427.6 ms) · PHP 8.5.12 · 0.8 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 51.6 ms · знайдено 60992, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            9
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 139
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 196415882
                    }
                }
            ]
        }
    },
    "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 · 38.3 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 196415882
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 337.7 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 139
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    9
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2224,
                                    139,
                                    3542,
                                    3543,
                                    3544,
                                    3545,
                                    3546,
                                    3547,
                                    3548,
                                    3549,
                                    3550,
                                    3551,
                                    3552,
                                    3553,
                                    3631,
                                    3636,
                                    6297,
                                    6400,
                                    6443,
                                    6463,
                                    6623,
                                    6625,
                                    6694,
                                    6897,
                                    6918,
                                    6959,
                                    6977,
                                    7117,
                                    7330,
                                    7341,
                                    7349,
                                    7377,
                                    7389,
                                    7497,
                                    7611,
                                    7648,
                                    7654,
                                    7662,
                                    7711,
                                    7733,
                                    7766,
                                    7784,
                                    7822,
                                    7829,
                                    7832,
                                    7860,
                                    7879,
                                    7890,
                                    7898,
                                    7913,
                                    7923,
                                    7938,
                                    7965,
                                    8014,
                                    8020,
                                    8064,
                                    8068,
                                    8076,
                                    8091,
                                    8139,
                                    8141,
                                    8238,
                                    8247,
                                    8272,
                                    8274,
                                    8302,
                                    8346,
                                    8358,
                                    8399,
                                    8517,
                                    8544,
                                    8620,
                                    8621,
                                    8626,
                                    8657,
                                    8662,
                                    8675,
                                    8719,
                                    8743,
                                    8753,
                                    8819,
                                    8837,
                                    8874,
                                    8953,
                                    9004,
                                    9143,
                                    9159,
                                    9175,
                                    9177,
                                    9209,
                                    9290,
                                    9308,
                                    9422,
                                    9450,
                                    9459,
                                    9483,
                                    9489,
                                    9530,
                                    9604,
                                    9623,
                                    9641,
                                    9682,
                                    9777,
                                    9801,
                                    9810,
                                    9838,
                                    9854,
                                    9927,
                                    9990,
                                    10006,
                                    10009,
                                    10050,
                                    10107,
                                    10171,
                                    10260,
                                    10277,
                                    10300,
                                    10323,
                                    10387,
                                    10419,
                                    10438,
                                    10564,
                                    10614,
                                    10657,
                                    10683,
                                    10772,
                                    10791,
                                    10798,
                                    10803,
                                    10822,
                                    10837,
                                    10840,
                                    10880,
                                    10887,
                                    11020,
                                    11090,
                                    11135,
                                    11136,
                                    11162,
                                    11345,
                                    11354,
                                    11410,
                                    11413,
                                    11468,
                                    11480,
                                    11553,
                                    11628,
                                    11723,
                                    11744,
                                    11766,
                                    11822,
                                    11937,
                                    11997,
                                    11999,
                                    12032,
                                    12104,
                                    12177,
                                    12213,
                                    12261,
                                    12304,
                                    12544,
                                    12547,
                                    12566,
                                    12656,
                                    12737
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.88 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) [196415882] · 2.72 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 [196415882] · 0.58 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) [219366733,219366406,219361876,219356143,219354916,219352204,219351556,219351547] · 1.37 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 [219351547,219351556,219352204,219354916,219356143,219361876,219366406,219366733] · 1.14 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.63 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 (?) [139] · 0.9 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.73 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 (?) [2224] · 2.08 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2224] · 3.91 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [139,3542,3543,3544,3545,3546,3547,3548,3549,3550,3551,3552,3553,3631,3636,6297,6400,6443,6463,6623,6625,6694,6897,6918,6959,6977,7117,7330,7341,7349,7377,7389,7497,7611,7648,7654,7662,7711,7733,7766,7784,7822,7829,7832,7860,7879,7890,7898,7913,7923,7938,7965,8014,8020,8064,8068,8076,8091,8139,8141,8238,8247,8272,8274,8302,8346,8358,8399,8517,8544,8620,8621,8626,8657,8662,8675,8719,8743,8753,8819,8837,8874,8953,9004,9143,9159,9175,9177,9209,9290,9308,9422,9450,9459,9483,9489,9530,9604,9623,9641,9682,9777,9801,9810,9838,9854,9927,9990,10006,10009,10050,10107,10171,10260,10277,10300,10323,10387,10419,10438,10564,10614,10657,10683,10772,10791,10798,10803,10822,10837,10840,10880,10887,11020,11090,11135,11136,11162,11345,11354,11410,11413,11468,11480,11553,11628,11723,11744,11766,11822,11937,11997,11999,12032,12104,12177,12213,12261,12304,12544,12547,12566,12656,12737] · 1.34 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [139,6400,6443,8620,3549,3553,3552,3545,8517,3636,9177,7389,9530,6625,9175,7330,7711,6977,3550,3631,7377,10419,7497,7611,7349,8247,11162,7832,6897,7341] · 0.63 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.95 ms