Audi RS 3 Sportback (8VA/8VF) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 40,00 Margen
Se puede pedir directamente
Año de construcción12-2019 |Número de artículo3Q0907530ACGarantía 3 mnd
Proveedor Verhoef Cars & Parts
Audi RS 3 Sportback (8YA) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 59,00 Margen
Se puede pedir directamente
Año de construcción01-2022 |Código de clasificaciónA1 |Marca de la piezaCONTINENTAL |Número de artículo5WA907530QParticularidad Functionally tested and in neat condition.
Garantía 12 mnd
Proveedor Automaterialen Ronald Morien B.V.
Audi RS3
Usados Módulo Gateway
€ 50,00 Margen
Se puede pedir directamente
Año de construcción2021 |Número de artículo5WA907530QGarantía 24 mnd
Proveedor Van der Ven Autorecycling B.V.
Audi RS 3 Sportback (8YA) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 70,00 Margen
Se puede pedir directamente
Año de construcción2023 |Código de clasificaciónA2 |Marca de la piezaCONTINENTAL |Número de artículo5WA907530LParticularidad Factura de IVA con posible descuento.
Garantía 12 mnd
Proveedor AutoHam
Audi A3
Usados Módulo Gateway
€ 50,00 Margen
Se puede pedir directamente
Año de construcción2015 |Número de artículo5QE907530DGarantía 24 mnd
Proveedor Van der Ven Autorecycling B.V.
Audi RS 3 Sportback (8VA/8VF) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 80,00 Margen
Año de construcción2020 |Código de clasificaciónA1 |Marca de la piezaORIGINEEL |Número de artículo3Q0907530ACParticularidad IN GOOD CONDITION, 1 PLUG, 19 POLES
Garantía 6 mnd
Proveedor Van Gils Automotive
Audi RS 3 Sportback (8VA/8VF) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 19,99 Margen
Se puede pedir directamente
Año de construcción08-2018 |Código de clasificaciónA1 |Marca de la piezaVW-AG |Número de artículo3Q0907530LParticularidad Gateway module in goede staat. Zie foto's.
Garantía 3 mnd
Proveedor DVZ Carparts
Audi RS 3 Sportback (8VA/8VF) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 29,98 Margen
Se puede pedir directamente
Año de construcción06-2018 |Código de clasificaciónA1 |Marca de la piezaVW-AG |Número de artículo3Q0907530ACParticularidad RS3 Gateway Module in goede staat.
Garantía 3 mnd
Proveedor DVZ Carparts
Audi RS 3 Sportback (8YA) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 69,99 Margen
Se puede pedir directamente
Año de construcción10-2022 |Código de clasificaciónA1 |Marca de la piezaVW-AG |Número de artículo5WA907530LParticularidad gateway module
Garantía 3 mnd
Proveedor DVZ Carparts
Audi RS 3 Sportback (8VA/8VF) 2.5 TFSI 20V Quattro
Usados Módulo Gateway
€ 50,00 Margen
Se puede pedir directamente
Año de construcción2018 |Código de clasificaciónA2 |Marca de la piezaCONTINENTAL |Número de artículo3Q0907338Particularidad zie foto voor de evt bijzonderheden
Garantía 1 mnd
Proveedor Pijffers B.V. Raalte
PreLoad
{ "Data": { "SessionId": 100, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-gateway/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-gateway/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-gateway/" ], "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:43:39.4168706+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jjsfzu/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jjsfzu/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jjsfzu/" ], "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:43:40.5887093+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/m57306d2306d2/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/m57306d2306d2/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/m57306d2306d2/" ], "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:43:41.3230721+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/322219r/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/322219r/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/322219r/" ], "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:43:41.963699+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/msy/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/msy/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/msy/" ], "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:43:42.7293402+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/htq/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/htq/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/htq/" ], "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:43:43.6200607+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rat/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rat/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rat/" ], "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:43:44.2607423+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cayb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cayb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cayb/" ], "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:43:44.8544102+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f17c418/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f17c418/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f17c418/" ], "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:43:47.4481454+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/marca/audi/modelo/rs6/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/marca/audi/modelo/rs6/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/marca/audi/modelo/rs6/" ], "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:43:48.338748+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dp0071/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dp0071/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dp0071/" ], "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:43:48.9018963+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m45/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m45/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m45/" ], "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:43:49.3080957+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/kds/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/kds/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/kds/" ], "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:43:50.2145106+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dkr/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dkr/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dkr/" ], "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:43:50.7768739+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cns/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cns/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cns/" ], "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": 15, "Match": null, "Timestamp": "2026-08-14T20:43:51.1206127+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9kd506511/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9kd506511/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9kd506511/" ], "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:43:51.8081217+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cun/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cun/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cun/" ], "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:43:52.1674699+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/psu/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/psu/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/psu/" ], "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:43:52.6831088+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jpj/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jpj/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jpj/" ], "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:43:53.3097494+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/0bk/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/0bk/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/0bk/" ], "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:43:54.1378424+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/14/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/14/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/14/" ], "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:43:54.6065615+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jhtfvh/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jhtfvh/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jhtfvh/" ], "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:43:55.419116+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/x234eva/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/x234eva/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/x234eva/" ], "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:43:55.7003351+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/nba/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/nba/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/nba/" ], "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:43:56.1378322+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ecr/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ecr/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ecr/" ], "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:43:56.950383+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dkfetd/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dkfetd/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dkfetd/" ], "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:43:57.6222488+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/adr/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/adr/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/adr/" ], "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:43:57.9815467+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fzuhfn/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fzuhfn/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fzuhfn/" ], "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:43:58.356558+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/hql/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/hql/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/hql/" ], "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:43:58.9494172+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/4speed/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/4speed/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/4speed/" ], "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:43:59.6369431+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/tdc/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/tdc/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/tdc/" ], "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:44:00.3712378+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/27/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/27/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/27/" ], "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:44:00.79312+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mgn/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mgn/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mgn/" ], "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": 33, "Match": null, "Timestamp": "2026-08-14T20:44:01.386879+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/etb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/etb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/etb/" ], "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:44:02.230719+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/6c1rdc/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/6c1rdc/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/6c1rdc/" ], "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:44:02.6680981+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/caxa/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/caxa/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/caxa/" ], "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:44:03.6088425+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/k9kd159526/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/k9kd159526/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/k9kd159526/" ], "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:44:04.0775979+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/vmt6/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/vmt6/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/vmt6/" ], "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:44:04.5463374+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/lva/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/lva/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/lva/" ], "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:44:05.1088372+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/abk/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/abk/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/abk/" ], "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:44:05.8588928+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/asb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/asb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/asb/" ], "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:44:06.3276194+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/afk/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/afk/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/afk/" ], "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:44:06.7026165+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/des/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/des/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/des/" ], "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:44:07.1869483+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pf6/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pf6/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pf6/" ], "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:44:07.5775708+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f23ab/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f23ab/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f23ab/" ], "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:44:08.0931955+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/srb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/srb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/srb/" ], "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": 46, "Match": null, "Timestamp": "2026-08-14T20:44:08.5937919+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aj/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aj/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aj/" ], "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:44:09.3563946+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/11/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/11/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/11/" ], "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:44:09.6376923+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rfe/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rfe/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/rfe/" ], "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:44:10.0439232+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cbz/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cbz/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cbz/" ], "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:44:11.4814048+02:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/protector-interno/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/protector-interno/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/protector-interno/" ], "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 ('0745X') 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], 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 [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], CASE WHEN [28] = 'AC' THEN 'Batería' WHEN [28] = 'V' THEN 'Delante' WHEN [28] = 'R' THEN 'Derecha' WHEN [28] = 'RV' THEN 'Derecha delante' WHEN [28] = 'RA' THEN 'Derecha detrás' WHEN [28] = 'RM' THEN 'Derecha medio' WHEN [28] = 'A' THEN 'Detrás' WHEN [28] = 'L' THEN 'Izquierda' WHEN [28] = 'LA' THEN 'Izquierda detrás' WHEN [28] = 'LV' THEN 'Izquierdo delante' WHEN [28] = 'LM' THEN 'Izquierdo medio' WHEN [28] = 'M' THEN 'Medio' WHEN [28] = 'MV' THEN 'Medio delante' WHEN [28] = 'MA' THEN 'Medio detrás' WHEN [28] = '-' THEN 'N/A' WHEN [28] = 'TA' THEN 'Válvula de depósito' WHEN ISNULL([28], '') = '' THEN NULL ELSE [28] END AS [28], [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, 28, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [22], [23], [35], [28], [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,17,22,23,35,28,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": 2, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "24831007": 1, "24831015": 2 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }{ "Data": { "SessionId": 51, "Match": null, "Timestamp": "2026-08-14T20:44:11.9657758+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dke/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dke/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dke/" ], "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:44:12.5126278+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fdz/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fdz/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fdz/" ], "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:44:13.0126334+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aum/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aum/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aum/" ], "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:44:13.5017319+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mhx/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mhx/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mhx/" ], "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:44:14.1424018+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ra/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ra/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ra/" ], "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:44:14.5798344+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dl/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dl/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dl/" ], "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:44:15.5173322+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cayc/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cayc/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/cayc/" ], "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": 58, "Match": null, "Timestamp": "2026-08-14T20:44:16.3767407+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m26/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m26/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m26/" ], "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:44:17.2829593+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f13c/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f13c/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f13c/" ], "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:44:18.2985606+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m32/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m32/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m32/" ], "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:44:19.1226557+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/25/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/25/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/25/" ], "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": 62, "Match": null, "Timestamp": "2026-08-14T20:44:19.4820357+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pnf/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pnf/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/pnf/" ], "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": 63, "Match": null, "Timestamp": "2026-08-14T20:44:20.0602059+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sb/" ], "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": 64, "Match": null, "Timestamp": "2026-08-14T20:44:20.5758333+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/lfz/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/lfz/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/lfz/" ], "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": 65, "Match": null, "Timestamp": "2026-08-14T20:44:21.1695403+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aat/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aat/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aat/" ], "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": 66, "Match": null, "Timestamp": "2026-08-14T20:44:21.6226554+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/110/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/110/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/110/" ], "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": 67, "Match": null, "Timestamp": "2026-08-14T20:44:22.0133674+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jht02t/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jht02t/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jht02t/" ], "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": 68, "Match": null, "Timestamp": "2026-08-14T20:44:22.5133199+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f15/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f15/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/f15/" ], "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": 69, "Match": null, "Timestamp": "2026-08-14T20:44:23.0289248+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/012/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/012/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/012/" ], "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": 70, "Match": null, "Timestamp": "2026-08-14T20:44:23.5345817+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aaz/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aaz/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/aaz/" ], "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": 71, "Match": null, "Timestamp": "2026-08-14T20:44:24.1127282+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/mr20de657854a/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/mr20de657854a/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/mr20de657854a/" ], "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": 72, "Match": null, "Timestamp": "2026-08-14T20:44:24.6283156+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mps6/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mps6/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mps6/" ], "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": 73, "Match": null, "Timestamp": "2026-08-14T20:44:25.0971431+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m79/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m79/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/m79/" ], "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": 74, "Match": null, "Timestamp": "2026-08-14T20:44:25.6752014+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ado/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ado/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/ado/" ], "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": 75, "Match": null, "Timestamp": "2026-08-14T20:44:26.190812+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/euro/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/euro/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/euro/" ], "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": 76, "Match": null, "Timestamp": "2026-08-14T20:44:26.9407917+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/m9r782/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/m9r782/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/m9r782/" ], "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": 77, "Match": null, "Timestamp": "2026-08-14T20:44:27.6751652+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sjd/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sjd/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sjd/" ], "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": 78, "Match": null, "Timestamp": "2026-08-14T20:44:28.1595431+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/emv/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/emv/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/emv/" ], "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": 79, "Match": null, "Timestamp": "2026-08-14T20:44:28.8587548+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/v6/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/v6/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/v6/" ], "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": 80, "Match": null, "Timestamp": "2026-08-14T20:44:29.4056067+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/bmm/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/bmm/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/bmm/" ], "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": 81, "Match": null, "Timestamp": "2026-08-14T20:44:30.2806614+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sne/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sne/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sne/" ], "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": 82, "Match": null, "Timestamp": "2026-08-14T20:44:30.8274748+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dc0002/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dc0002/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dc0002/" ], "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": 83, "Match": null, "Timestamp": "2026-08-14T20:44:31.5462396+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fpq/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fpq/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fpq/" ], "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": 84, "Match": null, "Timestamp": "2026-08-14T20:44:32.483721+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/12/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/12/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/12/" ], "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": 85, "Match": null, "Timestamp": "2026-08-14T20:44:33.2180944+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/c50/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/c50/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/c50/" ], "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": 86, "Match": null, "Timestamp": "2026-08-14T20:44:34.0211126+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/18/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/18/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/18/" ], "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": 87, "Match": null, "Timestamp": "2026-08-14T20:44:34.7711363+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fsm/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fsm/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/fsm/" ], "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": 88, "Match": null, "Timestamp": "2026-08-14T20:44:35.4898646+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/els/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/els/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/els/" ], "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": 89, "Match": null, "Timestamp": "2026-08-14T20:44:35.8493038+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mlh/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mlh/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/mlh/" ], "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": 90, "Match": null, "Timestamp": "2026-08-14T20:44:36.5055111+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/prq/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/prq/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/prq/" ], "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": 91, "Match": null, "Timestamp": "2026-08-14T20:44:36.9742656+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/drw/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/drw/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/drw/" ], "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": 92, "Match": null, "Timestamp": "2026-08-14T20:44:38.1102928+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/02k/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/02k/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/02k/" ], "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": 93, "Match": null, "Timestamp": "2026-08-14T20:44:38.6875296+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dwh/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dwh/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/dwh/" ], "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": 94, "Match": null, "Timestamp": "2026-08-14T20:44:39.7500277+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/yd/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/yd/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/yd/" ], "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": 95, "Match": null, "Timestamp": "2026-08-14T20:44:40.4062907+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/8v/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/8v/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/8v/" ], "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": 96, "Match": null, "Timestamp": "2026-08-14T20:44:41.7656529+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/m9r833/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/m9r833/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/m9r833/" ], "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": 97, "Match": null, "Timestamp": "2026-08-14T20:44:42.9687836+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jb/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jb/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/jb/" ], "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": 98, "Match": null, "Timestamp": "2026-08-14T20:44:43.648281+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sst/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sst/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-caja-de-cambios/sst/" ], "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": 99, "Match": null, "Timestamp": "2026-08-14T20:44:45.3045858+02:00", "UrlRawCurrent": "/stock-de-piezas/buscar/codigo-de-motor/r9m450/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/buscar/codigo-de-motor/r9m450/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/buscar/codigo-de-motor/r9m450/" ], "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": 100, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-gateway/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-gateway/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-piezas/almacen/marca/audi/modelo/rs3/pieza/modulo-gateway/" ], "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 ('2580B') 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], [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)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [25])) 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) 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": 10, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "23532718": 1, "23267554": 1, "22419769": 1, "25357941": 1, "21941219": 2, "21958329": 1, "23444761": 1, "17772909": 2, "19577988": 1, "17555707": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "España", "CountryId": 724, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }