Опис

ВСЕ що є в оголошенні Є В НАЯВНОСТІ
Не дають помилки.
Комплект 300 грн, при ОЛХ доставці вказуйте 2 шт.

Світлодіодна, LED підсвітка заднього номера, номерного знаку
В наявності на моделі:

Audi A3 2003 - 2012
Audi S3 2003 - 2012
Audi A4 B7 2006 - 2008
Audi S4 B7 2006 - 2008
Audi RS4 B7 2006 - 2008
Audi A6 C6 2009 - 2011
Audi S6 C6 2009 - 2011
Audi RS6 C6 2009 - 2011
Audi A5 Cabrio / Cabriolet 2008 -
Audi S5 Carbio / Cabriolet 2008 -
Audi Q7 2009 -
Audi A8/S8 D3(4E) (PR-6V2) 2003 - 2008
Audi A8 D4(4H) 2009 -
Audi S8 D4(4H) 2009 -
OEM: 8E0807430A, 8E0807430B, 8E0943021B, 8E0943

Audi A6 C5 4B Avant Wagon 1997 - 2004
Audi RS6 RS6 Plus 2002 - 2004
OEM: 4B9943021

Audi A8 D3 2002 - 2010
OEM: 4E0943021, E40943022

Cadillac Escalade 2002 - 2006
Cadillac Escalade ESV 2003 - 2006
Cadillac Escalade EXT 2002 - 2013
Chevy Avalanche 150*********2013
Chevy Silverado 150*********2013
Chevy Silverado 1500HD 2001 - 2006
Chevy Silverado 250*********2004
Chevy Silverado 2500HD 2001 - 2014
Chevy Silverado 350*********2014
Chevy Suburban 1500 | 250*********2006
Chevy Tahoe 2000 - 2006
GMC Sierra 150*********2013
GMC Sierra 1500 HD 2001 - 2003, 2005 - 2006
GMC Sierra 250*********2004
GMC Sierra 2500 HD 2001 - 2014
GMC Sierra 350*********2014
GMC Yukon 2000 - 2006
GMC Yukon XL 1500 | 250*********2006

Ford Mustang Convertible, Coupe 8Cyl 4.6L 5.4L GT 2005 - 2009
Shelby GT
Shelby GT500,
Bullitt Shelby GT500KR
OEM: 4R3Z-13550-AA 4R3Z13550AA 68179

Ford Mustang 2010 - 2014
Ford Flex 2009 - 2019
Ford Focus 2008 - 2011
Ford Fusion 2008 - 2012
Ford Taurus 2008 - 2019
Lincoln MKS 2009 - 2016
Lincoln MKT 2010 - 2018
Lincoln MKX 2007 - 2015
2008-2012 Lincoln MKZ
Mercury Milan 2008 - 2011
Mercury Sable 2008 - 2009
OEM: 8T5Z13550A, 8T5Z13550B

Ford Transit 1985-1992
Ford Transit/Transit Tourneo MK4 MK5 1991-2000
Ford Transit/Transit Tourneo MK6
Ford Transit Connect/Tourneo Connect (тільки для автомобілів без панелі над ліхтарем номерного знаку) 2002-2013
Ford Transit Courier/Tourneo Courier (тільки для автомобілів без панелі над ліхтарем номерного знаку) 2014 -
OEM: 4388111, 86VB-13550-AH, 1732840, 86VB-13550-AK

Ford Focus MK2 Hatchback Facelifted (2008 - 2010)
Ford Focus MK3 (2010 - )
Ford Fiesta MK6 (2008 - )
Ford Mondeo MK4 (2007 - 2013)
Ford S-Max MK1 (2006 - )
Ford C-Max MK2 (2010 - )
Ford Grand C-Max MK2 (2010 - )
Ford Kuga (2008 - )
Ford Galaxy MK3 (2006 - )

Maserati Ghibli M157 2014-2020
OEM: 67*****01

Maserati Quattroporte V M139 generation 5th 2003 - 2012
OEM: 363100111

Mercedes-benz W220 1999-2005 (S-class) S280 S320 S500 S350
Mercedes-benz W220 AMG

Nissan Frontier 2007 - 2019
Nissan Armada 2008 - 2016
Nissan Titan 2007 - 2015
Nissan Xterra 2007 - 2015
Suzuki Equator 2009 - 2012
Nissan ACMAT ALTV
OEM:26510-ZP50A ,26510-EA820 ,26510-ZP30A, 26510-ZJ00A ,26510-9FM0A

Opel Astra G (хетчбек, універсал) 1998 - 2004
Vauxhall Astra G MK4 (хетчбек, універсал) 1998 - 2004
OEM: 91*******9192*******24052

Peugeot 206 1998-2010 Convertible/Hatchback/Saloon/Estate
Peugeot 207 2006-2012 Coupe/Hatchback/Saloon/Estate
Peugeot 306 1993-2002 Station Wagon/Estate
Peugeot 307 2000-2008 Convertible/Hatchback/Sedan/Station Wagon/Estate
Peugeot 308 2007-2012 Coupe/Station Wagon/Estate
Peugeot 406 1995-2008 Coupe/Sedan/Station Wagon/Estate
Peugeot 407 2004-2010 Coupe/Sedan/Station Wagon/Estate
Peugeot 50*******-2012 5-Door MPV
Peugeot Partner 1996-2002 M49
Peugeot Partner 2002-2008 M59
Peugeot Partner 2008-2012 B9
OEM: 6340.A3
Citroen C3 2002-2009 Convertible/Hatchback mode include C3 I and C3 IIl
Citroen C3 Picasso 2009-2012
Citroen C4 Picasso 2006-2012
Citroen C5 2001-2012 Hatchback/Sedan/Station Wagon/Estate model include C5 I and C5 II
Citroen BERLINGO 1996-2002 M49
Citroen BERLINGO 2002-2008 M59
Citroen BERLINGO 2008-2012 B9
Citroen SAXO 1996-2003 Hatchback model inlcude SAXO I and SAXO II
Citroen XSARA 1997-2006 Hatchback/Sedan/Station Wagon/Estate model include XSARA I and XSARA II
Citroen XSARA Picasso 1999-2010 MPV
OEM: 6340.A3

Porsche Panamera 970 4D 2010 - 2016
OEM: 8TO943021

Volkswagen Eurovan 1993 - 2003
Volkswagen Multivan MK4 / Syncro 1990 - 2003
Volkswagen Passat Estate B5.5 Variant 3BG 2001 - 2005
Volkswagen Passat B6 Combi/Variant 2006-2008
Volkswagen Transporter T4 / Caravelle MK4 (excluding the double cab models) 1990 - 2003
OEM: 701943021

Volrswagen Touran 2003 - 2010
Volrswagen Golf 2005 - 2009
Volrswagen Jetta 2005 - 2010
Volrswagen Caddy III 2004 - 2013
Volrswagen Passat Cimousint 2001 - 2005
Volrswagen Passat Combi/Variant 2006 - 2008
Volrswagen T5 Transporter 2003 - 2009

Volvo XC90 2003 - 2014 from chassie
Volvo S40 2004 - 2014
Volvo v60 2011 - 2015
Volvo XC60 2009 - 2015
Volvo S60 2011 - 2015
Volvo V70 2008 - 2015
Volvo C70 2006 - 2015
Volvo V50*********015
Volvo XC70 2008 - 2015
OEM: 306*******0753839******006

Нові, в наявності. Не дають помилки.
Ціна за штуку.
ОЛХ доставка, самовивіз, часткова або повна передоплата

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

OK · 103 ms · SQL 13 (12.7 ms) · ES 3 (75.2 ms) · PHP 8.5.12 · 0.9 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 65 ms · знайдено 119787, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            9
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 135
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 193005469
                    }
                }
            ]
        }
    },
    "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 · 5.4 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 193005469
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 4.8 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 135
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    9
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2206,
                                    135,
                                    2207,
                                    3108,
                                    3109,
                                    3110,
                                    3111,
                                    3112,
                                    3113,
                                    3114,
                                    3115,
                                    3116,
                                    3117,
                                    3118,
                                    3119,
                                    3120,
                                    3121,
                                    3122,
                                    3123,
                                    3124,
                                    3125,
                                    3126,
                                    3127,
                                    3128,
                                    3129,
                                    3130,
                                    3131,
                                    3140,
                                    3620,
                                    3623,
                                    3624,
                                    6113,
                                    6153,
                                    6160,
                                    6189,
                                    6197,
                                    6212,
                                    6221,
                                    6240,
                                    6280,
                                    6282,
                                    6291,
                                    6295,
                                    6313,
                                    6319,
                                    6322,
                                    6355,
                                    6356,
                                    6367,
                                    6376,
                                    6419,
                                    6425,
                                    6438,
                                    6446,
                                    6450,
                                    6465,
                                    6471,
                                    6486,
                                    6498,
                                    6502,
                                    6508,
                                    6532,
                                    6579,
                                    6604,
                                    6608,
                                    6639,
                                    6657,
                                    6755,
                                    6775,
                                    6812,
                                    6829,
                                    6835,
                                    6838,
                                    6863,
                                    6909,
                                    6920,
                                    6950,
                                    6971,
                                    6973,
                                    6986,
                                    7000,
                                    7007,
                                    7010,
                                    7044,
                                    7047,
                                    7056,
                                    7074,
                                    7075,
                                    7076,
                                    7078,
                                    7101,
                                    7105,
                                    7131,
                                    7190,
                                    7270,
                                    7283,
                                    7297,
                                    7298,
                                    7332,
                                    7383,
                                    7385,
                                    7406,
                                    7422,
                                    7452,
                                    7466,
                                    7476,
                                    7487,
                                    7491,
                                    7557,
                                    7601,
                                    7621,
                                    7626,
                                    7634,
                                    7638,
                                    7659,
                                    7695,
                                    7730,
                                    7788,
                                    7794,
                                    7812,
                                    7852,
                                    7878,
                                    7903,
                                    7912,
                                    7928,
                                    7982,
                                    8017,
                                    8025,
                                    8102,
                                    8197,
                                    8207,
                                    8212,
                                    8227,
                                    8244,
                                    8253,
                                    8264,
                                    8289,
                                    8295,
                                    8299,
                                    8307,
                                    8339,
                                    8357,
                                    8513,
                                    8520,
                                    8521,
                                    8541,
                                    8563,
                                    8572,
                                    8733,
                                    8770,
                                    8850,
                                    8875,
                                    8901,
                                    8911,
                                    8965,
                                    9014,
                                    9041,
                                    9042,
                                    9189,
                                    9200,
                                    9204,
                                    9206,
                                    9233,
                                    9282,
                                    9327,
                                    9342,
                                    9348,
                                    9414,
                                    9521,
                                    9589,
                                    9595,
                                    9599,
                                    9605,
                                    9621,
                                    9625,
                                    9642,
                                    9643,
                                    9650,
                                    9680,
                                    9684,
                                    9729,
                                    9759,
                                    9771,
                                    9814,
                                    9821,
                                    9828,
                                    9839,
                                    9844,
                                    9847,
                                    9888,
                                    9911,
                                    9916,
                                    9931,
                                    9938,
                                    9963,
                                    9973,
                                    9981,
                                    9982,
                                    9987,
                                    9998,
                                    10004,
                                    10058,
                                    10091,
                                    10097,
                                    10111,
                                    10160,
                                    10162,
                                    10229,
                                    10290,
                                    10345,
                                    10354,
                                    10381,
                                    10424,
                                    10459,
                                    10495,
                                    10531,
                                    10535,
                                    10563,
                                    10565,
                                    10577,
                                    10592,
                                    10643,
                                    10708,
                                    10737,
                                    10740,
                                    10807,
                                    10925,
                                    10936,
                                    10938,
                                    10948,
                                    10992,
                                    11046,
                                    11088,
                                    11109,
                                    11115,
                                    11153,
                                    11163,
                                    11222,
                                    11278,
                                    11304,
                                    11309,
                                    11325,
                                    11332,
                                    11421,
                                    11460,
                                    11461,
                                    11511,
                                    11522,
                                    11565,
                                    11631,
                                    11640,
                                    11746,
                                    11765,
                                    11776,
                                    11832,
                                    11868,
                                    11872,
                                    11891,
                                    11895,
                                    12008,
                                    12010,
                                    12015,
                                    12040,
                                    12083,
                                    12086,
                                    12124,
                                    12150,
                                    12169,
                                    12180,
                                    12196,
                                    12218,
                                    12220,
                                    12236,
                                    12270,
                                    12302,
                                    12338,
                                    12367,
                                    12417,
                                    12470,
                                    12481,
                                    12516,
                                    12524,
                                    12539,
                                    12571,
                                    12586,
                                    12607,
                                    12631,
                                    12670,
                                    12680,
                                    12692,
                                    12703,
                                    12710,
                                    12738,
                                    12739
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.12 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) [193005469] · 1.58 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 [193005469] · 1.16 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) [219776454,219776446,219776422,219776414,219775134,219774510,219774374,219774106] · 1.26 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 [219774106,219774374,219774510,219775134,219776414,219776422,219776446,219776454] · 0.61 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.47 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 (?) [135] · 0.41 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.59 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 (?) [2206] · 0.44 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2206] · 0.39 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [135,2207,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3140,3620,3623,3624,6113,6153,6160,6189,6197,6212,6221,6240,6280,6282,6291,6295,6313,6319,6322,6355,6356,6367,6376,6419,6425,6438,6446,6450,6465,6471,6486,6498,6502,6508,6532,6579,6604,6608,6639,6657,6755,6775,6812,6829,6835,6838,6863,6909,6920,6950,6971,6973,6986,7000,7007,7010,7044,7047,7056,7074,7075,7076,7078,7101,7105,7131,7190,7270,7283,7297,7298,7332,7383,7385,7406,7422,7452,7466,7476,7487,7491,7557,7601,7621,7626,7634,7638,7659,7695,7730,7788,7794,7812,7852,7878,7903,7912,7928,7982,8017,8025,8102,8197,8207,8212,8227,8244,8253,8264,8289,8295,8299,8307,8339,8357,8513,8520,8521,8541,8563,8572,8733,8770,8850,8875,8901,8911,8965,9014,9041,9042,9189,9200,9204,9206,9233,9282,9327,9342,9348,9414,9521,9589,9595,9599,9605,9621,9625,9642,9643,9650,9680,9684,9729,9759,9771,9814,9821,9828,9839,9844,9847,9888,9911,9916,9931,9938,9963,9973,9981,9982,9987,9998,10004,10058,10091,10097,10111,10160,10162,10229,10290,10345,10354,10381,10424,10459,10495,10531,10535,10563,10565,10577,10592,10643,10708,10737,10740,10807,10925,10936,10938,10948,10992,11046,11088,11109,11115,11153,11163,11222,11278,11304,11309,11325,11332,11421,11460,11461,11511,11522,11565,11631,11640,11746,11765,11776,11832,11868,11872,11891,11895,12008,12010,12015,12040,12083,12086,12124,12150,12169,12180,12196,12218,12220,12236,12270,12302,12338,12367,12417,12470,12481,12516,12524,12539,12571,12586,12607,12631,12670,12680,12692,12703,12710,12738,12739] · 2.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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [135,3623,3130,3123,3125,12738,3108,12739,3110,3126,3131,6197,6153,3624,6212,3620,3129,3121,3124,3118,3109,6498,6319,6532,6639,6291,3128,6438,7406,6755] · 1.04 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.98 ms