Subframe met motorcode EB0F Gebruikt
Aanbieder Maresia Parts
- RecordId
- 10163164
- WebId
- -
- AutoRecordId
- 6173961
- Prijs Origineel
- 131,25
- Prijs Soort
- None
- Prijs BTW
- Margin
- Prijs Tonen
- True
- Internet (AM)
- Ja (Nee)
- Shop
- Ja
- Aantal (Infinite)
- 1 (Nee)
- OrderStatus
- Ok ( Record is bestelbaar )
- Verkocht
- -
- InternetID
- 189385
- SKU
- P10163164
- Bouwjaar
- 2013
- Artikelnummer
- 98042081803502JV
- Specificatiecode
- -
- Classificatiecode
- A2
- maximaal 35.000 kilometer is de norm
- Motortype
- Benzine
- Motorcode
- EB0FZMZZMZ16085115801608511580
- Cilinderinhoud
- 1.000 cc
- Versnellingsbak
- 5 Bak
- Versnellingsbak type
- Handgeschakeld
- Plaats
- Voor
- Uitvoering
- Hatchback
- Tellerstand
- 68.745 km
- Aandrijving
- Voorwiel
- Bijzonderheden
- IN GOEDE STAAT
- Voertuignummer
- V692
- Chassisnummer (VIN)
- VF3CCZMZ0CT1****0
Dit onderdeel is mogelijk toepasbaar op de volgende types.
- Citroen C2 (JM)
- 1.1, Hatchback, 2Dr, Benzine, 1.124cc, 44kW (60pk), FWD, TU1JP; HFX; TU1A, 2003-09 / 2012-09
- 1.4, Hatchback, 2Dr, Benzine, 1.360cc, 54kW (73pk), FWD, TU3JP; KFV, 2003-09 / 2009-12
- 1.4 HDI, Hatchback, 2Dr, Diesel, 1.398cc, 50kW (68pk), FWD, DV4TD; 8HX, 2003-09 / 2009-09
- Citroen C3 (FC/FL/FT)
- 1.6 16V, Hatchback, 4Dr, Benzine, 1.587cc, 80kW (109pk), FWD, TU5JP4; NFU, 2002-02 / 2010-08
- 1.4, Hatchback, 4Dr, Benzine, 1.360cc, 54kW (73pk), FWD, TU3JP; KFV, 2002-02 / 2010-11
- Citroen C3 (SC)
- 1.4, Hatchback, 4Dr, Benzine, 1.360cc, 54kW (73pk), FWD, TU3AE5; KFT, 2009-11 / 2016-09
- 1.4 16V VTi, Hatchback, 4Dr, Benzine, 1.397cc, 70kW (95pk), FWD, EP3C; 8FP, 2009-11 / 2016-09
- 1.6 16V VTi 120, Hatchback, 4Dr, Benzine, 1.598cc, 88kW (120pk), FWD, EP6C; 5FS, 2009-11 / 2016-09
- 1.6 HDi 92, Hatchback, 4Dr, Diesel, 1.560cc, 68kW (92pk), FWD, DV6DTED; 9HP, 2009-11 / 2016-09
- 1.0 Vti 68 12V, Hatchback, 4Dr, Benzine, 999cc, 50kW (68pk), FWD, EB0; ZMZ, 2012-08 / 2016-09
- 1.2 VTi 82 12V, Hatchback, 4Dr, Benzine, 1.199cc, 60kW (82pk), FWD, EB2F; HMZ, 2012-06 / 2016-09
- Citroen C3 (SX/SW)
- 1.2 Vti 12V PureTech, Hatchback, Benzine, 1.199cc, 60kW (82pk), FWD, EB2F; HMZ, 2016-07
- 1.2 12V e-THP PureTech 110, Hatchback, Benzine, 1.199cc, 81kW (110pk), FWD, EB2DTM; HNV, 2017-03
- 1.6 Blue HDi 75 16V, Hatchback, Diesel, 1.560cc, 55kW (75pk), FWD, DV6FE; BHW, 2016-07 / 2018-05
- Citroen C3 Pluriel (HB)
- 1.4, Cabrio, Benzine, 1.360cc, 54kW (73pk), FWD, TU3JP; KFV, 2003-05 / 2010-12
- Citroen C4 Cactus (0B/0P)
- 1.2 PureTech 82 12V, Hatchback, 4Dr, Benzine, 1.199cc, 60kW (82pk), FWD, EB2F; HMZ, 2014-09
- 1.6 Blue Hdi 100, Hatchback, 4Dr, Diesel, 1.560cc, 73kW (99pk), FWD, DV6FD; BHY, 2014-09 / 2018-06
- Citroen DS 3 (SA)
- 1.2 12V PureTech 130, Hatchback, Benzine, 1.199cc, 96kW, EB2DTS; HNY, 2015-09
- Citroen DS3 (SA)
- 1.4 16V VTi, Hatchback, Benzine, 1.397cc, 70kW (95pk), FWD, EP3C; 8FP, 2010-04 / 2015-07
- 1.6 16V VTS THP 155, Hatchback, Benzine, 1.598cc, 115kW (156pk), FWD, EP6CDT; 5FV, 2011-10 / 2015-07
- 1.6 16V VTS THP 155, Hatchback, Benzine, 1.598cc, 115kW (156pk), FWD, EP6CDT; 5FV; EP6DT; 5FR, 2009-11 / 2015-07
- 1.6 e-HDi, Hatchback, Diesel, 1.560cc, 68kW (92pk), FWD, DV6DTED; 9HP, 2009-11 / 2015-07
- 1.2 12V PureTech 82, Hatchback, Benzine, 1.199cc, 60kW (82pk), FWD, EB2F; HMZ, 2013-01 / 2015-03
- 1.6 e-HDi 16V 115, Hatchback, Diesel, 1.560cc, 84kW (114pk), FWD, DV6C; 9HD, 2012-08 / 2015-07
- 1.6 Blue Hdi 100, Hatchback, Diesel, 1.560cc, 73kW (99pk), FWD, DV6FD; BHY, 2014-07 / 2015-07
- Peugeot 1007 (KM)
- 1.4, Hatchback, 2Dr, Benzine, 1.360cc, 54kW (73pk), FWD, TU3JP; KFV; TU3A, 2005-04 / 2011-02
- 1.6 GTI,Gentry 16V, Hatchback, 2Dr, Benzine, 1.587cc, 80kW (109pk), FWD, TU5JP4; NFU, 2005-04 / 2011-02
- 1.4 16V, Hatchback, 2Dr, Benzine, 1.360cc, 66kW (90pk), FWD, ET3J4; KFU, 2005-10 / 2007-08
- Peugeot 2008 (CU)
- 1.2 Vti 12V PureTech 82, MPV, Benzine, 1.199cc, 60kW (82pk), FWD, EB2F; HMZ, 2013-03 / 2018-12
- 1.6 HDiF 16V, MPV, Diesel, 1.560cc, 84kW (114pk), FWD, DV6C; 9HD, 2013-03 / 2019-12
- Peugeot 208 I (CA/CC/CK/CL)
- 1.6 Vti 16V, Hatchback, Benzine, 1.598cc, 88kW (120pk), FWD, EP6C; 5FS, 2012-03 / 2019-12
- 1.6 Vti 16V, Hatchback, Benzine, 1.598cc, 88kW, EP6C; 5FS, 2012-03 / 2019-06
- 1.4 HDi, Hatchback, Diesel, 1.398cc, 50kW (68pk), FWD, DV4C; 8HP, 2012-03 / 2019-12
- 1.4 HDi, Hatchback, Diesel, 1.398cc, 50kW (68pk), FWD, DV4C; 8HR; 8HP, 2012-03 / 2019-12
- 1.6 e-HDi FAP, Hatchback, Diesel, 1.560cc, 68kW (92pk), FWD, DV6DTED; 9HP; DV6DTEDM; 9HJ, 2012-03 / 2019-12
- 1.0 Vti 12V PureTech, Hatchback, Benzine, 999cc, 50kW (68pk), FWD, EB0; ZMZ, 2012-03 / 2019-12
- 1.2 Vti 12V PureTech 82, Hatchback, Benzine, 1.199cc, 60kW (82pk), FWD, EB2F; HMZ, 2012-03 / 2019-12
- 1.2 Vti 12V PureTech, Hatchback, Benzine, 1.199cc, 50kW (68pk), FWD, EB2FB; HMP, 2016-08 / 2019-12
- 1.2 Vti 12V PureTech, Hatchback, Benzine, 1.199cc, 61kW (83pk), FWD, EB2FA; HMR, 2018-03 / 2019-12
- 1.4 16V, Hatchback, Benzine, 1.397cc, 70kW (95pk), FWD, EP3C; 8FP, 2012-03 / 2019-12
- 1.6 Blue HDi 100, Hatchback, Diesel, 1,560cc, 73kW, DV6FD; BHY, 2015-01 / 2019-06
- 1.2 12V e-THP PureTech 110, Hatchback, Benzine, 1.199cc, 81kW (110pk), FWD, EB2DT; HNZ, 2013-01 / 2019-12
Donor voertuig
Gedemonteerd van een Peugeot 208 I (CA/CC/CK/CL) 1.0 Vti 12V PureTechHatchback, Benzine, 999cc, 50kW (68pk), FWD, EB0; ZMZ, 2012-03 / 2019-12, CAZMZ; CCZMZSubframe Citroen C3 (SC), 2009 / 2016 1.0 Vti 68 12V, Hatchback, 4Dr, Benzine, 999cc, 50kW (68pk), FWD, EB0; ZMZ, 2012-08 / 2016-09, SCZMZ (Gebruikt) Subframe Citroen C3 (SC), 2009 / 2016 1.0 Vti 68 12V, Hatchback, 4Dr, Benzine, 999cc, 50kW (68pk), FWD, EB0; ZMZ, 2012-08 / 2016-09, SCZMZ (Gebruikt) Init
{ "Data": { "SessionId": 5, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/" ], "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-21T07:47:43.3815114+02:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/zoeken/onderdeelnummer/3024421/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/zoeken/onderdeelnummer/3024421/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/zoeken/onderdeelnummer/3024421/" ], "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-21T07:47:45.469211+02:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/zoeken/onderdeelnummer/eb3b16c827/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/zoeken/onderdeelnummer/eb3b16c827/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/zoeken/onderdeelnummer/eb3b16c827/" ], "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-21T07:47:48.961154+02:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/magazijn/motorcode/gse20/onderdeel/motor/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/magazijn/motorcode/gse20/onderdeel/motor/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/magazijn/motorcode/gse20/onderdeel/motor/" ], "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 ('7900A') AND [R].[RecordId] IN (SELECT [OT].[RecordId] FROM dbo.[OOLEnginecodes] [OT] WITH (NOLOCK) WHERE [OT].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodeEngine] [CT] WHERE [CT].[Code] LIKE 'GSE20%')) 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] = '7900A' AND ([R].[RecordId] IN (SELECT [OX].[RecordId] FROM dbo.[OOLXchg] [OX] WITH (NOLOCK) WHERE [OX].[CollectionId] IN (SELECT [DX].[CollectionId] FROM dbo.[DebtorXchgEnginecode] [DX] WHERE [DX].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodeEngine] [CT] WHERE [CT].[Code] LIKE 'GSE20%'))))) [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], 528, 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, 1, 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, 27, 244, 230)) [V] ORDER BY [V].[VeldId], [V].[OrderId] FOR XML PATH('')), 1, 1, '') AS [Automate2Velden], [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] = 1 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 1 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] = 1), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 1), '')) 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] = 1 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 [XChange] = 1 THEN ISNULL([R].[Motorcodes] + '|', '') + ISNULL((SELECT TOP 1 [CT].[Code] FROM dbo.[OOLXchg] [X] LEFT JOIN dbo.[DebtorXchgEnginecode] [XP] ON [XP].[CollectionId] = [X].[CollectionId] LEFT JOIN dbo.[CodeEngine] [CT] ON [CT].[Id] = [XP].[CodeId] WHERE [X].[RecordId] = [R].[RecordId] AND [CT].[Code] LIKE 'GSE20%'), 'GSE20') ELSE [R].[Motorcodes] END AS [108], TRY_CAST([18] AS INT) AS [18], (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], TRY_CAST([122] AS INT) AS [122], [25], CASE WHEN [256] = 'Z' THEN 'Elektrisch' WHEN [256] = 'E1' THEN 'Euro 1' WHEN [256] = 'E2' THEN 'Euro 2' WHEN [256] = 'E3' THEN 'Euro 3' WHEN [256] = 'E4' THEN 'Euro 4' WHEN [256] = 'E5' THEN 'Euro 5' WHEN [256] = 'E6' THEN 'Euro 6' WHEN ISNULL([256], '') = '' THEN NULL ELSE [256] END AS [256], [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], [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].[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], [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, 241, 26, 122, 25, 256)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [241], [26], [122], [25], [256])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 1 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 1 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,241,25,256) 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,122)) [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] 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": 2, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "23912832": 1, "24385950": 2 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Nederland", "CountryId": 528, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 4, "Match": null, "Timestamp": "2026-08-21T07:47:51.867412+02:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/magazijn/motorcode/616963/onderdeel/radiateur/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/magazijn/motorcode/616963/onderdeel/radiateur/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/magazijn/motorcode/616963/onderdeel/radiateur/" ], "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 ('7761A') AND [R].[RecordId] IN (SELECT [OT].[RecordId] FROM dbo.[OOLEnginecodes] [OT] WITH (NOLOCK) WHERE [OT].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodeEngine] [CT] WHERE [CT].[Code] LIKE '616963%')) 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] = '7761A' AND ([R].[RecordId] IN (SELECT [OX].[RecordId] FROM dbo.[OOLXchg] [OX] WITH (NOLOCK) WHERE [OX].[CollectionId] IN (SELECT [DX].[CollectionId] FROM dbo.[DebtorXchgEnginecode] [DX] WHERE [DX].[CodeId] IN (SELECT [CT].[Id] FROM dbo.[CodeEngine] [CT] WHERE [CT].[Code] LIKE '616963%'))))) [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], 528, 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, 1, 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, 230, 231, 232)) [V] ORDER BY [V].[VeldId], [V].[OrderId] FOR XML PATH('')), 1, 1, '') AS [Automate2Velden], [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] = 1 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 1 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] = 1), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 1), '')) 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] = 1 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 [XChange] = 1 THEN ISNULL([R].[Motorcodes] + '|', '') + ISNULL((SELECT TOP 1 [CT].[Code] FROM dbo.[OOLXchg] [X] LEFT JOIN dbo.[DebtorXchgEnginecode] [XP] ON [XP].[CollectionId] = [X].[CollectionId] LEFT JOIN dbo.[CodeEngine] [CT] ON [CT].[Id] = [XP].[CodeId] WHERE [X].[RecordId] = [R].[RecordId] AND [CT].[Code] LIKE '616963%'), '616963') ELSE [R].[Motorcodes] END AS [108], TRY_CAST([18] AS INT) AS [18], [V19].[NaamLang] AS [19], [V23].[NaamLang] AS [23], CASE WHEN [123] = 'C' THEN 'Clima' WHEN [123] = 'H' THEN 'Hand bed.' WHEN [123] = 'J' THEN 'Ja' WHEN [123] = 'L' THEN 'Ja(leeg)' WHEN [123] = 'N' THEN 'Nee' WHEN ISNULL([123], '') = '' THEN NULL ELSE [123] END AS [123], (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], [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].[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], [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, 19, 23, 123, 241, 26, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [19], [23], [123], [241], [26], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 1 LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 1 LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 1 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 1 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,19,23,123,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] 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": 1, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "14751850": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Nederland", "CountryId": 528, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
Load
{ "Data": { "SessionId": 5, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/" ], "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": 5, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/" ], "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": 5, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteCurrent": "/url_voorraad/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/auto-onderdelen-voorraad/onderdeel/motorcode/eb0f/onderdeel/subframe/onderdeelid/10163164/" ], "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 } }