Motor mit motorcode M2DC Generalüberholung
Anbieter Alexander Autodemontage
- RecordId
- 23532026
- WebId
- -
- AutoRecordId
- 0
- Prijs Origineel
- 2057,00
- Prijs Soort
- BTW
- Prijs BTW
- Included
- Prijs Tonen
- True
- Internet (AM)
- Ja (Nein)
- Shop
- Ja
- Aantal (Infinite)
- 1 (Nein)
- OrderStatus
- Ok ( Record is bestelbaar )
- Verkocht
- -
- InternetID
- 90999
- SKU
- P23532026
- Baujahr
- 2015
- OE-nummer
- F1FG6006BARMF1G6006BA
- Spezifikationscode
- -
- Klassifizierungscode
- R1
- Überprüft und repariert
- Auf Funktion überprüft
- Motortyp
- Benzin
- Motorcode
- M2DCM1DA
- Hubraum
- 998 cc
- Tachostand
- 0 km
- Kilowatt
- 92 kW
- Emissionsklasse
- Euro 5
- Getriebe typ
- Schalt
- Start-Stopp-System
- Ja
- Besonderheiten
- Foto's dienen als voorbeeld.
Op aanvraag, levertijd bedraagt 1,5 week.
Revisie motor met 12 maanden garantie! Komt met nieuwe distributieriemset met waterpomp. Oude blok retour (Zonder gat.)!
Dieser Teil kann für die folgenden Typen gelten.
- Ford B-Max (JK8)
- 1.4 16V LPG, MPV, 1.388cc, 64kW (87pk), FWD, RTJC, 2013-08 / 2017-12
- 1.4 16V LPG, MPV, 1.388cc, 64kW (87pk), FWD, RTJE, 2016-08 / 2017-12
- 1.0 EcoBoost 12V 100, MPV, Benzin, 999cc, 74kW (101pk), FWD, SFJA, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 100, MPV, Benzin, 999cc, 74kW (101pk), FWD, SFJA; SFJB; SFJC; SFJD, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 100, MPV, Benzin, 999cc, 74kW (101pk), FWD, SFJB, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 100, MPV, Benzin, 999cc, 74kW (101pk), FWD, SFJC, 2015-03 / 2017-12
- 1.0 EcoBoost 12V 100, MPV, Benzin, 999cc, 74kW (101pk), FWD, SFJD, 2015-03 / 2017-12
- 1.0 EcoBoost 12V 120, MPV, Benzin, 998cc, 88kW (120pk), FWD, M1JA, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 125, MPV, Benzin, 998cc, 92kW (125pk), FWD, M1JE, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 125, MPV, Benzin, 998cc, 92kW (125pk), FWD, M1JE; M1JH, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 125, MPV, Benzin, 998cc, 92kW (125pk), FWD, M1JH, 2015-04 / 2017-12
- 1.0 EcoBoost 12V 140, MPV, Benzin, 998cc, 103kW (140pk), FWD, YYJC, 2016-02 / 2017-12
- Ford B-Max (JK8)
- 1.0 EcoBoost 12V 100, Lieferwagen, Benzin, 999cc, 74kW (101pk), FWD, SFJA; SFJB; SFJC; SFJD, 2012-10 / 2017-12
- 1.0 EcoBoost 12V 125, Lieferwagen, Benzin, 998cc, 92kW (125pk), FWD, M1JE, 2012-10 / 2017-12
- Ford C-Max (DXA)
- 1.0 Ti-VCT EcoBoost 12V 100, MPV, Benzin, 998cc, 74kW (101pk), FWD, M2DA, 2012-10 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 100, MPV, Benzin, 998cc, 74kW (101pk), FWD, M2DA; M2DC, 2012-10 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 100, MPV, Benzin, 998cc, 74kW (101pk), FWD, M2DC, 2015-05 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 100, MPV, Benzin, 999cc, 74kW (101pk), FWD, B3DA, 2018-07 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 125, MPV, Benzin, 998cc, 92kW (125pk), FWD, M1DA, 2012-10 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 125, MPV, Benzin, 998cc, 92kW (125pk), FWD, M1DA; M1DD, 2012-10 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 125, MPV, Benzin, 998cc, 92kW (125pk), FWD, M1DD, 2015-05 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 125, MPV, Benzin, 999cc, 92kW (125pk), FWD, B7DA, 2018-07 / 2019-06
- Ford C-Max (DXA)
- 1.0 Ti-VCT EcoBoost 12V 100, Lieferwagen, Benzin, 998cc, 74kW (101pk), FWD, M2DA; SFDA, 2012-10 / 2019-06
- 1.0 Ti-VCT EcoBoost 12V 125, Lieferwagen, Benzin, 998cc, 92kW (125pk), FWD, M1DA, 2012-10 / 2019-06
- Ford Fiesta 6 (JA8)
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJA; SFJB; SFJC; SFJD, 2013-01 / 2017-04
- Ford Fiesta 7
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJE, 2017-05
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJF, 2017-05
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJH; SFJK; SFJJ; SFJE; SFJN; SFJP; SFJF; Y7JA, 2017-05
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJK, 2017-05
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJN, 2018-01
- 1.0 EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFJP, 2018-01
- 1.0 EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1JL, 2017-05
- 1.0 EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1JM, 2017-05
- 1.0 EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1JM; M1JL; M1JP, 2017-05
- 1.0 EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1JP, 2017-05
- 1.0 EcoBoost 12V 140, Fließheck, Benzin, 998cc, 103kW (140pk), FWD, YYJE, 2017-06
- 1.0 EcoBoost 12V 140, Fließheck, Benzin, 998cc, 103kW (140pk), FWD, YYJE; YYJG, 2017-06
- 1.0 EcoBoost 12V 140, Fließheck, Benzin, 998cc, 103kW (140pk), FWD, YYJG, 2018-07
- Ford Focus 3
- 1.0 Ti-VCT EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, M2DA, 2012-02 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, M2DA; M2DB; M2DC; SFDA; SFDB, 2012-02 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, M2DB, 2014-10 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, M2DC, 2014-10 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFDA, 2012-02 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 100, Fließheck, Benzin, 998cc, 74kW (101pk), FWD, SFDB, 2014-10 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1DA, 2012-02 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1DA; M1DD; M1DC, 2012-02 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1DC, 2014-05 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1DD, 2014-05 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1DF, 2015-08 / 2017-12
- 1.0 Ti-VCT EcoBoost 12V 125, Fließheck, Benzin, 998cc, 92kW, M1DA, 2012-02 / 2018-05
- 1.0 Ti-VCT EcoBoost 12V 140, Fließheck, Benzin, 998cc, 103kW (140pk), FWD, M1DH, 2017-10 / 2020-02
- Ford Focus 3 Wagon
- 1.0 Ti-VCT EcoBoost 12V 100, Kombi/o, Benzin, 998cc, 74kW (101pk), FWD, M2DA, 2012-02 / 2018-05
- 1.0 Ti-VCT EcoBoost 12V 125, Kombi/o, Benzin, 998cc, 92kW (125pk), FWD, M1DA, 2012-02 / 2018-05
Donor Fahrzeug
Ford Focus 3 1.0 Ti-VCT EcoBoost 12V 125Fließheck, Benzin, 998cc, 92kW (125pk), FWD, M1DA; M1DD; M1DC, 2012-02 / 2017-12Init
{ "Data": { "SessionId": 4, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/" ], "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": null, "CountryId": 0, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
All sessions
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "2026-08-20T21:48:15.47751+02:00", "UrlRawCurrent": "/autoersatzteilvorrat/lager/oe-nummer/813/ersatzteil/lenkgetriebe-servo/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/lager/oe-nummer/813/ersatzteil/lenkgetriebe-servo/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/lager/oe-nummer/813/ersatzteil/lenkgetriebe-servo/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; IF OBJECT_ID('tempdb..#TD') IS NOT NULL DROP TABLE #TD; CREATE TABLE #TD ([DebtorId] INT PRIMARY KEY NOT NULL); INSERT INTO #TD ([DebtorId]) SELECT DISTINCT [DebiteurId] FROM dbo.[Debiteuren] WHERE [OOL] = 1 AND [OOLGeenVoorraad] = 0 AND [DebiteurId] NOT IN (101190); IF OBJECT_ID('tempdb..#RM') IS NOT NULL DROP TABLE #RM; CREATE TABLE #RM ([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, [Match] INT, [XChange] BIT, [xPF] DECIMAL(9, 2), [xPE] DECIMAL(9, 2), [xPI] DECIMAL(9, 2), [RowId] INT PRIMARY KEY CLUSTERED ([RecordId] ASC)) INSERT INTO #RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [Match], [XChange], [xPF], [xPE], [xPI], [RowId]) SELECT [R].[RecordId], [R].[xPR], [R].[xPS], [R].[xPD], [R].[xTP], [R].[xTT], [R].[xShopState], [R].[xShippingState], [R].[Match], [R].[XChange], [R].[xPF], [R].[xPE], [R].[xPI], ROW_NUMBER() OVER (ORDER BY [SortId] DESC, + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [PartRank] ASC, RIGHT([RecordId], 2)%(DATEPART(WEEKDAY, GETDATE()) + 3) ASC, [R].[RecordId] ASC) AS [RowId] FROM (SELECT [R].[RecordId], [R].[xPR], [R].[xPS], [R].[xPD], [R].[xTP], [R].[xTT], [R].[xShopState], [R].[xShippingState], [R].[Match], [R].[XChange], [R].[xPF], [R].[xPE], [R].[xPI], [R].[SortId], 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 [PartRank] FROM (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], 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 [14] 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 ISNULL([ss].[StateId], 6) END AS [xShopState], xShippingState AS [xShippingState], [R].[SortId], [R].[DebiteurId], [R].[Bouwjaar] AS [12], NULL AS [Match], CASE WHEN [RM].[xPM] = 4 THEN 1 END AS [XChange] FROM (SELECT [RM].[RecordId], MAX([RM].[xPM]) AS [xPM] FROM (SELECT [R].[RecordId], 10 AS [xPM] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE [R].[DeelId] IN ('7300B') AND [R].[RecordId] IN (SELECT [OT].[RecordId] FROM dbo.[OOLPartnumbers] [OT] WITH (NOLOCK) WHERE [OT].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodePartnumber] [CT] WHERE ([CT].[Code] LIKE '813%' OR [CT].[CodeReversed] LIKE '318%'))) AND [R].[DebiteurId] IN (SELECT [DT].[DebtorId] FROM #TD [DT]) UNION ALL SELECT [R].[RecordId], 4 AS [xPM] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE [R].[DebiteurId] IN (SELECT [DT].[DebtorId] FROM #TD [DT]) AND [R].[DeelId] = '7300B' AND ([R].[RecordId] IN (SELECT [OX].[RecordId] FROM dbo.[OOLXchg] [OX] WITH (NOLOCK) WHERE [OX].[CollectionId] IN (SELECT [DX].[CollectionId] FROM dbo.[DebtorXchgPartnumber] [DX] WHERE [DX].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodePartnumber] [CT] WHERE ([CT].[Code] LIKE '813%' OR [CT].[CodeReversed] LIKE '318%')))))) [RM] GROUP BY [RM].[RecordId]) [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 dbo.fnGetOOLShippingStateExtendedTVF([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 276, NULL) [SHS] OUTER APPLY dbo.[fn_OOL_HasPriceInline]([R].[RecordId]) [hp] OUTER APPLY dbo.[fnGetOOLShopStateInline2]([R].[RecordId], [R].[DebiteurId], [R].[Aantal], [R].[QuantityInfinite], [R].[GreenCasionExpiresAt], [R].[Shop], [D].[ShopEnabled], ISNULL([hp].[HasPrice], 0), 1, NULL, NULL, 4, xShippingState) [ss]) [R]) [R]) [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], [XChange] 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, 219, 248)) [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 (4, 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 (4, 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] = 4 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 4 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] = 4), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 4), '')) END AS [AldocDescription] FROM (SELECT [R].* 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] = 4 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], TRY_CAST([18] AS INT) AS [18], CASE WHEN [131] = 'E' THEN 'Elektrisch' WHEN [131] = 'H' THEN 'Hydraulisch' WHEN [131] = 'M' THEN 'Mechanisch' WHEN ISNULL([131], '') = '' THEN NULL ELSE [131] END AS [131], CASE WHEN [132] = 'J' THEN 'Ja' WHEN [132] = 'N' THEN 'Nein' WHEN ISNULL([132], '') = '' THEN NULL ELSE [132] END AS [132], (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], CASE WHEN [XChange] = 1 THEN ISNULL([R].[Artikelnummers] + '|', '') + ISNULL((SELECT TOP 1 [CT].[Code] FROM dbo.[OOLXchg] [X] LEFT JOIN dbo.[DebtorXchgPartnumber] [XP] ON [XP].[CollectionId] = [X].[CollectionId] LEFT JOIN dbo.[CodePartnumber] [CT] ON [CT].[Id] = [XP].[CodeId] WHERE [X].[RecordId] = [R].[RecordId] AND ([CT].[Code] LIKE '813%' OR [CT].[CodeReversed] LIKE '318%')), '813') + '^0' ELSE [R].[Artikelnummers] END 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], [XChange], [R].[SModelId], [R].[ModelId], [R].[PrijsSoort], [R].[PriceShop], [R].[RowId] FROM (SELECT * FROM (SELECT [R].*, [OV].[VeldId], [OV].[Waarde] FROM (SELECT [RM].[RowId], [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].[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], [XChange] FROM #RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) ON [R].[RecordId] = [RM].[RecordId] WHERE [RM].[RowId] BETWEEN 1 AND 10) 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, 131, 132, 241, 26, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [131], [132], [241], [26], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 4 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 4 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], [XChange], [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,131,132,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] UNION SELECT 1, [ModelId], NULL AS [ValueMIN], NULL 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]; SELECT [R].[DeelId], [R].[SoortId], COUNT(*) AS [Aantal] FROM (SELECT [R].[DeelId], [R].[SoortId], [R].[RecordId], [R].[DebiteurId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK FORCESEEK) WHERE [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, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] IN ('7300A') AND [R].[RecordId] IN (SELECT [OT].[RecordId] FROM dbo.[OOLPartnumbers] [OT] WITH (NOLOCK) WHERE [OT].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodePartnumber] [CT] WHERE ([CT].[Code] LIKE '813%' OR [CT].[CodeReversed] LIKE '318%')))) [R] GROUP BY [R].[DeelId], [R].[SoortId] IF OBJECT_ID('tempdb..#RM') IS NOT NULL DROP TABLE #RM; IF OBJECT_ID('tempdb..#TD') IS NOT NULL DROP TABLE #TD;" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 14, "SizeMax": 150, "SetMax": false, "GetIndexMax": 2, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "23232088": 1, "21576681": 2, "19722990": 3, "21128727": 4, "14412084": 5, "19285494": 6, "21216786": 7, "23929494": 8, "21396163": 9, "22556811": 10 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Deutschland", "CountryId": 276, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 2, "Match": null, "Timestamp": "2026-08-20T21:48:19.3369047+02:00", "UrlRawCurrent": "/autoersatzteilvorrat/teil/motorcode/64/ersatzteil/motor/ersatzteilid/12237991/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/teil/motorcode/64/ersatzteil/motor/ersatzteilid/12237991/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/teil/motorcode/64/ersatzteil/motor/ersatzteilid/12237991/" ], "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": 3, "Match": null, "Timestamp": "2026-08-20T21:48:20.5515659+02:00", "UrlRawCurrent": "/autoersatzteilvorrat/teil/motorcode/2549/ersatzteil/abdeckblech-motor/ersatzteilid/21511359/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/teil/motorcode/2549/ersatzteil/abdeckblech-motor/ersatzteilid/21511359/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/teil/motorcode/2549/ersatzteil/abdeckblech-motor/ersatzteilid/21511359/" ], "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 } }
Load
{ "Data": { "SessionId": 4, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/" ], "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 } }
LoadAlternatives
{ "Data": { "SessionId": 4, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/" ], "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 } }
Complete
{ "Data": { "SessionId": 4, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteCurrent": "/url_voorraad/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/autoersatzteilvorrat/teil/motorcode/m2dc/ersatzteil/motor/ersatzteilid/23532026/" ], "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 } }