Skoda Fabia III (NJ3) 1.0 TSI 12V
Używane Sonda lambda
Marża € 34,99
Można zamówić bezpośrednio
Rok produkcji2020 |Kod klasyfikacjiA2 |Typ silnikaBenzyna, Benzyna z wtryskiem bezposrednim, Benzyna z wtryskiem bezposrednim (Turbo) |Pojemnosc silnika999 cc |Kod silnikaDKLD |Liczba rdzeni4 |MiejsceTyl |Numer artykulu04E906262GESzczegół Oryginalna część
Gwarancja 3 mnd
Dostawca Schaap & Bron
Skoda Fabia III (NJ3) 1.0 TSI 12V
Używane Sonda lambda
Marża € 34,99
Można zamówić bezpośrednio
Rok produkcji07-2019 |Kod klasyfikacjiA2 |Typ silnikaBenzyna, Benzyna z wtryskiem bezposrednim, Benzyna z wtryskiem bezposrednim (Turbo) |Pojemnosc silnika999 cc |Kod silnikaDKLD |Liczba rdzeni6 |MiejscePrzód |Przebiegu auta52 526 km |Numer artykulu04E906262GDSzczegół Used Lambda probe in good condition
Gwarancja 3 mnd
Dostawca Venema Autoparts
Skoda Fabia III Combi (NJ5) 1.2 TSI 16V Greentech
Używane Sonda lambda
Marża € 34,00
Można zamówić bezpośrednio
Rok produkcji2015 |Kod klasyfikacjiC1 |Typ silnikaBenzyna z wtryskiem wielopunktowym |Pojemnosc silnika1 200 cc |Kod silnikaCJZ |Liczba rdzeni4 |MiejsceTyl |Przebiegu auta151 401 km |Numer artykulu04E906262BHSzczegół STAN SCHUDNIONY, UŻYTKOWY, SPRAWDZONY POD KĄTEM DZIAŁANIA
Gwarancja 3 mnd
Dostawca Gebr Opdam B.V.
Skoda Fabia III (NJ3) 1.0 TSI 12V
Używane Sonda lambda
€ 39,00 Z VAT
Można zamówić bezpośrednio
Rok produkcji2020 |Kod klasyfikacjiA1 |Typ silnikaBenzyna z wtryskiem wielopunktowym (Turbo), Wtrysk benzyny, Benzyna |Pojemnosc silnika1 000 cc |Kod silnikaDKL |Liczba rdzeni6 |MiejscePrzód |Przebiegu auta13 277 km |Numer artykulu04E906262GESzczegół SPRAWDZONY PODCZAS DZIAŁANIA I W BARDZO DOBRYM STANIE.\ OBEJMUJE GWARANCJĘ NA INSTALACJĘ I ROZBUDĘ.
Gwarancja 12 mnd
Dostawca Automaterialen Ronald Morien B.V.
Skoda Fabia II Combi 1.2 TDI 12V Greenline
Używane Sonda lambda
Marża € 20,00
Można zamówić bezpośrednio
Rok produkcji2011 |Kod klasyfikacjiA2 |Typ silnikaDiesel |Pojemnosc silnika1 199 cc |Kod silnikaCFWA |Liczba rdzeni6 |MiejscePrzód |Numer artykulu03P906262BGwarancja 3 mnd
Dostawca Rooie Ben autodemontage
Skoda Fabia II (5J) 1.2 TSI
Używane Sonda lambda
Marża € 20,00
Można zamówić bezpośrednio
Rok produkcji08-2014 |Kod klasyfikacjiC2 |Typ silnikaBenzyna z wtryskiem wielopunktowym |Pojemnosc silnika1 197 cc |Kod silnikaCBZ |Liczba rdzeni4 |MiejsceTyl |Przebiegu auta156 873 km |Numer artykulu1634546Szczegół zobacz zdjęcie
Gwarancja 3 mnd
Dostawca Autorec. Gebr. Prins b.v.
Skoda Fabia II Combi 1.2i 12V
Używane Sonda lambda
Marża € 10,00
Można zamówić bezpośrednio
Rok produkcji2012 |Kod klasyfikacjiA2 |Typ silnikaBenzyna |Pojemnosc silnika1 198 cc |Kod silnikaCGP |Liczba rdzeni4 |MiejsceTyl |Przebiegu auta230 310 kmSzczegół In goede staat, na de katalysator
Gwarancja 3 mnd
Dostawca Autodemontagebedrijf Otte
Skoda Fabia II (5J) 1.2i 12V
Używane Sonda lambda
Marża € 25,00
Można zamówić bezpośrednio
Rok produkcji2009 |Kod klasyfikacjiC1 |Typ silnikaBenzyna |Pojemnosc silnika1 198 cc |Kod silnikaCGPA |Liczba rdzeni4 |MiejscePrzód |Przebiegu auta155 595 km |Numer artykulu03E906262CSzczegół Wtyczka 4-pinowa.
Gwarancja 3 mnd
Dostawca Autorecycling Reuvers B.V.
Skoda Fabia III Combi (NJ5) 1.2 TSI 16V Greentech
Używane Sonda lambda
Marża € 25,00
Można zamówić bezpośrednio
Rok produkcji2016 |Kod klasyfikacjiA2 |Typ silnikaBenzyna, Benzyna z wtryskiem wielopunktowym |Pojemnosc silnika1 197 cc |Kod silnikaCJZC |Liczba rdzeni4 |MiejsceTyl |Przebiegu auta120 000 km |Numer artykulu0258030129Szczegół Zadbany stan
Gwarancja 3 mnd
Dostawca Autobedrijf Brooks
Skoda Fabia II (5J) 1.2i 12V
Używane Sonda lambda
Marża € 25,00
Można zamówić bezpośrednio
Rok produkcji2011 |Kod klasyfikacjiC1 |Typ silnikaBenzyna |Pojemnosc silnika1 198 cc |Kod silnikaCGPA |Liczba rdzeni4 |MiejsceTyl |Przebiegu auta144 209 km |Numer artykulu03C906262CGwarancja 6 mnd
Dostawca Auto- en demontagebedrijf Eindewege
PreLoad
{ "Data": { "SessionId": 3, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/skoda/model/fabia/czesc/sonda-lambda/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/skoda/model/fabia/czesc/sonda-lambda/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/skoda/model/fabia/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-15T14:24:17.7461059+02:00", "UrlRawCurrent": "/magazyn-czesci/szukaj/marka/honda/model/prelude/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/szukaj/marka/honda/model/prelude/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/szukaj/marka/honda/model/prelude/" ], "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 } }{ "Data": { "SessionId": 2, "Match": null, "Timestamp": "2026-08-15T14:24:19.3867182+02:00", "UrlRawCurrent": "/magazyn-czesci/szukaj/numer-czesci/9656389980/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/szukaj/numer-czesci/9656389980/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/szukaj/numer-czesci/9656389980/" ], "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": 3, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/skoda/model/fabia/czesc/sonda-lambda/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/skoda/model/fabia/czesc/sonda-lambda/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/skoda/model/fabia/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] = '40X10X' OR ([R].[AldocModelCode] IN (33303, 33489, 33618, 34486, 35076, 35081, 37415, 2298, 52794, 52922) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (13364, 15106, 13363, 13362, 14278, 15586, 15107, 14277, 17393, 17456, 17519, 16944, 19225, 19226, 30104, 15503, 15583, 15504, 15585, 15582, 15584, 17395, 17518, 19229, 19230, 19905, 19270, 17321, 16059, 15938, 16060, 16290, 16058, 15937, 17394, 17517, 19227, 19228, 19901, 18149, 18150, 19271, 17396, 19335, 19231, 17397, 133125, 133129, 133375, 23240, 23243, 23245, 23247, 9958, 9961, 10998, 23165, 23166, 23168, 23169, 23167, 23170, 28175, 33244, 33312, 33877, 33680, 33316, 33317, 33682, 9410, 133139, 133165, 133228, 22945, 22946, 22947, 22949, 22948, 22950, 22944, 33243, 33311, 33876, 33679, 33314, 33315, 33681, 9409, 14021, 133135, 133148, 133226, 145017, 145018, 145019, 145238, 146489, 148281, 157377, 801036, 802660, 42655, 108655, 42656, 108656, 42658, 108658, 42657, 108657, 42660, 108660, 42659, 108659, 117784, 117788, 127941, 128141, 131123, 131124, 131223, 42661, 108661, 42662, 108662, 42663, 108663, 117785, 42664, 108664, 42665, 108665, 42666, 108666, 117789, 127942, 128142, 131125)))) 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": 768, "SizeMax": 150, "SetMax": false, "GetIndexMax": 77, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "21888603": 1, "22829294": 1, "17476678": 1, "17368901": 1, "25118679": 1, "22125217": 1, "23334922": 1, "15364798": 1, "24870254": 1, "19676250": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }