Volkswagen Caddy IV 2.0 TDI 75
Begagnade Växellåda
€ 600,00 Marginal
Tillverkningsår2018 |KlassificeringskodX |MotortypDiesel |MotorkodDFSF |Motorkapacitet1 968 cc |Växellåda5-växlad |DrevFramhjul |VäxellådskodRTG |Vägmätaravläsning215 818 km/h |DelnummerRTG18051814Särskildhet SEE PHOTO SUPPORT BROKEN!!!!!
Garanti 3 mnd
Leverantör Autodemontage van de Laar
Volkswagen Caddy Cargo V (SBA/SBH) 2.0 TDI BlueMotionTechnology
Begagnade Växellåda
€ 1.450,00 Marginal
Tillverkningsår05-2023 |KlassificeringskodB1 |MotortypDiesel |MotorkodDTR |Motorkapacitet1 968 cc |Växellåda6-växlad |DrevFramhjul |VäxellådskodVCN |Vägmätaravläsning42 848 km/h |Delnummer0C9300045NSärskildhet NETTE BRUIKBARE STAAT / KM STAND AANTOONBAAR, ZIE FOTO
Garanti 3 mnd
Leverantör Gebr Opdam B.V.
Volkswagen Caddy
Begagnade Växellåda
€ 2.750,00 Marginal
Tillverkningsår2025 |KlassificeringskodA2 |MotortypDirektinsprutning, bensin (turbo) |Motorkapacitet1 500 cc |VäxellådaDSG |DrevFramhjul |VäxellådskodWFM |Vägmätaravläsning9 km/h |Delnummer0GC300058GSärskildhet DSG DQ381 FWD Please note: Without mechatronics Bitte beachten Sie: Ohne Mechatronik Remarque : sans mécatronique Atención: Sin mecatrónica
Garanti 12 mnd
Leverantör Klein Gunnewiek Autodemontage & Motorentechniek
Volkswagen Caddy IV 2.0 TDI 102
Begagnade Växellåda
€ 1.050,00 Marginal
Tillverkningsår2018 |KlassificeringskodC1 |MotortypDiesel |MotorkodDFSD |Motorkapacitet1 968 cc |VäxellådaAutomatisk |DrevFramhjul |VäxellådskodSFA |Vägmätaravläsning174 734 km/hGaranti 6 mnd
Leverantör Reclycar De Boer BV
Volkswagen Caddy III (2KA,2KH,2CA,2CH) 1.6 TDI 16V
Begagnade Växellåda
€ 2.419,94 Inkl. moms
Tillverkningsår2015 |KlassificeringskodC2 |MotortypDiesel |MotorkodCAYD |Motorkapacitet1 598 cc |VäxellådaAutomatisk |DrevFramhjul |VäxellådskodQHJ |Vägmätaravläsning150 000 km/h |Delnummer0AM300062QSärskildhet Complete with mechatronic
Garanti 6 mnd
Leverantör Boonstra Autoparts
Volkswagen Caddy II (9K9A) 1.9 SDI
Begagnade Växellåda
€ 262,50 Marginal
Tillverkningsår2003 |KlassificeringskodA2 |MotortypDiesel |MotorkodAYQ |Motorkapacitet1 896 cc |Växellåda5-växlad |DrevFramhjul |VäxellådskodFVW |Vägmätaravläsning321 724 km/hSärskildhet see pictures
Garanti 3 mnd
Leverantör Zelissen V.O.F. autodemontage
Volkswagen Caddy III (2KA,2KH,2CA,2CH) 1.9 TDI
Begagnade Växellåda
€ 575,00 Marginal
Tillverkningsår2006 |KlassificeringskodC1 |MotortypDiesel, Dieselenhetsinsprutare (turbo) |MotorkodBLS |Motorkapacitet1 896 cc |VäxellådaAutomatisk |DrevFramhjul |VäxellådskodHXY |Vägmätaravläsning342 605 km/h |Delnummer02E300043LXSärskildhet Functionality tested
Garanti 3 mnd
Leverantör Autobedrijf Brooks
Volkswagen Caddy III (2KA,2KH,2CA,2CH) 1.6 TDI 16V
Begagnade Växellåda
€ 485,00 Marginal
Tillverkningsår2011 |KlassificeringskodC1 |MotortypDiesel |MotorkodCAYE |Motorkapacitet1 598 cc |Växellåda5-växlad |DrevFramhjul |VäxellådskodLZY |Vägmätaravläsning150 391 km/h |Delnummer0A4300046JGaranti 3 mnd
Leverantör Autodemontage Poelstra B.V.
Volkswagen Caddy Combi IV 1.4 TSI 16V
Begagnade Växellåda
€ 1.500,00 Marginal
Tillverkningsår2017 |KlassificeringskodC2 |MotortypBensin |MotorkodCZC |Motorkapacitet1 395 cc |VäxellådaAutomatisk |DrevFramhjul |VäxellådskodSLX |Delnummer0AM300041FSärskildhet comes as in the picture
Garanti 4 mnd
Leverantör Autodemontagebedrijf De Mars
Volkswagen Caddy III (2KA,2KH,2CA,2CH) 1.9 TDI
Begagnade Växellåda
€ 423,50 Inkl. moms
Tillverkningsår09-2010 |KlassificeringskodC1 |MotortypDieselinsprutare |MotorkodBLS |Motorkapacitet1 896 cc |Växellåda5-växlad |DrevFramhjul |VäxellådskodJCS |Vägmätaravläsning227 123 km/hSärskildhet 1x bevesteging gelast
Garanti 3 mnd
Leverantör Autobedrijf Broekhuis B.V.
PreLoad
{ "Data": { "SessionId": 2, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/bildelar-lager/resultat/varumarke/volkswagen/modell/caddy/elemento/vaxellada/", "UrlAbsoluteCurrent": "/url_voorraad/bildelar-lager/resultat/varumarke/volkswagen/modell/caddy/elemento/vaxellada/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/bildelar-lager/resultat/varumarke/volkswagen/modell/caddy/elemento/vaxellada/" ], "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": "Sverige", "CountryId": 752, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
All sessions
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "2026-08-14T22:31:11.0040622+02:00", "UrlRawCurrent": "/bildelar-lager/sok/vaxelladans-kod/jpg/", "UrlAbsoluteCurrent": "/url_voorraad/bildelar-lager/sok/vaxelladans-kod/jpg/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/bildelar-lager/sok/vaxelladans-kod/jpg/" ], "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": "/bildelar-lager/resultat/varumarke/volkswagen/modell/caddy/elemento/vaxellada/", "UrlAbsoluteCurrent": "/url_voorraad/bildelar-lager/resultat/varumarke/volkswagen/modell/caddy/elemento/vaxellada/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/bildelar-lager/resultat/varumarke/volkswagen/modell/caddy/elemento/vaxellada/" ], "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, 9, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '06A83A' OR ([R].[AldocModelCode] IN (5866, 31777, 34279, 34533, 34534, 34535, 34536, 1357, 1361, 53912, 53913, 57154, 57174) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (146785, 146783, 146782, 146780, 146781, 158798, 5302, 18156, 15411, 5303, 5304, 7940, 13059, 15813, 18484, 18485, 18486, 18487, 18488, 18489, 18491, 18490, 4817, 4820, 4816, 4818, 19420, 10593, 10592, 17804, 17809, 17808, 17805, 24465, 19692, 19694, 24467, 4001, 34953, 34954, 34957, 34958, 34955, 34956, 11160, 10752, 11155, 11156, 15143, 15235, 19236, 17803, 17806, 17810, 17807, 19744, 19693, 19666, 24466, 30401, 34951, 34948, 34950, 34947, 34952, 34949, 11158, 10751, 15135, 15284, 142443, 142442, 142905, 143264, 143775, 148110, 148189, 158797, 800291, 142444, 142445, 142446, 143260, 143809, 148109, 148338, 158796, 800290, 114357, 114348, 114349, 38006, 114344, 117959, 38005, 114343, 38007, 114345, 114350, 38014, 114352, 114354, 38009, 114347, 38008, 114346, 114351, 117957, 117961, 118454, 38010, 38011, 38019, 38013, 138026, 140895, 114334, 114333, 114332, 41024, 117952, 37989, 114327, 37991, 114329, 37990, 114328, 114336, 38001, 114339, 114337, 114330, 114342, 114341, 117951, 37995, 37994, 37998, 37996, 118472, 133860, 135023, 140892, 118481, 118482, 118483, 118484, 118485, 118486, 118487, 118488, 118489, 134739, 134745, 139174, 139175, 139176, 139178, 139177, 139179, 118490, 118491, 118492, 118493, 118494, 118495, 118496, 118497, 118498, 139045, 139133, 139135, 139134, 139137, 139136)))) AND [R].[DeelId] IN ('8851A') 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], 752, 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, 230, 231, 244)) [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 (9, 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 (9, 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] = 9 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 9 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] = 9), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 9), '')) 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], [DOT].[Enkelvoud] AS [Onderdeel], [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] = 9 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], [R].[Motorcodes] AS [108], TRY_CAST([18] AS INT) AS [18], [V19].[NaamLang] AS [19], CASE WHEN [36] = '4' THEN '4x4' WHEN [36] = 'A' THEN 'Bakhjul' WHEN [36] = 'V' THEN 'Framhjul' WHEN ISNULL([36], '') = '' THEN NULL ELSE [36] END AS [36], [R].[Versnellingsbakcodes] AS [114], (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].[Versnellingsbakcodes], [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, 18, 19, 36, 241, 26, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [19], [36], [241], [26], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 9 LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 9 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 9 LEFT JOIN [Basis].dbo.[AutomateOnderdelenTranslated] [DOT] ON [DOT].[DeelId] = [R].[DeelId] AND [DOT].[LanguageId] = 9 AND [DOT].[OrderId] = CASE WHEN [19] IN ('A', 'D', 'SA') THEN 2 ELSE 1 END 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,19,36,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,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": 734, "SizeMax": 150, "SetMax": false, "GetIndexMax": 74, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "19716913": 1, "24793947": 1, "25129299": 1, "25291186": 1, "21853460": 1, "17440398": 1, "23446393": 1, "25282533": 1, "23219763": 1, "23186133": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Sverige", "CountryId": 752, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }