PreLoad
{ "Data": { "SessionId": 62, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/suzuki/modelo/swift/pieza/ventanilla-detras/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/suzuki/modelo/swift/pieza/ventanilla-detras/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/suzuki/modelo/swift/pieza/ventanilla-detras/" ], "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": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
All sessions
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "2026-08-14T20:41:10.0463603+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/jrq/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/jrq/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/jrq/" ], "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-14T20:41:13.3750447+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sms/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sms/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sms/" ], "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-14T20:41:14.9689079+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/168814b/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/168814b/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/168814b/" ], "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": 4, "Match": null, "Timestamp": "2026-08-14T20:41:16.3750336+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ds/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ds/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ds/" ], "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": 5, "Match": null, "Timestamp": "2026-08-14T20:41:17.2812841+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dp0/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dp0/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dp0/" ], "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": 6, "Match": null, "Timestamp": "2026-08-14T20:41:19.0001428+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/206s4/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/206s4/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/206s4/" ], "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": 7, "Match": null, "Timestamp": "2026-08-14T20:41:19.8125993+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fad/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fad/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fad/" ], "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": 8, "Match": null, "Timestamp": "2026-08-14T20:41:20.4375899+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9k846/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9k846/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9k846/" ], "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": 9, "Match": null, "Timestamp": "2026-08-14T20:41:21.0469853+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/selespeed/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/selespeed/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/selespeed/" ], "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": 10, "Match": null, "Timestamp": "2026-08-14T20:41:22.1719972+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/tl4126/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/tl4126/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/tl4126/" ], "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": 11, "Match": null, "Timestamp": "2026-08-14T20:41:22.8595077+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/d6/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/d6/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/d6/" ], "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": 12, "Match": null, "Timestamp": "2026-08-14T20:41:23.7401438+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ramrtn/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ramrtn/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ramrtn/" ], "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": 13, "Match": null, "Timestamp": "2026-08-14T20:41:24.3494925+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dhe/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dhe/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dhe/" ], "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": 14, "Match": null, "Timestamp": "2026-08-14T20:41:28.0682709+02:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-pdc/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-pdc/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-pdc/" ], "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, 6, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '00A03A' OR ([R].[AldocModelCode] IN (65382, 58613, 45237, 2191, 2193) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (10523, 126876, 46262, 112295, 126875, 145089, 151160, 145088, 149409)))) AND [R].[DeelId] IN ('4353X') 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], 724, 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, 105, 232)) [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 (6, 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 (6, 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] = 6 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 6 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] = 6), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 6), '')) 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] = 6 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], [V19].[NaamLang] AS [19], CASE WHEN [22] = '2' THEN '2Puertas' WHEN [22] = '4' THEN '4Puertas' WHEN ISNULL([22], '') = '' THEN NULL ELSE [22] END AS [22], [V23].[NaamLang] AS [23], (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].[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, 22, 23, 241, 26, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [19], [22], [23], [241], [26], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 6 LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 6 LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 6 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 6 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,22,23,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": 92, "SizeMax": 150, "SetMax": false, "GetIndexMax": 10, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "23241390": 1, "17110930": 1, "23664664": 1, "23541157": 1, "17989548": 1, "14175514": 1, "25358721": 1, "19577797": 1, "16315646": 2, "24206110": 2 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 15, "Match": null, "Timestamp": "2026-08-14T20:41:28.7822717+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jjs/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jjs/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jjs/" ], "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": 16, "Match": null, "Timestamp": "2026-08-14T20:41:29.2041532+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ram/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ram/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ram/" ], "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": 17, "Match": null, "Timestamp": "2026-08-14T20:41:29.7666643+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/muj/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/muj/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/muj/" ], "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": 18, "Match": null, "Timestamp": "2026-08-14T20:41:30.876009+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/c4/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/c4/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/c4/" ], "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": 19, "Match": null, "Timestamp": "2026-08-14T20:41:31.7823357+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/a6mf2/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/a6mf2/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/a6mf2/" ], "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": 20, "Match": null, "Timestamp": "2026-08-14T20:41:32.094779+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ec65/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ec65/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ec65/" ], "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": 21, "Match": null, "Timestamp": "2026-08-14T20:41:32.516626+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/55266963/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/55266963/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/55266963/" ], "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": 22, "Match": null, "Timestamp": "2026-08-14T20:41:33.2278225+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/m47d20204d4/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/m47d20204d4/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/m47d20204d4/" ], "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": 23, "Match": null, "Timestamp": "2026-08-14T20:41:34.0091349+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dewb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dewb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dewb/" ], "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": 24, "Match": null, "Timestamp": "2026-08-14T20:41:34.5091279+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/selesp/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/selesp/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/selesp/" ], "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": 25, "Match": null, "Timestamp": "2026-08-14T20:41:37.759143+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9k282/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9k282/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9k282/" ], "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": 26, "Match": null, "Timestamp": "2026-08-14T20:41:38.3076411+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/knd/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/knd/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/knd/" ], "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": 27, "Match": null, "Timestamp": "2026-08-14T20:41:39.1425733+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/532651/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/532651/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/532651/" ], "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": 28, "Match": null, "Timestamp": "2026-08-14T20:41:39.8456285+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rcx/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rcx/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rcx/" ], "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": 29, "Match": null, "Timestamp": "2026-08-14T20:41:40.5956235+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aar/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aar/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aar/" ], "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": 30, "Match": null, "Timestamp": "2026-08-14T20:41:41.1737254+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/hra2628458a/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/hra2628458a/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/hra2628458a/" ], "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": 31, "Match": null, "Timestamp": "2026-08-14T20:41:41.8299579+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/r9m402/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/r9m402/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/r9m402/" ], "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": 32, "Match": null, "Timestamp": "2026-08-14T20:41:44.4494544+02:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/mini/modelo/one/pieza/llave/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/mini/modelo/one/pieza/llave/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/mini/modelo/one/pieza/llave/" ], "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, 6, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '72X03X' OR ([R].[AldocModelCode] IN (55928, 54920, 52735, 58140, 33492, 34896, 34031, 47830, 51201, 49513, 42057, 37784, 46169, 44314) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (117578, 142438, 154734, 117579, 117580, 41135, 118110, 128711, 124267, 119009, 124270, 35647, 119014, 40811, 40812, 129127, 142162, 124237, 38159, 115115, 38160, 115116, 38161, 115117, 35631, 118988, 118987, 40817, 117584, 124249, 40816, 117583, 40814, 117581, 124251, 124252, 124246, 123438, 121179, 128704, 128710, 136257, 142161, 106490, 142437, 106499, 63490, 63497, 106497, 63480, 106480, 63499, 118149, 62469, 111894, 65012, 108012, 124257, 128713, 124256, 65011, 108011, 129118, 129119, 123350, 123356, 123815, 123357, 125346, 125347, 123364, 123362, 123358, 123370, 123369, 123816, 123820, 123819, 123821, 123817, 125348, 127861, 127864, 136258, 140885, 140884, 140890, 140889, 15889, 15890, 16600, 17171, 25139, 18307, 19304, 28363, 17793, 27975, 22485, 19859, 19862, 22486, 59416, 32009, 31111, 33052, 33051, 33053, 33054, 33056, 7071, 34920, 3040, 9894, 9895, 6449, 5373, 11881, 57564, 133127, 17816, 17817, 17818, 19303, 21092, 15285, 15286, 15287, 3775, 3952, 17492, 15288, 17619, 100572, 142433, 60572, 60573, 100573, 60571, 100571, 121964, 60898, 100898, 60899, 100899, 63508, 106508, 123158, 63513, 106513, 128712, 61688, 111113, 129121, 129125, 136727, 138184, 137845, 58868, 58870, 58873, 58882, 58872, 58881, 58883, 58887, 124370, 133143, 60127, 100127, 124371, 115267, 53236, 64864, 107864, 42618, 108618, 63285, 106285, 63284, 106284, 64373, 107373, 133141, 31140, 31141, 124760, 129030, 32010, 16125, 33077, 33078, 33079, 3783, 34917, 9898, 9915, 128490, 23445, 23446, 23447, 23444, 32012, 34994, 53158, 33074, 33075, 33076, 34918, 34919, 9359, 9897, 15059, 9896, 17256, 11693, 11698, 11705, 11701, 7450, 17420, 17453, 132076, 17434, 34921, 34923, 34925, 34924, 34922, 34927, 34926, 6074, 9917, 124730, 6443, 9918, 9916, 9926, 62656, 105656, 16133, 133134, 7423, 107449, 56172, 42624, 108624, 42611, 108611, 63282, 106282, 63283, 106283)))) AND [R].[DeelId] IN ('7429X') 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], 724, 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 (6, 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 (6, 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] = 6 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 6 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] = 6), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 6), '')) 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], [25], CASE WHEN [113] = '-' THEN 'N/A' WHEN [113] = 'N' THEN 'No' WHEN [113] = 'J' THEN 'Sí' WHEN ISNULL([113], '') = '' THEN NULL ELSE [113] END AS [113], [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].[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, 25, 113)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [25], [113])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 6 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 6 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,25,113) 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)) [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": 21, "SizeMax": 150, "SetMax": false, "GetIndexMax": 3, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "22494477": 1, "16716012": 1, "20592496": 1, "21228683": 2, "22757824": 2, "21228684": 3, "20204676": 4, "25680009": 5, "19177011": 6, "22911892": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 33, "Match": null, "Timestamp": "2026-08-14T20:41:44.9181921+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/r9m415/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/r9m415/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/r9m415/" ], "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": 34, "Match": null, "Timestamp": "2026-08-14T20:41:45.6838038+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/jh3149/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/jh3149/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/jh3149/" ], "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": 35, "Match": null, "Timestamp": "2026-08-14T20:41:46.511949+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/hr13ddt/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/hr13ddt/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/hr13ddt/" ], "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": 36, "Match": null, "Timestamp": "2026-08-14T20:41:46.9806879+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/032363w/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/032363w/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/032363w/" ], "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": 37, "Match": null, "Timestamp": "2026-08-14T20:41:47.4651034+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/340318a/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/340318a/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/340318a/" ], "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": 38, "Match": null, "Timestamp": "2026-08-14T20:41:47.9963094+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/daza/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/daza/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/daza/" ], "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": 39, "Match": null, "Timestamp": "2026-08-14T20:41:48.627375+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/6f/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/6f/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/6f/" ], "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": 40, "Match": null, "Timestamp": "2026-08-14T20:41:49.0805464+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/20ea06/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/20ea06/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/20ea06/" ], "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": 41, "Match": null, "Timestamp": "2026-08-14T20:41:49.5650519+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/m47n20/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/m47n20/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/m47n20/" ], "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": 42, "Match": null, "Timestamp": "2026-08-14T20:41:50.0649873+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cuacuaa/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cuacuaa/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cuacuaa/" ], "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": 43, "Match": null, "Timestamp": "2026-08-14T20:41:50.6117926+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cvfc/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cvfc/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cvfc/" ], "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": 44, "Match": null, "Timestamp": "2026-08-14T20:41:51.3149159+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/xvjc/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/xvjc/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/xvjc/" ], "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": 45, "Match": null, "Timestamp": "2026-08-14T20:41:55.9200642+02:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/opel/modelo/signum/pieza/interruptor-combinado-de-ventanillas/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/opel/modelo/signum/pieza/interruptor-combinado-de-ventanillas/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/opel/modelo/signum/pieza/interruptor-combinado-de-ventanillas/" ], "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, 6, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '05A57X' OR ([R].[AldocModelCode] IN (34005) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (17208, 17068, 17212, 17207, 17209, 17211, 17210, 17946, 17934, 19111, 19986, 20108, 19092, 19361, 59267)))) AND [R].[DeelId] IN ('4402A') 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], 724, 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, 232)) [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 (6, 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 (6, 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] = 6 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 6 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] = 6), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 6), '')) 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] = 6 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], [V19].[NaamLang] AS [19], CASE WHEN [22] = '2' THEN '2Puertas' WHEN [22] = '4' THEN '4Puertas' WHEN ISNULL([22], '') = '' THEN NULL ELSE [22] END AS [22], [V23].[NaamLang] AS [23], (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].[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, 22, 23, 241, 26, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [19], [22], [23], [241], [26], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 6 LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 6 LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 6 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 6 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,22,23,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]; 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, 111111, 123456, 123457, 123462) AND ([R].[ModelId] = '05A57X' OR ([R].[AldocModelCode] IN (34005) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (17208, 17068, 17212, 17207, 17209, 17211, 17210, 17946, 17934, 19111, 19986, 20108, 19092, 19361, 59267)))) AND [R].[DeelId] IN ('4382X', '4401A')) [R] GROUP BY [R].[DeelId], [R].[SoortId]" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 13, "SizeMax": 150, "SetMax": false, "GetIndexMax": 2, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "19991294": 1, "23957236": 1, "23173259": 1, "16014222": 1, "19354916": 1, "12004467": 1, "12004403": 2, "23251047": 1, "3682504": 1, "3138073": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 46, "Match": null, "Timestamp": "2026-08-14T20:41:56.6701048+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/256s4/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/256s4/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/256s4/" ], "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": 47, "Match": null, "Timestamp": "2026-08-14T20:41:58.8002393+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/m57306d1/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/m57306d1/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/m57306d1/" ], "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": 48, "Match": null, "Timestamp": "2026-08-14T20:41:59.33149+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/41b/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/41b/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/41b/" ], "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": 49, "Match": null, "Timestamp": "2026-08-14T20:42:00.222124+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dnp/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dnp/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dnp/" ], "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": 50, "Match": null, "Timestamp": "2026-08-14T20:42:00.6439824+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9k837/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9k837/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9k837/" ], "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": 51, "Match": null, "Timestamp": "2026-08-14T20:42:01.0971118+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/108674b/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/108674b/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/108674b/" ], "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": 52, "Match": null, "Timestamp": "2026-08-14T20:42:01.4721192+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mlm/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mlm/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mlm/" ], "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": 53, "Match": null, "Timestamp": "2026-08-14T20:42:02.0346035+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/3wx10/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/3wx10/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/3wx10/" ], "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": 54, "Match": null, "Timestamp": "2026-08-14T20:42:02.628375+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/co16217/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/co16217/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/co16217/" ], "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": 55, "Match": null, "Timestamp": "2026-08-14T20:42:03.0346083+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9k638/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9k638/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9k638/" ], "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": 56, "Match": null, "Timestamp": "2026-08-14T20:42:04.016056+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ada/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ada/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ada/" ], "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": 57, "Match": null, "Timestamp": "2026-08-14T20:42:05.1254234+02:00", "UrlRawCurrent": "/stock-de-piezas/almacen/codigo-de-motor/651921/pieza/motor/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/codigo-de-motor/651921/pieza/motor/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/codigo-de-motor/651921/pieza/motor/" ], "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, [Match] INT, [XChange] BIT, [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], [Match], [XChange], [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, 6, xShippingState) END AS [xShopState], xShippingState AS [xShippingState], 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 '651921%')) 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) UNION SELECT [R].[RecordId], 4 AS [xPM] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) 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, 111111, 123456, 123457, 123462) 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 '651921%'))))) [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 (SELECT dbo.fnGetOOLShippingStateExtended([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 724, 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], [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], 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 (6, 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 (6, 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] = 6 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 6 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] = 6), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 6), '')) 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] = 6 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 '651921%'), '651921') 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 'Eléctrico' 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] 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], [XChange] 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, 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] = 6 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 6 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]" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 67, "SizeMax": 150, "SetMax": false, "GetIndexMax": 7, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "23883570": 1, "22278193": 1, "15929564": 1, "25319174": 1, "24872227": 1, "15929456": 2, "21673896": 2, "24872309": 2, "15930122": 3, "24872509": 3 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 58, "Match": null, "Timestamp": "2026-08-14T20:42:06.0160896+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/3wx1b/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/3wx1b/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/3wx1b/" ], "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": 59, "Match": null, "Timestamp": "2026-08-14T20:42:06.6878989+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/265929b/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/265929b/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/265929b/" ], "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": 60, "Match": null, "Timestamp": "2026-08-14T20:42:07.4066748+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pm/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pm/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pm/" ], "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": 61, "Match": null, "Timestamp": "2026-08-14T20:42:08.2932975+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9k609/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9k609/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9k609/" ], "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": 62, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/suzuki/modelo/swift/pieza/ventanilla-detras/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/suzuki/modelo/swift/pieza/ventanilla-detras/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/suzuki/modelo/swift/pieza/ventanilla-detras/" ], "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, 6, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = 'R0A01A' OR ([R].[AldocModelCode] IN (59091, 45525, 34170, 33842, 31530, 32634, 11002, 15508) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (126919, 126921, 126922, 126920, 126924, 126923, 129649, 129650, 129651, 129652, 129653, 129654, 139679, 141021, 141020, 26, 56, 57, 9113, 9087, 11746, 4143, 19094, 19093, 19203, 27332, 23443, 28149, 27333, 19205, 124116, 133866, 4456, 4431, 4440, 4439, 4436, 4433, 4437, 4452, 4453, 4459, 4460, 4451, 27130, 4450, 4457, 4455, 27129, 4462, 4465, 4454, 4458, 4466, 4467, 157117, 157116, 802412, 802410, 800838, 803113)))) AND [R].[DeelId] IN ('3751A') 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], 724, 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, 232)) [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 (6, 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 (6, 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] = 6 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 6 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] = 6), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 6), '')) 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], CASE WHEN [22] = '2' THEN '2Puertas' WHEN [22] = '4' THEN '4Puertas' WHEN ISNULL([22], '') = '' THEN NULL ELSE [22] END AS [22], [V23].[NaamLang] AS [23], CASE WHEN [35] IS NOT NULL THEN ISNULL(STUFF((SELECT '^' + [KT].[Naam] FROM dbo.[OOLKleuren] [RK] LEFT JOIN [Basis].dbo.[KleurenTranslated] [KT] ON [KT].[ColorId] = [RK].[ColorId] AND [KT].[LanguageId] = 6 WHERE [RK].[RecordId] = [R].[RecordId] AND [RK].[VeldID] = 35 ORDER BY [RK].[OrderId] FOR XML PATH('')),1,1,'') + '|', '') + STUFF((SELECT '|' + [XOV].[Waarde] FROM dbo.[OOLVelden] [XOV]\t\t\t\t\t\t WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 35 ORDER BY [XOV].[OrderId] FOR XML PATH('')), 1, 1, '') END AS [35], [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].[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, 22, 23, 35, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [22], [23], [35], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 6 LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 6 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 6 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,22,23,35,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)) [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": 7, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "22713621": 1, "24629458": 1, "18888011": 1, "16299106": 1, "10733510": 1, "24945429": 1, "4578250": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }