Mercedes Vito (447.6) 1.6 111 CDI 16V
Używane Sonda lambda
Marża € 14,99
Można zamówić bezpośrednio
Rok produkcji2017 |Kod klasyfikacjiB1 |Typ silnikaDiesel, Diesel Common rail, Diesel Common Rail (Turbo) |Pojemnosc silnika1 598 cc |Kod silnika622951 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta63 263 km |Numer artykuluH8201395330Szczegół Used lambda probe in neat condition.
Gwarancja 3 mnd
Dostawca Venema Autoparts
Mercedes Vito Tourer (447.7) 2.2 114 CDI 16V
Używane Sonda lambda
Marża € 64,00
Można zamówić bezpośrednio
Rok produkcji2018 |Kod klasyfikacjiB1 |Typ silnikaDiesel |Pojemnosc silnika2 200 cc |Kod silnika651950 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta90 322 km |Numer artykulu0065421718Szczegół +ROETFILTERSENSOR
Gwarancja 3 mnd
Dostawca Gebr Opdam B.V.
Mercedes Vito (447.6) 1.6 111 CDI 16V
Używane Sonda lambda
€ 24,20 Z VAT
Można zamówić bezpośrednio
Rok produkcji2015 |Kod klasyfikacjiA2 |Typ silnikaDiesel Common Rail (Turbo) |Pojemnosc silnika1 598 cc |Kod silnikaR9M502 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta185 241 km |Numer artykulu0281004221Szczegół rood geel wit grijs zwart
Gwarancja 3 mnd
Dostawca Autorec. Gebr. Prins b.v.
Mercedes Vito (639.6) 2.2 113 CDI 16V Euro 5
Używane Sonda lambda
€ 25,41 Z VAT
Można zamówić bezpośrednio
Rok produkcji2012 |Kod klasyfikacjiB2 |Typ silnikaDiesel Common Rail (Turbo), Diesel z wtryskiem bezposrednim, Diesel |Pojemnosc silnika2 143 cc |Kod silnika651940 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta85 427 km |Numer artykulu0035426918Gwarancja 3 mnd
Dostawca Autoparts Pater
Mercedes Vito (639.6) 2.2 113 CDI 16V Euro 5
Używane Sonda lambda
Marża € 30,00
Można zamówić bezpośrednio
Rok produkcji08-2012 |Typ silnikaDiesel |Pojemnosc silnika2 143 cc |Kod silnika651940 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta357 024 km |Numer artykulu0035426918Gwarancja 3 mnd
Dostawca Franken Autodemontage B.V.
Mercedes Vito (447.6) 2.0 114 CDI 16V
Używane Sonda lambda
€ 224,95 Z VAT
Można zamówić bezpośrednio
Rok produkcji2024 |Kod klasyfikacjiA2 |Typ silnikaDiesel |Pojemnosc silnika1 950 cc |Kod silnika654920 |Liczba rdzeni6 |MiejsceTyl |Przebiegu auta8 500 km |Numer artykuluA0009059716Szczegół Part is in good, usable condition.
Gwarancja 3 mnd
Dostawca Boonstra Autoparts
Mercedes Vito (639.6) 2.2 109 CDI 16V
Używane Sonda lambda
Marża € 25,00
Można zamówić bezpośrednio
Rok produkcji2008 |Kod klasyfikacjiB2 |Typ silnikaDiesel |Pojemnosc silnika2 148 cc |Kod silnika646980 |Liczba rdzeni6 |MiejscePrzód |Przebiegu auta242 253 km |Numer artykulu0035426918Szczegół 6-POLIGE STEKKER BOSCH
Gwarancja 3 mnd
Dostawca Autobedrijf Brooks
Mercedes Vito (447.6) 1.6 111 CDI 16V
Używane Sonda lambda
€ 24,20 Z VAT
Można zamówić bezpośrednio
Rok produkcji11-2017 |Kod klasyfikacjiC1 |Typ silnikaDiesel |Pojemnosc silnika1 598 cc |Kod silnikaR9M503 |Liczba rdzeni4 |MiejscePrzód |Przebiegu auta116 574 km |Numer artykulu226A41733RSzczegół Price excludes VAT.
Gwarancja 12 mnd
Dostawca AutoHam
Mercedes Vito (639.6) 2.2 109 CDI 16V
Używane Sonda lambda
€ 30,19 Z VAT
Można zamówić bezpośrednio
Rok produkcji01-2008 |Kod klasyfikacjiC1 |Typ silnikaDiesel Common rail |Pojemnosc silnika2 148 cc |Kod silnika646980 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta390 033 km |Numer artykuluA0035426918Szczegół W dobrym stanie!
Gwarancja 3 mnd
Dostawca Sterparts Mercedes specialist
Mercedes Vito (447.6) 2.2 114 CDI 16V
Używane Sonda lambda
€ 29,16 Z VAT
Można zamówić bezpośrednio
Rok produkcji2015 |Kod klasyfikacjiC1 |Typ silnikaDiesel, Diesel (Turbo) |Pojemnosc silnika2 143 cc |Kod silnika651950 |Liczba rdzeni5 |MiejscePrzód |Przebiegu auta183 382 km |Numer artykulu0065421718Szczegół 3 MIESIĄCE GWARANCJI
Gwarancja 3 mnd
Dostawca Autodemontagebedrijf de Jong
PreLoad
{ "Data": { "SessionId": 2, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/mercedes/model/vito/czesc/sonda-lambda/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/mercedes/model/vito/czesc/sonda-lambda/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/mercedes/model/vito/czesc/sonda-lambda/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 0, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 0, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
All sessions
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "2026-08-15T00:51:06.0380862+02:00", "UrlRawCurrent": "/magazyn-czesci/szukaj/kod-silnika/149553a/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/szukaj/kod-silnika/149553a/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/szukaj/kod-silnika/149553a/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": null, "CountryId": 0, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
LoadComplete
{ "Data": { "SessionId": 2, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/mercedes/model/vito/czesc/sonda-lambda/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/mercedes/model/vito/czesc/sonda-lambda/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/mercedes/model/vito/czesc/sonda-lambda/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @RM TABLE ([RecordId] BIGINT NOT NULL, [xPR] DECIMAL(9, 2), [xPS] BIT NOT NULL, [xPD] INT, [xTP] DECIMAL(5, 2) NOT NULL, [xTT] INT NOT NULL, [xShopState] INT, [xShippingState] TINYINT, [xPF] DECIMAL(9, 2), [xPE] DECIMAL(9, 2), [xPI] DECIMAL(9, 2) PRIMARY KEY CLUSTERED (RecordId ASC)) INSERT INTO @RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [xPF], [xPE], [xPI]) SELECT *, CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 1 THEN CAST([xPF] / ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPE], CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 0 THEN CAST([xPF] * ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPI] FROM (SELECT *, CASE WHEN [xPS] = 1 AND [xPR] IS NOT NULL THEN CAST(CASE WHEN [xPD] IS NOT NULL THEN (CAST((100 - ISNULL([xPD], 0)) AS DECIMAL) / 100) * [xPR] ELSE [xPR] END AS DECIMAL(10, 2)) END AS [xPF] FROM (SELECT [R].[RecordId], (ISNULL(CASE WHEN [R].[Shop] = 1 THEN ISNULL([R].[PriceShop],ROUND ( [R].[Prijs] * ((100 + ISNULL([D].[ShopPricePercentage], 0)) / 100), 2)) END, [R].[Prijs])) AS [xPR], CASE WHEN [R].[PrijsTonen] IS NOT NULL THEN [R].[PrijsTonen] WHEN [R].[SoortId] = 0 THEN [D].[OOLPrijzenG] WHEN [R].[SoortId] = 1 THEN [D].[OOLPrijzenR] WHEN [R].[SoortId] = 2 THEN [D].[OOLPrijzenN] ELSE 1 END AS [xPS], (SELECT [T].[Discount] FROM dbo.[AutomatePartDiscount] [T] WHERE [T].[SupplierId] = [R].[DebiteurId] AND [T].[StateId] = [R].[SoortId] AND [T].[PartAutomateId] = [R].[DeelId]) AS [xPD], ISNULL([VT].[General], 21) AS [xTP], CASE WHEN [R].[SoortId] = 0 AND NOT ISNULL([R].[PrijsSoort], 0) = 1 THEN 2 WHEN [D].[OOLPrijzenExcl] = 0 THEN 1 ELSE 0 END AS [xTT], CASE WHEN NOT [D].[ShopActive] = 1 THEN 11 ELSE dbo.fnGetOOLShopStateQuick([R].[RecordId], 1, 7, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '03A56A' OR ([R].[AldocModelCode] IN (34089, 34831, 34832, 32533, 32532, 53646, 53398, 52229, 52842) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (143227, 17416, 17419, 18102, 17417, 17418, 18720, 28164, 20074, 28160, 28161, 28162, 28163, 7621, 7625, 7648, 7627, 7686, 7695, 59487, 7842, 5339, 5340, 5341, 11420, 11421, 11419, 17414, 17415, 18101, 17413, 17412, 28155, 28156, 28157, 28158, 28159, 28507, 30127, 7606, 7610, 7614, 7605, 59428, 59426, 59486, 5979, 8896, 5978, 8983, 11269, 11270, 11099, 11100, 14005, 14006, 14007, 11097, 11098, 143285, 143284, 145733, 158825, 64511, 107511, 64512, 107512, 64513, 107513, 64514, 107514, 64515, 107515, 43296, 109296, 42033, 116120, 116121, 136010, 136011, 141298, 136012, 136013, 136014, 136015, 138136, 138135, 140412, 140413, 143283, 143282, 146684, 158821, 156280, 64516, 107516, 64517, 107517, 64518, 107518, 64519, 107519, 64520, 107520, 43294, 109294, 116123, 42037, 116124, 136272, 136273, 136271, 136269, 136270, 136268, 136036, 136004, 136005, 136006, 136007, 136008, 136009, 136279, 136280, 138108, 138133, 140408, 140406, 143279, 143274, 60831, 100831, 60829, 100829, 60826, 100826, 43297, 109297, 112666, 112665, 136031, 136030, 136029, 136028, 136026, 136027, 141189, 145732, 801624, 64505, 107505, 64503, 107503, 64508, 107508, 64506, 107506, 64510, 107510, 116119, 116117, 116118, 136003, 138131, 138134, 140460, 140459, 140461, 140463, 140462)))) AND [R].[DeelId] IN ('8750X') AND [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 111111, 123456, 123457, 123462)) [RM] LEFT JOIN dbo.[OOLInternet] [R] ON [R].[RecordId] = [RM].[RecordId] LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1) LEFT JOIN [Basis].dbo.[CountryVatRate] [VT] ON [VT].[CountryId] = [D].[LandId] AND [VT].[Active] = 1 OUTER APPLY (SELECT dbo.fnGetOOLShippingStateExtended([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 616, NULL) [xShippingState]) [SHS]) [R]) [R]; SELECT [R].[DeelId], [R].[SoortId], COUNT(*) AS [Aantal] FROM (SELECT [R].[DeelId], [R].[SoortId], [R].[RecordId], [R].[DebiteurId], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState] FROM @RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) [R] GROUP BY [R].[DeelId], [R].[SoortId]; SELECT [R].*, [xTP] AS [PrijsTaxPerc], [xPD] AS [PrijsKorting], (SELECT [VIBM].[Bouwmaand] FROM dbo.[VOLInternet] [VIBM] WHERE [VIBM].[RecordId] = [R].[AutoRecordId]) AS [ConstructionMonth], [xPE] AS [PrijsAlt], STUFF((SELECT '|' + CAST([V].[VeldId] AS VARCHAR(10)) + '^' + [V].[Waarde] FROM (SELECT [V].[VeldId], [V].[Waarde], [V].[OrderId] FROM dbo.[OOLVelden] [V] WHERE [V].[RecordId] = [R].[RecordId] AND [V].[VeldId] IN (26)) [V] ORDER BY [V].[VeldId], [V].[OrderId] FOR XML PATH('')), 1, 1, '') AS [Automate2Velden], CASE WHEN [R].[GarantieToelichting] IS NOT NULL THEN (SELECT TOP 1 [TV].[Translation] FROM [Storage].dbo.[TranslateTextResult] [TV] WHERE [TV].[TextId] = (SELECT [TR].[TextId] FROM [Storage].dbo.[TranslateTextRecord] [TR] WHERE [TR].[RecordId] = [R].[RecordId] AND [TR].[TextTypeId] = 2) AND [TV].[LanguageId] IN (7, 2, 1) ORDER BY [TV].[LanguageId] DESC) END AS [GarantieTranslated], CASE WHEN [R].[BijzonderheidInet] IS NOT NULL THEN (SELECT TOP 1 [TV].[Translation] FROM [Storage].dbo.[TranslateTextResult] [TV] WHERE [TV].[TextId] = (SELECT [TR].[TextId] FROM [Storage].dbo.[TranslateTextRecord] [TR] WHERE [TR].[RecordId] = [R].[RecordId] AND [TR].[TextTypeId] = 1) AND [TV].[LanguageId] IN (7, 2, 1) ORDER BY [TV].[LanguageId] DESC) END AS [BijzonderheidInetTranslated], [xShopState] AS [ShopState], CASE WHEN [R].[AldocModelCode] IS NOT NULL THEN (SELECT ISNULL((STUFF((SELECT '^' + [T3].[NaamInternet] + '~' + [T2].[NaamInternet] FROM [Basis].dbo.[AutomateModellenTranslated] [T2] LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [T3] ON [T3].[MerkId] = [T2].[MerkId] AND [T3].[LanguageId] = 7 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 7 AND [T2].[Synoniem] = 0 FOR XML PATH('')), 1, 1,'')), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocModelOmschrijvingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode] AND [T].[LanguageId] = 7), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 7), '')) END AS [AldocDescription] FROM (SELECT [R].*, ROW_NUMBER() OVER (PARTITION BY R.SortId, R.DebiteurId ORDER BY SortId + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, CASE WHEN [12] IS NULL THEN 1 END ASC, [12] DESC, CASE WHEN [14] IS NULL THEN 1 END ASC, [14] ASC, RIGHT([RecordId], 2)%(DATEPART(WEEKDAY, GETDATE()) + 3) ASC, [RecordId] ASC) AS [RowId] FROM (SELECT [R].[SortId], [R].[RecordId], [R].[DebiteurId], [R].[ExternalId], [R].[ReferenceId], [R].[Youtube] AS [181], [184], [190], ISNULL([R].[Fotos], (SELECT 'G^' + CAST([G].[GroupId] AS VARCHAR(20)) + '^' + [G].[Images] FROM dbo.[OOLFotoGroups] [G] WHERE [G].[DebiteurId] = [R].[DebiteurId] AND [G].[SModelId] = [R].[SModelId] AND [G].[DeelId] = [R].[DeelId])) AS [58], [R].[SoortId] AS [StateId], CASE WHEN SUBSTRING([R].[ModelId], 1, 3) IN ('00X', '0XX') THEN NULL ELSE [MET].[NaamInternet] + '^' + [MOT].[NaamInternet] END AS [MakeModel], [xPS] AS [PrijsTonen], CASE WHEN [xTT] IN (0, 1) THEN 1 ELSE [xTT] END AS [PrijsTaxType], [xPI] AS [14], [R].[Bouwjaar] AS [12], [R].[AutoRecordId], CASE WHEN [135] IS NULL THEN CASE WHEN [R].[SoortId] = 0 THEN [D].[OOLGarantieG] WHEN [R].[SoortId] = 1 THEN [D].[OOLGarantieR] WHEN [R].[SoortId] = 2 THEN [D].[OOLGarantieN] ELSE NULL END ELSE [135] END AS [135], [37], STUFF((SELECT '|' + [XVT].[NaamLang] FROM dbo.[OOLVelden] [XOV] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [XVT] ON [XVT].[VeldId] = [XOV].[VeldId] AND [XVT].[LanguageId] = 7 AND [XVT].[Waarde] = [XOV].[Waarde] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 17 ORDER BY [XOV].[OrderId] FOR XML PATH('')), 1, 1, '') AS [17], CASE WHEN [102] = 'E' THEN 'E85' WHEN [102] = 'G' THEN 'G3 LPG' WHEN [102] = 'C' THEN 'Gaz ziemny' WHEN [102] = 'H' THEN 'Hybryda' WHEN [102] = 'L' THEN 'LPG' WHEN ISNULL([102], '') = '' THEN NULL ELSE [102] END AS [102], TRY_CAST([18] AS INT) AS [18], [R].[Motorcodes] AS [108], TRY_CAST([166] AS INT) AS [166], CASE WHEN [105] = 'V' THEN 'Przód' WHEN [105] = 'A' THEN 'Tyl' WHEN ISNULL([105], '') = '' THEN NULL ELSE [105] END AS [105], (SELECT TOP 1 [XOV].[Waarde] FROM dbo.[OOLVelden] [XOV] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 241 ORDER BY [XOV].[OrderId]) AS [241], TRY_CAST([26] AS INT) AS [26], [25], [R].[Artikelnummers] AS [21], ISNULL([D].[Bedrijfsnaam], '') + '|' + ISNULL([D].[BedrijfKort], '') AS [Leverancier], [R].[BijzonderheidInet], [R].[WarrantyText] AS [GarantieToelichting], [R].[Shop], [R].[Created], [xShippingState] AS [ShippingState], [R].[WarrantyConstruction] AS [WarrantyInstallation], [R].[DeelId], [R].[DebiteurRecordId], [R].[AldocModelCode], [R].[AldocTypeId], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState], [R].[SModelId], [R].[ModelId], [R].[PrijsSoort], [R].[PriceShop] FROM (SELECT * FROM (SELECT [R].*, [OV].[VeldId], [OV].[Waarde] FROM (SELECT [R].[SortId], [R].[RecordId], [R].[DebiteurId], [R].[ExternalId], [R].[ReferenceId], [R].[Youtube], [R].[Fotos], [R].[SoortId], [R].[PrijsTonen], [R].[Prijs], [R].[Bouwjaar], [R].[AutoRecordId], [R].[Motorcodes], [R].[Artikelnummers], [R].[BijzonderheidInet], [R].[WarrantyText], [R].[Shop], [R].[Created], [R].[WarrantyConstruction], [R].[DeelId], [R].[DebiteurRecordId], [R].[AldocModelCode], [R].[AldocTypeId], [R].[DebiteurLocatieId], [R].[SModelId], [R].[ModelId], [R].[PrijsSoort], [R].[PriceShop], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState] FROM @RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) AS [R] LEFT JOIN dbo.[OOLVelden] [OV] WITH (INDEX(PK_OOLVelden)) ON [OV].[RecordId] = [R].[RecordId] AND [OV].[VeldId] IN (184, 190, 135, 37, 102, 18, 166, 105, 241, 26, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [102], [18], [166], [105], [241], [26], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 7 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 7 LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) [R] ORDER BY [SortId] DESC, + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [RowId] ASC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY) [R]; WITH [R] AS (SELECT [R].[RecordId], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState], [Bouwjaar], [xPI] AS [Prijs], [ModelId] FROM @RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId] LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) SELECT [VeldId], [Waarde] AS [Value], NULL AS [ValueMIN], NULL AS [ValueMAX] FROM dbo.[OOLVelden] [OV] WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (184,190,37,17,102,105,241,25) GROUP BY [VeldId], [Waarde] UNION SELECT [VeldId], NULL AS [Value], MIN([Waarde]) AS [ValueMIN], MAX([Waarde]) AS [ValueMAX] FROM (SELECT [VeldId], TRY_CAST([Waarde] AS INT) AS [Waarde] FROM dbo.[OOLVelden] [OV] WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (135,18,166,26)) [OV] GROUP BY [VeldId] UNION SELECT 12, NULL AS [Value], MIN([R].[Bouwjaar]) AS [ValueMIN], MAX([R].[Bouwjaar]) AS [ValueMAX] FROM [R] UNION SELECT 14, NULL AS [Value], MIN(CAST([Prijs] AS INT)) AS [ValueMIN], MAX(CAST([Prijs] AS INT)) AS [ValueMAX] FROM [R] ORDER BY 1, 2; SELECT DISTINCT [R].[DebiteurId] FROM (SELECT DISTINCT [DebiteurId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE [R].[RecordId] In (Select [RM].[RecordId] FROM @RM [RM])) [R]" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 248, "SizeMax": 150, "SetMax": false, "GetIndexMax": 25, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "16728075": 1, "16911532": 1, "16180615": 1, "4701431": 1, "19915786": 1, "23410764": 1, "6445851": 1, "21812487": 1, "24393376": 1, "12916095": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }