Pompe ABS avec code moteur CSUB Usagé

Fournisseur Duitse Auto Onderdelen

Pompe ABS d'un Audi A6 (C7) 3.0 V6 24V TFSI Quattro 2016

Pompe ABS avec code moteur CSUB Usagé

Fournisseur Duitse Auto Onderdelen

3 mois de garantie

met uitzondering van elektronische onderdelen.

€ 278,30 Prix 21,00% TTC

Livrer

Ramasser

Pour plus d'informations, veuillez contacter le vendeur.

Expédier à

Description	Total
Usagé Pompe ABS [ Incl. TVA 21,0% ]Audi A6 (C7) 3.0 V6 24V TFSI Quattro ↪ 3 mois de garantie met uitzondering van elektronische onderdelen.	€ 278,30
Frais de livraison [ Incl. TVA 21,0% ]	€ 22,00
Total	€ 300,30

Commande en ligne depuis France non possible. Veuillez contacter Duitse Auto Onderdelen.

Description	PropertyId	MaxScore	Score
Motorcode	108	64	64
Media	58	34	34
Motortype	17	32	32
Prijs	14	16	16
Cilinderinhoud	18	16	16
Tellerstand	26	8	8
Garantie	135	3	3
Aldoc	153	2	2
Soort	13	1	1
Totaal		176	176

RecordId: 17371419

WebId: -

AutoRecordId: 8054013

Prijs Origineel: 278,30

Prijs Soort: BTW

Prijs BTW: Included

Prijs Tonen: True

Internet (AM): Oui (Non)

Shop: Oui

Aantal (Infinite): 1 (Non)

OrderStatus: Ok ( Record is bestelbaar )

Verkocht: -

ID Internet: 2698

SKU: P17371419

Site: HALAC

Année de construction: 02-2016

Article numéro: 4G0614517AL 4G0907379S

Code spécification: -

Code classification

fonctionnement testé
la norme est au maximum 35.000 kilomètres

Type de moteur: Essence

Cylindrée: 3 000 cc

Code moteur: CSUB CREC

Marque pièce: OEM

Relevé du compteur kilométrique: 34 km

Particularités: Z.G.A.N. !
Gedemonteerd van een schadevrije auto.

Cette partie peut être applicable aux types suivants.

Audi A5 Sportback (8TA)

: 2.0 TDI 16V Quattro, Liftback, Diesel, 1.968cc, 130kW (177pk), 4x4, CGLC, 2011-12 / 2017-01; 2.0 TDI 16V, Liftback, Diesel, 1.968cc, 105kW (143pk), FWD, CAGA; CJCA; CMEA; CMFA, 2009-09 / 2017-01; 2.0 TDI 16V, Liftback, Diesel, 1.968cc, 105kW (143pk), FWD, CMFA, 2011-11 / 2017-01; 2.0 TDI 16V, Liftback, Diesel, 1.968cc, 120kW (163pk), FWD, CNHC, 2013-09 / 2017-01

Audi A6 (C7)

: 2.0 T FSI 16V Hybrid Quattro, Berline, 4 portes, Electrique Essence, 1.984cc, 155kW (211pk), 4x4, CHJA, 2012-01 / 2018-09; 2.0 T FSI 16V Hybrid, Berline, 4 portes, Electrique Essence, 1.984cc, 180kW (245pk), FWD, CHJA, 2011-11 / 2018-09; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 155kW (211pk), 4x4, CAEB, 2012-05 / 2015-04; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 162kW (220pk), 4x4, CAED, 2013-05 / 2018-09; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 183kW (249pk), 4x4, CYPB, 2015-05 / 2018-09; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 185kW (252pk), 4x4, CYNB, 2014-05 / 2018-09; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA, 2014-05 / 2018-09; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA; CYNB, 2014-05 / 2018-09; 2.0 T FSI 16V Quattro, Berline, 4 portes, Essence, 1.984cc, 185kW, CYPA; CYNB, 2014-05 / 2018-09; 2.0 T FSI 16V, Berline, 4 portes, Essence, 1.984cc, 132kW (179pk), FWD, CDNB, 2011-05 / 2018-09; 2.0 T FSI 16V, Berline, 4 portes, Essence, 1.984cc, 155kW (211pk), FWD, CAEB, 2011-03 / 2013-05; 2.0 T FSI 16V, Berline, 4 portes, Essence, 1.984cc, 162kW (220pk), FWD, CAED, 2013-05 / 2018-09; 2.0 T FSI 16V, Berline, 4 portes, Essence, 1.984cc, 185kW (252pk), FWD, CYNB, 2014-09 / 2018-09; 2.0 T FSI 16V, Berline, 4 portes, Essence, 1.984cc, 185kW (252pk), FWD, CYPA, 2014-09 / 2018-09; 2.0 T FSI 16V, Berline, 4 portes, Essence, 1.984cc, 185kW (252pk), FWD, CYPA; CYNB, 2014-09 / 2018-09

: 2.0 TDI 16V Quattro, Berline, 4 portes, Diesel, 1,968cc, 140kW, CNHA, 2015-04 / 2018-09; 2.0 TDI 16V Quattro, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), 4x4, CNHA, 2015-04 / 2018-09; 2.0 TDI 16V Quattro, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), 4x4, CNHA; DDDA, 2015-04 / 2018-09; 2.0 TDI 16V Quattro, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), 4x4, DDDA, 2016-07 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1 968cc, 110kW, CSUD, 2014-09 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 100kW (136pk), FWD, CGLE, 2012-01 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 100kW (136pk), FWD, CGLE; CSUE; DDCA, 2012-01 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 100kW (136pk), FWD, CSUE, 2014-11 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 100kW (136pk), FWD, DDCA, 2016-07 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 110kW (150pk), FWD, CSUD, 2014-09 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 110kW (150pk), FWD, CSUD; DDCB, 2014-09 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 110kW (150pk), FWD, DDCB, 2016-07 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 120kW (163pk), FWD, CGLD, 2011-03 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 130kW (177pk), FWD, CGLC, 2011-03 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 130kW (177pk), FWD, CGLC; CMGB, 2011-03 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 130kW (177pk), FWD, CMGB, 2011-03 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), FWD, CNHA, 2013-11 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), FWD, CNHA; DDDA; CZJA, 2013-11 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), FWD, CZJA, 2016-01 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), FWD, DDDA, 2016-07 / 2018-09; 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW, CNHA; CZJA; DDDA, 2013-11 / 2018-05

: 2.8 V6 24V FSI Quattro, Berline, 4 portes, Essence, 2.773cc, 150kW (204pk), 4x4, CHVA, 2010-11 / 2015-04; 2.8 V6 24V FSI Quattro, Berline, 4 portes, Essence, 2.773cc, 162kW (220pk), 4x4, CVPA, 2014-09 / 2018-09; 2.8 V6 24V FSI, Berline, 4 portes, Essence, 2.773cc, 150kW (204pk), FWD, CHVA, 2010-11 / 2015-04

: 3.0 V6 24V TFSI Quattro, Berline, 4 portes, Essence, 2.995cc, 220kW (299pk), 4x4, CGWB, 2010-11 / 2012-05; 3.0 V6 24V TFSI Quattro, Berline, 4 portes, Essence, 2.995cc, 228kW (310pk), 4x4, CGXB; CGWD; CTUA, 2011-03 / 2018-09; 3.0 V6 24V TFSI Quattro, Berline, 4 portes, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2014-09 / 2018-09

: 3.0 TDI V6 24V BiTurbo Quattro, Berline, 4 portes, Diesel, 2.967cc, 235kW (320pk), 4x4, CVUA, 2014-09 / 2018-09; 3.0 TDI V6 24V BiTurbo Quattro, Berline, 4 portes, Diesel, 2.967cc, 240kW (326pk), 4x4, CVUB, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 150kW (204pk), 4x4, CLAA, 2011-03 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF; CZVC, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 155kW (211pk), 4x4, CZVC, 2015-11 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE; CZVA, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 160kW (218pk), 4x4, CZVA, 2015-11 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 160kW, CRTE; CZVA, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 176kW (239pk), 4x4, CPNB, 2013-05 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC, 2010-11 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC; CKVB; CDUD; CKVC, 2011-03 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUD, 2012-04 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 200kW (272pk), 4x4, CRTD, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Berline, 4 portes, Diesel, 2.967cc, 230kW (313pk), 4x4, CGQB, 2011-11 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 150kW (204pk), FWD, CLAB, 2010-11 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 155kW (211pk), FWD, CTCB, 2014-09 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 155kW (211pk), FWD, CTCB; CZVD, 2014-09 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 155kW (211pk), FWD, CZVD, 2015-11 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 160kW (218pk), FWD, CTCC, 2014-09 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 160kW (218pk), FWD, CTCC; CZVB, 2014-09 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 160kW (218pk), FWD, CZVB, 2015-11 / 2018-09; 3.0 TDI V6 24V, Berline, 4 portes, Diesel, 2.967cc, 160kW, CTCC; CZVB, 2014-09 / 2018-09

: 3.0 TDI V6 24V Clean Diesel Quattro, Berline, 4 portes, Diesel, 2.967cc, 180kW (245pk), 4x4, CKVB, 2011-11 / 2012-05; 3.0 TDI V6 24V Clean Diesel Quattro, Berline, 4 portes, Diesel, 2.967cc, 180kW (245pk), 4x4, CKVC, 2012-04 / 2018-09

: 1.8 T FSI 16V, Berline, 4 portes, Essence, 1.798cc, 140kW (190pk), FWD, CYGA, 2014-09 / 2018-09

Audi A6 Allroad Quattro (C7)

: 3.0 V6 24V TFSI, Combi, Essence, 2.995cc, 228kW (310pk), 4x4, CGWD, 2012-01 / 2014-12; 3.0 V6 24V TFSI, Combi, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2014-09 / 2018-09

: 3.0 TDI V6 24V biturbo, Combi, Diesel, 2.967cc, 235kW (320pk), 4x4, CVUA, 2012-01 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2,967cc, 140kW, CZVF, 2015-11 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 140kW (190pk), 4x4, CZVF, 2015-11 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 150kW (204pk), 4x4, CLAA, 2012-01 / 2014-12; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF; CZVC, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 155kW (211pk), 4x4, CZVC, 2015-11 / 2019-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE; CZVA, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW (218pk), 4x4, CZVA, 2015-11 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW, CRTE; CZVA, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC; CKVB; CDUD; CKVC, 2012-01 / 2016-06; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 200kW (272pk), 4x4, CRTD, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 230kW (313pk), 4x4, CGQB, 2012-01 / 2014-12

Audi A6 Avant (C7)

: 2.0 TDI 16V Quattro, Combi, Diesel, 1,968cc, 140kW, CNHA, 2015-04 / 2018-09; 2.0 TDI 16V Quattro, Combi, Diesel, 1.968cc, 140kW (190pk), 4x4, CNHA, 2015-04 / 2018-09; 2.0 TDI 16V Quattro, Combi, Diesel, 1.968cc, 140kW (190pk), 4x4, CNHA; DDDA, 2015-04 / 2018-09; 2.0 TDI 16V Quattro, Combi, Diesel, 1.968cc, 140kW (190pk), 4x4, DDDA, 2016-11 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1 968cc, 110kW, CSUD, 2014-09 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 100kW (136pk), FWD, CGLE, 2012-01 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 100kW (136pk), FWD, CGLE; CSUE; DDCA, 2012-01 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 100kW (136pk), FWD, CSUE, 2014-10 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 100kW (136pk), FWD, DDCA, 2016-07 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 110kW (150pk), FWD, CSUD, 2014-09 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 110kW (150pk), FWD, CSUD; DDCB, 2014-09 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 110kW (150pk), FWD, DDCB, 2016-07 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 120kW (163pk), FWD, CGLD, 2011-05 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 130kW (177pk), FWD, CGLC, 2011-05 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 130kW (177pk), FWD, CGLC; CMGB, 2011-05 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 130kW (177pk), FWD, CMGB, 2011-05 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 140kW (190pk), FWD, CNHA, 2013-11 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 140kW (190pk), FWD, CNHA; DDDA; CZJA, 2013-11 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 140kW (190pk), FWD, CZJA, 2016-01 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 140kW (190pk), FWD, DDDA, 2016-07 / 2018-09; 2.0 TDI 16V, Combi, Diesel, 1.968cc, 140kW, CNHA; CZJA; DDDA, 2013-11 / 2018-09

: 2.8 V6 24V FSI Quattro, Combi, Essence, 2.773cc, 150kW (204pk), 4x4, CHVA, 2011-05 / 2015-04; 2.8 V6 24V FSI Quattro, Combi, Essence, 2.773cc, 162kW (220pk), 4x4, CVPA, 2014-09 / 2018-09; 2.8 V6 24V FSI, Combi, Essence, 2.773cc, 150kW (204pk), FWD, CHVA, 2011-05 / 2015-04

: 3.0 V6 24V TFSI Quattro, Combi, Essence, 2.967cc, 245kW (333pk), 4x4, CREC, 2014-09 / 2018-09; 3.0 V6 24V TFSI Quattro, Combi, Essence, 2.995cc, 220kW (299pk), 4x4, CGWB, 2011-05 / 2012-05; 3.0 V6 24V TFSI Quattro, Combi, Essence, 2.995cc, 228kW (310pk), 4x4, CGWD, 2011-11 / 2018-09

: 3.0 TDI V6 24_, Combi, Diesel, 2.967cc, 155kW (211pk), FWD, CTCB, 2014-10 / 2018-09; 3.0 TDI V6 24_, Combi, Diesel, 2.967cc, 155kW (211pk), FWD, CTCB; CZVD, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 150kW (204pk), 4x4, CLAA, 2011-05 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 160kW, CRTE; CZVA, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC, 2011-05 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC; CKVB; CDUD; CKVC, 2011-05 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUD, 2012-04 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 180kW (245pk), 4x4, CKVB, 2011-11 / 2012-05; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 180kW (245pk), 4x4, CKVC, 2012-04 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 230kW (313pk), 4x4, CGQB, 2011-11 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 150kW (204pk), FWD, CLAB, 2011-05 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 155kW (211pk), FWD, CZVD, 2015-11 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW (218pk), FWD, CTCC, 2014-10 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW (218pk), FWD, CTCC; CZVB, 2014-09 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW (218pk), FWD, CZVB, 2015-11 / 2018-09; 3.0 TDI V6 24V, Combi, Diesel, 2.967cc, 160kW, CTCC; CZVB, 2014-09 / 2018-09

: 2.0 TFSI 16V Quattro, Combi, Essence, 1.984cc, 183kW (249pk), 4x4, CYPB, 2015-05 / 2018-09; 2.0 TFSI 16V Quattro, Combi, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA, 2015-05 / 2018-09; 2.0 TFSI 16V, Combi, Essence, 1.984cc, 132kW (179pk), FWD, CDNB, 2011-06 / 2018-09; 2.0 TFSI 16V, Combi, Essence, 1.984cc, 185kW (252pk), FWD, CYNB, 2014-09 / 2018-09; 2.0 TFSI 16V, Combi, Essence, 1.984cc, 185kW (252pk), FWD, CYPA, 2014-09 / 2018-09; 2.0 TFSI 16V, Combi, Essence, 1.984cc, 185kW (252pk), FWD, CYPA; CYNB, 2014-09 / 2018-09

: 2.0 T FSI 16V Quattro, Combi, Essence, 1,984cc, 185kW, CYPA, 2015-05 / 2018-09

: 1.8 TFSI 16V, Combi, Essence, 1.798cc, 140kW (190pk), FWD, CYGA, 2014-09 / 2018-09

: 3.0 TDI V6 24V biturbo Quattro, Combi, Diesel, 2.967cc, 235kW (320pk), 4x4, CVUA, 2014-09 / 2018-09; 3.0 TDI V6 24V biturbo Quattro, Combi, Diesel, 2.967cc, 240kW (326pk), 4x4, CVUB, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF, 2014-10 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF; CZVC, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 155kW (211pk), 4x4, CZVC, 2015-11 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE, 2014-10 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE; CZVA, 2014-09 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 160kW (218pk), 4x4, CZVA, 2015-11 / 2018-09; 3.0 TDI V6 24V Quattro, Combi, Diesel, 2.967cc, 200kW (272pk), 4x4, CRTD, 2014-09 / 2018-09

: 1.8 35 TFSI 16V, Combi, Essence, 1.798cc, 140kW (190pk), FWD, CYGA, 2017-06 / 2018-09

: 2.0 40 TFSI 16V Quattro, Combi, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA, 2017-06 / 2018-09

Audi A7 Sportback (4GA/4GF)

: 3.0 TDI Ultra V6 24V Quattro, Liftback, Diesel, 2.967cc, 155kW (211pk), 4x4, CZVC, 2015-11 / 2018-05; 3.0 TDI Ultra V6 24V Quattro, Liftback, Diesel, 2.967cc, 155kW (211pk), 4x4, CZVD, 2015-11 / 2018-05; 3.0 TDI Ultra V6 24V Quattro, Liftback, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE, 2014-07 / 2018-05; 3.0 TDI Ultra V6 24V Quattro, Liftback, Diesel, 2.967cc, 160kW (218pk), 4x4, CRTE; CZVA, 2014-07 / 2018-05; 3.0 TDI Ultra V6 24V Quattro, Liftback, Diesel, 2.967cc, 160kW (218pk), 4x4, CZVA, 2015-11 / 2018-05; 3.0 TDI Ultra V6 24V, Berline avec hayon arrière, 4 portes, Diesel, 2 967cc, 160kW, CTCC, 2014-07 / 2018-05; 3.0 TDI Ultra V6 24V, Berline avec hayon arrière, 4 portes, Diesel, 2,967cc, 140kW, CZVE, 2015-11 / 2018-05; 3.0 TDI Ultra V6 24V, Liftback, Diesel, 2.967cc, 140kW (190pk), FWD, CZVE, 2015-11 / 2018-05; 3.0 TDI Ultra V6 24V, Liftback, Diesel, 2.967cc, 160kW (218pk), FWD, CTCC, 2014-07 / 2018-05; 3.0 TDI Ultra V6 24V, Liftback, Diesel, 2.967cc, 160kW (218pk), FWD, CTCC; CZVB, 2014-07 / 2018-05; 3.0 TDI Ultra V6 24V, Liftback, Diesel, 2.967cc, 160kW (218pk), FWD, CZVB, 2015-11 / 2018-05; 3.0 TDI V6 24V biturbo Quattro, Liftback, Diesel, 2.967cc, 235kW (320pk), 4x4, CVUA, 2014-05 / 2018-05; 3.0 TDI V6 24V biturbo Quattro, Liftback, Diesel, 2.967cc, 240kW (326pk), 4x4, CVUB, 2014-09 / 2018-05; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 140kW (190pk), 4x4, CZVF, 2015-11 / 2018-05; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 150kW (204pk), 4x4, CLAA, 2010-12 / 2015-03; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF, 2014-07 / 2018-05; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 155kW (211pk), 4x4, CRTF; CTCB; CZVC; CZVD, 2014-07 / 2018-05; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 155kW (211pk), 4x4, CTCB, 2014-07 / 2018-05; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 176kW (239pk), 4x4, CPNB, 2013-05 / 2017-06; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC, 2010-07 / 2016-06; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUC; CKVB; CDUD; CKVC, 2010-10 / 2016-06; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 180kW (245pk), 4x4, CDUD, 2012-05 / 2016-06; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 180kW (245pk), 4x4, CKVB, 2011-11 / 2012-05; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 180kW (245pk), 4x4, CKVC, 2012-05 / 2016-06; 3.0 TDI V6 24V Quattro, Liftback, Diesel, 2.967cc, 230kW (313pk), 4x4, CGQB, 2011-11 / 2015-03; 3.0 TDI V6 24V, Liftback, Diesel, 2.967cc, 150kW (204pk), FWD, CLAB, 2010-11 / 2015-03; 3.0 TDI V6 24V, Liftback, Diesel, 2.967cc, 155kW (211pk), FWD, CTCB, 2015-11 / 2018-05; 3.0 TDI V6 24V, Liftback, Diesel, 2.967cc, 155kW (211pk), FWD, CTCB; CZVC; CZVD, 2015-11 / 2018-05; 3.0 TDI V6 24V, Liftback, Diesel, 2.967cc, 155kW (211pk), FWD, CZVC, 2015-11 / 2018-05; 3.0 TDI V6 24V, Liftback, Diesel, 2.967cc, 155kW (211pk), FWD, CZVD, 2015-11 / 2018-05

: 2.8 V6 24V FSI Quattro, Liftback, Essence, 2.773cc, 150kW (204pk), 4x4, CHVA, 2010-10 / 2015-03; 2.8 V6 24V FSI Quattro, Liftback, Essence, 2.773cc, 150kW (204pk), 4x4, CHVA; CNYA, 2010-10 / 2015-03; 2.8 V6 24V FSI Quattro, Liftback, Essence, 2.773cc, 150kW (204pk), 4x4, CNYA, 2010-10 / 2015-03; 2.8 V6 24V FSI, Liftback, Essence, 2.773cc, 150kW (204pk), FWD, CHVA, 2011-02 / 2015-03

: 3.0 V6 24V 50 TFSI Quattro, Liftback, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2015-09 / 2018-05; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 220kW (299pk), 4x4, CGWB, 2010-10 / 2012-05; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 228kW (310pk), 4x4, CGWD, 2011-11 / 2015-03; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 228kW (310pk), 4x4, CGXB, 2011-01 / 2012-05; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 228kW (310pk), 4x4, CGXB; CGWD; CTUA; CTTA, 2011-01 / 2015-03; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 228kW (310pk), 4x4, CTTA, 2011-11 / 2015-03; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 228kW (310pk), 4x4, CTUA, 2012-05 / 2015-03; 3.0 V6 24V TFSI Quattro, Liftback, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2014-05 / 2018-05

: 1.8 TFSI 16V, Berline avec hayon arrière, 4 portes, Essence, 1,798cc, 140kW, CYGA, 2015-04 / 2018-05; 1.8 TFSI 16V, Liftback, Essence, 1.798cc, 140kW (190pk), FWD, CYGA, 2015-04 / 2018-05

: 2.0 16V 40 TFSI, Liftback, Essence, 1.984cc, 185kW (252pk), FWD, CYPA, 2015-09 / 2018-05; 2.0 16V TFSI Quattro, Berline avec hayon arrière, 4 portes, Essence, 1.984cc, 185kW, CYPA; CYNB, 2015-05 / 2018-05; 2.0 16V TFSI Quattro, Liftback, Essence, 1.984cc, 183kW (249pk), 4x4, CYPB, 2015-05 / 2018-05; 2.0 16V TFSI Quattro, Liftback, Essence, 1.984cc, 185kW (252pk), 4x4, CYNB, 2015-05 / 2018-05; 2.0 16V TFSI Quattro, Liftback, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA, 2015-05 / 2018-05; 2.0 16V TFSI Quattro, Liftback, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA; CYNB, 2015-05 / 2018-05; 2.0 16V TFSI, Liftback, Essence, 1.984cc, 185kW (252pk), FWD, CYPA, 2014-09 / 2018-05

: 3.0 TDI Clean Diesel V6 24V Quattro, Liftback, Diesel, 2.967cc, 200kW (272pk), 4x4, CRTD, 2014-05 / 2018-05

: 1.8 35 TFSI 16V, Liftback, Essence, 1.798cc, 140kW (190pk), FWD, CYGA, 2016-02 / 2018-05

: 2.0 16V 40 TFSI Quattro, Liftback, Essence, 1.984cc, 185kW (252pk), 4x4, CYPA, 2015-09 / 2018-05

Audi Q7 (4MB/4MG)

: 3.0 TFSI V6 24V, SUV, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2015-01 / 2019-12

Audi RS7 Sportback (4GA/4GF)

: 4.0 V8 TFSI 32V, Berline avec hayon arrière, 4 portes, Essence, 3.993cc, 412kW (560pk), 4x4, CRDB, 2013-10 / 2014-07; 4.0 V8 TFSI 32V, Berline avec hayon arrière, 4 portes, Essence, 3.993cc, 412kW (560pk), 4x4, CRDB; CWUB, 2013-10 / 2018-04; 4.0 V8 TFSI 32V, Berline avec hayon arrière, 4 portes, Essence, 3.993cc, 412kW (560pk), 4x4, CWUB, 2014-08 / 2018-04; 4.0 V8 TFSI Performance 32V, Berline avec hayon arrière, 4 portes, Essence, 3.993cc, 445kW (605pk), 4x4, CWUC, 2015-11 / 2018-04

Audi S7 Sportback (4GA/4GF)

: 4.0 V8 TFSI, Berline avec hayon arrière, 4 portes, Essence, 3.993cc, 309kW (420pk), 4x4, CEUC, 2012-02 / 2015-03; 4.0 V8 TFSI, Berline avec hayon arrière, 4 portes, Essence, 3.993cc, 331kW (450pk), 4x4, CTGE, 2014-07 / 2018-05

Opérateur économique responsable dans l'UE

Nom de l'entreprise: Audi A.G.
Adresse: Auto-Union-Straße 1
D-85057, Ingolstadt
Allemagne
Site web: www.audi.com

Informations

Dit onderdeel is bestemd voor gebruik in motorvoertuigen en dient uitsluitend te worden gemonteerd en gebruikt volgens de voorschriften van de voertuigfabrikant. Montage door een gekwalificeerde vakman wordt aanbevolen. Controleer vóór montage altijd de compatibiliteit met het voertuig. Beschadigde of verkeerd gemonteerde onderdelen kunnen een veiligheidsrisico veroorzaken.

Donneur véhicule

Démontée de Audi A6 (C7) 3.0 V6 24V TFSI QuattroBerline, 4 portes, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2014-09 / 2018-09, 4G2; 4GC

Toutes les pièces démontées

Contacter le vendeur

Duitse auto onderdelenNuméro de CDC: 67905552Numéro de TVA: NL002517874B56

Meerlandenweg 60A, 1187 ZR, AmstelveenNoord-Holland, Pays-Bas

Téléphone

Spécialisé dans AudiBMWCupraMiniSeatVolkswagen

Heures d'ouverture

Jours		Ouvert (GMT+2)	Pause (GMT+2)
lundi	17 août	12:00 - 18:00	-
mardi	18 août	10:00 - 18:00	-
mercredi	19 août	10:00 - 18:00	-
jeudi	20 août	10:00 - 18:00	-
vendredi	21 août	10:00 - 18:00	-
samedi	22 août	10:00 - 16:00	-
dimanche	23 août	Fermé

Jours		Ouvert (GMT+2)	Pause (GMT+2)
lundi	24 août	12:00 - 18:00	-
mardi	25 août	10:00 - 18:00	-
mercredi	26 août	10:00 - 18:00	-
jeudi	27 août	10:00 - 18:00	-
vendredi	28 août	10:00 - 18:00	-
samedi	29 août	10:00 - 16:00	-
dimanche	30 août	Fermé

Jours		Ouvert (GMT+2)	Pause (GMT+2)
lundi	31 août	12:00 - 18:00	-
mardi	01 sept.	10:00 - 18:00	-
mercredi	02 sept.	10:00 - 18:00	-
jeudi	03 sept.	10:00 - 18:00	-
vendredi	04 sept.	10:00 - 18:00	-
samedi	05 sept.	10:00 - 16:00	-
dimanche	06 sept.	Fermé

Termes et conditions généralesConditions de garantie

Posez une question à Duitse Auto Onderdelen

Renseignez vos coordonnées et informations de livraison le plus complètement possible et contactez le vendeur.

Nom ** (1

Nom de l'entreprise ** (1

Pays

Code postal

Nom de rue

N°

Lieu

Avez-vous plus d'informations sur la pièce que vous recherchez?

Numéro de TVA

Numéro d'immatriculation de votre voiture

Numéro de châssis de votre voiture

Numéro de pièce

Votre message à Duitse Auto Onderdelen:

Adresse email

Téléphone

Oui, envoyez-moi une copie

*	champ obligatoire
**	au minimum un champ est obligatoire

Voir aussi Pompes ABS

Pompe ABS Audi A6 (C7), 2010 / 2018 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), FWD, CNHA; DDDA; CZJA, 2013-11 / 2018-09, 4G2; 4GC (Occasion)

€ 230,00

Pompe ABS Audi A6 (C7), 2010 / 2018 2.0 TDI 16V, Berline, 4 portes, Diesel, 1.968cc, 140kW (190pk), FWD, CNHA; DDDA; CZJA, 2013-11 / 2018-09, 4G2; 4GC (Occasion)

€ 230,00

Pompe ABS Audi A5 Sportback (8TA), 2009 / 2017 2.0 TDI 16V, Liftback, Diesel, 1.968cc, 105kW (143pk), FWD, CMFA, 2011-11 / 2017-01, 8TA (Occasion)

€ 180,00

Pompe ABS Audi A5 Sportback (8TA), 2009 / 2017 2.0 TDI 16V, Liftback, Diesel, 1.968cc, 105kW (143pk), FWD, CAGA; CJCA; CMEA; CMFA, 2009-09 / 2017-01, 8TA (Occasion)

€ 180,00

Pompe ABS Audi A5 Sportback (8TA), 2009 / 2017 2.0 TDI 16V, Liftback, Diesel, 1.968cc, 100kW (136pk), FWD, CAGB; CJCB; CSUB, 2009-09 / 2017-01, 8TA (Occasion)

€ 85,00

Pompe ABS Audi A6 (C7), 2010 / 2018 3.0 V6 24V TFSI Quattro, Berline, 4 portes, Essence, 2.995cc, 245kW (333pk), 4x4, CREC, 2014-09 / 2018-09, 4G2; 4GC (Occasion)

€ 230,00

Init

{ "Data": { "SessionId": 13, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 0, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 0, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": null, "CountryId": 0, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

All sessions

{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "2026-08-18T15:17:32.669183+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/m0dc/piece/servo-frein/id-piece/25437253/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/m0dc/piece/servo-frein/id-piece/25437253/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/m0dc/piece/servo-frein/id-piece/25437253/" ], "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-18T15:17:35.7316872+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/entrepot/numero-de-piece/0200/piece/cable-commutation-boite-de-vitesse/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/entrepot/numero-de-piece/0200/piece/cable-commutation-boite-de-vitesse/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/entrepot/numero-de-piece/0200/piece/cable-commutation-boite-de-vitesse/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @RM TABLE ([RecordId] BIGINT NOT NULL, [xPR] DECIMAL(9, 2), [xPS] BIT NOT NULL, [xPD] INT, [xTP] DECIMAL(5, 2) NOT NULL, [xTT] INT NOT NULL, [xShopState] INT, [xShippingState] TINYINT, [Match] INT, [XChange] BIT, [xPF] DECIMAL(9, 2), [xPE] DECIMAL(9, 2), [xPI] DECIMAL(9, 2) PRIMARY KEY CLUSTERED (RecordId ASC)) INSERT INTO @RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [Match], [XChange], [xPF], [xPE], [xPI]) SELECT  *,  CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 1 THEN CAST([xPF] / ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPE],  CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 0 THEN CAST([xPF] * ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPI]     FROM (SELECT  *,  CASE WHEN [xPS] = 1 AND [xPR] IS NOT NULL THEN CAST(CASE WHEN [xPD] IS NOT NULL THEN (CAST((100 - ISNULL([xPD], 0)) AS DECIMAL) / 100) * [xPR] ELSE [xPR] END AS DECIMAL(10, 2)) END AS [xPF]     FROM (SELECT  [R].[RecordId],  (ISNULL(CASE WHEN [R].[Shop] = 1 THEN ISNULL([R].[PriceShop],ROUND ( [R].[Prijs] * ((100 + ISNULL([D].[ShopPricePercentage], 0)) / 100), 2)) END, [R].[Prijs])) AS [xPR],  CASE WHEN [R].[PrijsTonen] IS NOT NULL THEN [R].[PrijsTonen] WHEN [R].[SoortId] = 0 THEN [D].[OOLPrijzenG] WHEN [R].[SoortId] = 1 THEN [D].[OOLPrijzenR] WHEN [R].[SoortId] = 2 THEN [D].[OOLPrijzenN] ELSE 1 END AS [xPS],  (SELECT [T].[Discount] FROM dbo.[AutomatePartDiscount] [T] WHERE [T].[SupplierId] = [R].[DebiteurId] AND [T].[StateId] = [R].[SoortId] AND [T].[PartAutomateId] = [R].[DeelId]) AS [xPD],  ISNULL([VT].[General], 21) AS [xTP],  CASE WHEN [R].[SoortId] = 0 AND NOT ISNULL([R].[PrijsSoort], 0) = 1 THEN 2 WHEN [D].[OOLPrijzenExcl] = 0 THEN 1 ELSE 0 END AS [xTT],  CASE WHEN NOT [D].[ShopActive] = 1 THEN 11 ELSE dbo.fnGetOOLShopStateQuick([R].[RecordId], 1, 5, xShippingState) END AS [xShopState],  xShippingState AS [xShippingState],  NULL AS [Match],  CASE WHEN [RM].[xPM] = 4 THEN 1 END AS [XChange]     FROM (SELECT  [RM].[RecordId],  MAX([RM].[xPM]) AS [xPM]     FROM (SELECT  [R].[RecordId],  10 AS [xPM]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[DeelId] IN ('8852D') AND [R].[RecordId] IN (SELECT  [OT].[RecordId]     FROM dbo.[OOLPartnumbers] [OT] WITH (NOLOCK)     WHERE [OT].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodePartnumber] [CT]     WHERE ([CT].[Code] LIKE '0200%' OR [CT].[CodeReversed] LIKE '0020%'))) 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, 101444, 111111, 123456, 123457, 123462) UNION SELECT  [R].[RecordId],  4 AS [xPM]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] = '8852D' AND ([R].[RecordId] IN (SELECT  [OX].[RecordId]     FROM dbo.[OOLXchg] [OX] WITH (NOLOCK)     WHERE [OX].[CollectionId] IN (SELECT  [DX].[CollectionId]     FROM dbo.[DebtorXchgPartnumber] [DX]     WHERE [DX].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodePartnumber] [CT]     WHERE ([CT].[Code] LIKE '0200%' OR [CT].[CodeReversed] LIKE '0020%')))))) [RM]  GROUP BY [RM].[RecordId]) [RM]  LEFT JOIN dbo.[OOLInternet] [R] ON [R].[RecordId] = [RM].[RecordId]   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)   LEFT JOIN [Basis].dbo.[CountryVatRate] [VT] ON [VT].[CountryId] = [D].[LandId] AND [VT].[Active] = 1  OUTER APPLY (SELECT dbo.fnGetOOLShippingStateExtended([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 250, NULL) [xShippingState]) [SHS]) [R]) [R]; SELECT  [R].[DeelId],  [R].[SoortId],  COUNT(*) AS [Aantal]     FROM (SELECT  [R].[DeelId],  [R].[SoortId],  [R].[RecordId],  [R].[DebiteurId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) [R]  GROUP BY [R].[DeelId], [R].[SoortId]; SELECT  [R].*,  [xTP] AS [PrijsTaxPerc],  [xPD] AS [PrijsKorting],  (SELECT [VIBM].[Bouwmaand] FROM dbo.[VOLInternet] [VIBM] WHERE [VIBM].[RecordId] = [R].[AutoRecordId]) AS [ConstructionMonth],  [xPE] AS [PrijsAlt],  STUFF((SELECT '|' + CAST([V].[VeldId] AS VARCHAR(10)) + '^' + [V].[Waarde] FROM (SELECT [V].[VeldId], [V].[Waarde], [V].[OrderId] FROM dbo.[OOLVelden] [V] WHERE [V].[RecordId] = [R].[RecordId] AND [V].[VeldId] IN (26, 230, 231)) [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 (5, 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 (5, 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] = 5 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 5 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] = 5), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 5), '')) 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] = 5 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 [101] = 'I' THEN 'Intercooler' WHEN [101] = 'N' THEN 'Non' WHEN ISNULL([101], '') = '' THEN NULL ELSE [101] END AS [101],  TRY_CAST([18] AS INT) AS [18],  [V19].[NaamLang] AS [19],  CASE WHEN [36] = '4' THEN '4x4' WHEN [36] = 'A' THEN 'Roue arrière' WHEN [36] = 'V' THEN 'Roue avant' WHEN ISNULL([36], '') = '' THEN NULL ELSE [36] END AS [36],  [R].[Versnellingsbakcodes] AS [114],  (SELECT TOP 1 [XOV].[Waarde] FROM dbo.[OOLVelden] [XOV] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 241 ORDER BY [XOV].[OrderId]) AS [241],  TRY_CAST([26] AS INT) AS [26],  [25],  CASE WHEN [XChange] = 1 THEN ISNULL([R].[Artikelnummers] + '|', '') + ISNULL((SELECT TOP 1 [CT].[Code] FROM dbo.[OOLXchg] [X] LEFT JOIN dbo.[DebtorXchgPartnumber] [XP] ON [XP].[CollectionId] = [X].[CollectionId] LEFT JOIN dbo.[CodePartnumber] [CT] ON [CT].[Id] = [XP].[CodeId] WHERE [X].[RecordId] = [R].[RecordId] AND ([CT].[Code] LIKE '0200%' OR [CT].[CodeReversed] LIKE '0020%')), '0200') + '^0' ELSE [R].[Artikelnummers] END AS [21],  ISNULL([D].[Bedrijfsnaam], '') + '|' + ISNULL([D].[BedrijfKort], '') AS [Leverancier],  [R].[BijzonderheidInet],  [R].[WarrantyText] AS [GarantieToelichting],  [R].[Shop],  [R].[Created],  [xShippingState] AS [ShippingState],  [R].[WarrantyConstruction] AS [WarrantyInstallation],  [R].[DeelId],  [R].[DebiteurRecordId],  [R].[AldocModelCode],  [R].[AldocTypeId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange],  [R].[SModelId],  [R].[ModelId],  [R].[PrijsSoort],  [R].[PriceShop]     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].[Versnellingsbakcodes],  [R].[Artikelnummers],  [R].[BijzonderheidInet],  [R].[WarrantyText],  [R].[Shop],  [R].[Created],  [R].[WarrantyConstruction],  [R].[DeelId],  [R].[DebiteurRecordId],  [R].[AldocModelCode],  [R].[AldocTypeId],  [R].[DebiteurLocatieId],  [R].[SModelId],  [R].[ModelId],  [R].[PrijsSoort],  [R].[PriceShop],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) AS [R]  LEFT JOIN dbo.[OOLVelden] [OV] WITH (INDEX(PK_OOLVelden)) ON [OV].[RecordId] = [R].[RecordId] AND [OV].[VeldId] IN (184, 190, 135, 37, 101, 18, 19, 36, 241, 26, 25)) [R]  PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [101], [18], [19], [36], [241], [26], [25])) AS [R]) [R]  LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 5   LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 5 AND [MOT].[Synoniem] = 0   LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 5   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) [R]  ORDER BY [SortId] DESC,  + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [RowId] ASC     OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY) [R]; WITH [R] AS (SELECT  [R].[RecordId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange],  [Bouwjaar],  [xPI] AS [Prijs],  [ModelId]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) SELECT  [VeldId],  [Waarde] AS [Value],  NULL AS [ValueMIN],  NULL AS [ValueMAX]     FROM dbo.[OOLVelden] [OV]     WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (184,190,37,17,101,19,36,241,25)  GROUP BY [VeldId], [Waarde] UNION SELECT  [VeldId],  NULL AS [Value],  MIN([Waarde]) AS [ValueMIN],  MAX([Waarde]) AS [ValueMAX]     FROM (SELECT  [VeldId],  TRY_CAST([Waarde] AS INT) AS [Waarde]     FROM dbo.[OOLVelden] [OV]     WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (135,18,26)) [OV]  GROUP BY [VeldId] UNION SELECT  12,  NULL AS [Value],  MIN([R].[Bouwjaar]) AS [ValueMIN],  MAX([R].[Bouwjaar]) AS [ValueMAX]     FROM [R] UNION SELECT  14,  NULL AS [Value],  MIN(CAST([Prijs] AS INT)) AS [ValueMIN],  MAX(CAST([Prijs] AS INT)) AS [ValueMAX]     FROM [R] UNION SELECT  1,  [ModelId],  NULL AS [ValueMIN],  NULL AS [ValueMAX]     FROM [R] ORDER BY 1, 2; SELECT  DISTINCT  [R].[DebiteurId]     FROM (SELECT  DISTINCT  [DebiteurId]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[RecordId] In (Select [RM].[RecordId] FROM @RM [RM])) [R]; SELECT  [R].[DeelId],  [R].[SoortId],  COUNT(*) AS [Aantal]     FROM (SELECT  [R].[DeelId],  [R].[SoortId],  [R].[RecordId],  [R].[DebiteurId]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK FORCESEEK)     WHERE [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] IN ('8852C', '8895B', '8895X') AND [R].[RecordId] IN (SELECT  [OT].[RecordId]     FROM dbo.[OOLPartnumbers] [OT] WITH (NOLOCK)     WHERE [OT].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodePartnumber] [CT]     WHERE ([CT].[Code] LIKE '0200%' OR [CT].[CodeReversed] LIKE '0020%')))) [R]  GROUP BY [R].[DeelId], [R].[SoortId]" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 3, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "18005823": 1, "17199706": 1, "18125350": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "France", "CountryId": 250, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

{ "Data": { "SessionId": 3, "Match": null, "Timestamp": "2026-08-18T15:17:41.3118162+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/hm0/piece/pompe-de-direction/id-piece/22837274/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/hm0/piece/pompe-de-direction/id-piece/22837274/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/hm0/piece/pompe-de-direction/id-piece/22837274/" ], "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-18T15:17:46.0618199+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/411317/piece/bobine/id-piece/17469167/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/411317/piece/bobine/id-piece/17469167/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/411317/piece/bobine/id-piece/17469167/" ], "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-18T15:17:58.7961786+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/entrepot/code-moteur/6000/piece/echappement-silencieux-arriere/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/entrepot/code-moteur/6000/piece/echappement-silencieux-arriere/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/entrepot/code-moteur/6000/piece/echappement-silencieux-arriere/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @RM TABLE ([RecordId] BIGINT NOT NULL, [xPR] DECIMAL(9, 2), [xPS] BIT NOT NULL, [xPD] INT, [xTP] DECIMAL(5, 2) NOT NULL, [xTT] INT NOT NULL, [xShopState] INT, [xShippingState] TINYINT, [Match] INT, [XChange] BIT, [xPF] DECIMAL(9, 2), [xPE] DECIMAL(9, 2), [xPI] DECIMAL(9, 2) PRIMARY KEY CLUSTERED (RecordId ASC)) INSERT INTO @RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [Match], [XChange], [xPF], [xPE], [xPI]) SELECT  *,  CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 1 THEN CAST([xPF] / ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPE],  CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 0 THEN CAST([xPF] * ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPI]     FROM (SELECT  *,  CASE WHEN [xPS] = 1 AND [xPR] IS NOT NULL THEN CAST(CASE WHEN [xPD] IS NOT NULL THEN (CAST((100 - ISNULL([xPD], 0)) AS DECIMAL) / 100) * [xPR] ELSE [xPR] END AS DECIMAL(10, 2)) END AS [xPF]     FROM (SELECT  [R].[RecordId],  (ISNULL(CASE WHEN [R].[Shop] = 1 THEN ISNULL([R].[PriceShop],ROUND ( [R].[Prijs] * ((100 + ISNULL([D].[ShopPricePercentage], 0)) / 100), 2)) END, [R].[Prijs])) AS [xPR],  CASE WHEN [R].[PrijsTonen] IS NOT NULL THEN [R].[PrijsTonen] WHEN [R].[SoortId] = 0 THEN [D].[OOLPrijzenG] WHEN [R].[SoortId] = 1 THEN [D].[OOLPrijzenR] WHEN [R].[SoortId] = 2 THEN [D].[OOLPrijzenN] ELSE 1 END AS [xPS],  (SELECT [T].[Discount] FROM dbo.[AutomatePartDiscount] [T] WHERE [T].[SupplierId] = [R].[DebiteurId] AND [T].[StateId] = [R].[SoortId] AND [T].[PartAutomateId] = [R].[DeelId]) AS [xPD],  ISNULL([VT].[General], 21) AS [xTP],  CASE WHEN [R].[SoortId] = 0 AND NOT ISNULL([R].[PrijsSoort], 0) = 1 THEN 2 WHEN [D].[OOLPrijzenExcl] = 0 THEN 1 ELSE 0 END AS [xTT],  CASE WHEN NOT [D].[ShopActive] = 1 THEN 11 ELSE dbo.fnGetOOLShopStateQuick([R].[RecordId], 1, 5, xShippingState) END AS [xShopState],  xShippingState AS [xShippingState],  NULL AS [Match],  CASE WHEN [RM].[xPM] = 4 THEN 1 END AS [XChange]     FROM (SELECT  [RM].[RecordId],  MAX([RM].[xPM]) AS [xPM]     FROM (SELECT  [R].[RecordId],  10 AS [xPM]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[DeelId] IN ('8815X') AND [R].[RecordId] IN (SELECT  [OT].[RecordId]     FROM dbo.[OOLEnginecodes] [OT] WITH (NOLOCK)     WHERE [OT].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodeEngine] [CT]     WHERE [CT].[Code] LIKE '6000%')) 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, 101444, 111111, 123456, 123457, 123462) UNION SELECT  [R].[RecordId],  4 AS [xPM]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] = '8815X' AND ([R].[RecordId] IN (SELECT  [OX].[RecordId]     FROM dbo.[OOLXchg] [OX] WITH (NOLOCK)     WHERE [OX].[CollectionId] IN (SELECT  [DX].[CollectionId]     FROM dbo.[DebtorXchgEnginecode] [DX]     WHERE [DX].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodeEngine] [CT]     WHERE [CT].[Code] LIKE '6000%'))))) [RM]  GROUP BY [RM].[RecordId]) [RM]  LEFT JOIN dbo.[OOLInternet] [R] ON [R].[RecordId] = [RM].[RecordId]   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)   LEFT JOIN [Basis].dbo.[CountryVatRate] [VT] ON [VT].[CountryId] = [D].[LandId] AND [VT].[Active] = 1  OUTER APPLY (SELECT dbo.fnGetOOLShippingStateExtended([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 250, NULL) [xShippingState]) [SHS]) [R]) [R]; SELECT  [R].[DeelId],  [R].[SoortId],  COUNT(*) AS [Aantal]     FROM (SELECT  [R].[DeelId],  [R].[SoortId],  [R].[RecordId],  [R].[DebiteurId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) [R]  GROUP BY [R].[DeelId], [R].[SoortId]; SELECT  [R].*,  [xTP] AS [PrijsTaxPerc],  [xPD] AS [PrijsKorting],  (SELECT [VIBM].[Bouwmaand] FROM dbo.[VOLInternet] [VIBM] WHERE [VIBM].[RecordId] = [R].[AutoRecordId]) AS [ConstructionMonth],  [xPE] AS [PrijsAlt],  STUFF((SELECT '|' + CAST([V].[VeldId] AS VARCHAR(10)) + '^' + [V].[Waarde] FROM (SELECT [V].[VeldId], [V].[Waarde], [V].[OrderId] FROM dbo.[OOLVelden] [V] WHERE [V].[RecordId] = [R].[RecordId] AND [V].[VeldId] IN (26, 230, 231, 232)) [V] ORDER BY [V].[VeldId], [V].[OrderId] FOR XML PATH('')), 1, 1, '') AS [Automate2Velden],  CASE WHEN [R].[GarantieToelichting] IS NOT NULL THEN (SELECT TOP 1 [TV].[Translation] FROM [Storage].dbo.[TranslateTextResult] [TV] WHERE [TV].[TextId] = (SELECT [TR].[TextId] FROM [Storage].dbo.[TranslateTextRecord] [TR] WHERE [TR].[RecordId] = [R].[RecordId] AND [TR].[TextTypeId] = 2) AND [TV].[LanguageId] IN (5, 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 (5, 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] = 5 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 5 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] = 5), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 5), '')) 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] = 5 AND [XVT].[Waarde] = [XOV].[Waarde] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 17 ORDER BY [XOV].[OrderId] FOR XML PATH('')), 1, 1, '') AS [17],  CASE WHEN [XChange] = 1 THEN ISNULL([R].[Motorcodes] + '|', '') + ISNULL((SELECT TOP 1 [CT].[Code] FROM dbo.[OOLXchg] [X] LEFT JOIN dbo.[DebtorXchgEnginecode] [XP] ON [XP].[CollectionId] = [X].[CollectionId] LEFT JOIN dbo.[CodeEngine] [CT] ON [CT].[Id] = [XP].[CodeId] WHERE [X].[RecordId] = [R].[RecordId] AND [CT].[Code] LIKE '6000%'), '6000') ELSE [R].[Motorcodes] END AS [108],  TRY_CAST([18] AS INT) AS [18],  [V19].[NaamLang] AS [19],  CASE WHEN [22] = '2' THEN '2 portes' WHEN [22] = '4' THEN '4 portes' WHEN ISNULL([22], '') = '' THEN NULL ELSE [22] END AS [22],  [V23].[NaamLang] AS [23],  CASE WHEN [182] = 'R' THEN 'Droite' WHEN [182] = 'L' THEN 'Gauche' WHEN [182] = 'M' THEN 'Milieu' WHEN ISNULL([182], '') = '' THEN NULL ELSE [182] END AS [182],  (SELECT TOP 1 [XOV].[Waarde] FROM dbo.[OOLVelden] [XOV] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 241 ORDER BY [XOV].[OrderId]) AS [241],  TRY_CAST([26] AS INT) AS [26],  [25],  [R].[Artikelnummers] AS [21],  ISNULL([D].[Bedrijfsnaam], '') + '|' + ISNULL([D].[BedrijfKort], '') AS [Leverancier],  [R].[BijzonderheidInet],  [R].[WarrantyText] AS [GarantieToelichting],  [R].[Shop],  [R].[Created],  [xShippingState] AS [ShippingState],  [R].[WarrantyConstruction] AS [WarrantyInstallation],  [R].[DeelId],  [R].[DebiteurRecordId],  [R].[AldocModelCode],  [R].[AldocTypeId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange],  [R].[SModelId],  [R].[ModelId],  [R].[PrijsSoort],  [R].[PriceShop]     FROM (SELECT  *     FROM (SELECT  [R].*,  [OV].[VeldId],  [OV].[Waarde]     FROM (SELECT  [R].[SortId],  [R].[RecordId],  [R].[DebiteurId],  [R].[ExternalId],  [R].[ReferenceId],  [R].[Youtube],  [R].[Fotos],  [R].[SoortId],  [R].[PrijsTonen],  [R].[Prijs],  [R].[Bouwjaar],  [R].[AutoRecordId],  [R].[Motorcodes],  [R].[Artikelnummers],  [R].[BijzonderheidInet],  [R].[WarrantyText],  [R].[Shop],  [R].[Created],  [R].[WarrantyConstruction],  [R].[DeelId],  [R].[DebiteurRecordId],  [R].[AldocModelCode],  [R].[AldocTypeId],  [R].[DebiteurLocatieId],  [R].[SModelId],  [R].[ModelId],  [R].[PrijsSoort],  [R].[PriceShop],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) AS [R]  LEFT JOIN dbo.[OOLVelden] [OV] WITH (INDEX(PK_OOLVelden)) ON [OV].[RecordId] = [R].[RecordId] AND [OV].[VeldId] IN (184, 190, 135, 37, 18, 19, 22, 23, 182, 241, 26, 25)) [R]  PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [19], [22], [23], [182], [241], [26], [25])) AS [R]) [R]  LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 5   LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 5   LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 5 AND [MOT].[Synoniem] = 0   LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 5   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) [R]  ORDER BY [SortId] DESC,  + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [RowId] ASC     OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY) [R]; WITH [R] AS (SELECT  [R].[RecordId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange],  [Bouwjaar],  [xPI] AS [Prijs],  [ModelId]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) SELECT  [VeldId],  [Waarde] AS [Value],  NULL AS [ValueMIN],  NULL AS [ValueMAX]     FROM dbo.[OOLVelden] [OV]     WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (184,190,37,17,19,22,23,182,241,25)  GROUP BY [VeldId], [Waarde] UNION SELECT  [VeldId],  NULL AS [Value],  MIN([Waarde]) AS [ValueMIN],  MAX([Waarde]) AS [ValueMAX]     FROM (SELECT  [VeldId],  TRY_CAST([Waarde] AS INT) AS [Waarde]     FROM dbo.[OOLVelden] [OV]     WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (135,18,26)) [OV]  GROUP BY [VeldId] UNION SELECT  12,  NULL AS [Value],  MIN([R].[Bouwjaar]) AS [ValueMIN],  MAX([R].[Bouwjaar]) AS [ValueMAX]     FROM [R] UNION SELECT  14,  NULL AS [Value],  MIN(CAST([Prijs] AS INT)) AS [ValueMIN],  MAX(CAST([Prijs] AS INT)) AS [ValueMAX]     FROM [R] UNION SELECT  1,  [ModelId],  NULL AS [ValueMIN],  NULL AS [ValueMAX]     FROM [R] ORDER BY 1, 2; SELECT  DISTINCT  [R].[DebiteurId]     FROM (SELECT  DISTINCT  [DebiteurId]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[RecordId] In (Select [RM].[RecordId] FROM @RM [RM])) [R]; SELECT  [R].[DeelId],  [R].[SoortId],  COUNT(*) AS [Aantal]     FROM (SELECT  [R].[DeelId],  [R].[SoortId],  [R].[RecordId],  [R].[DebiteurId]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK FORCESEEK)     WHERE [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] IN ('8810X', '8813X', '8814X') AND [R].[RecordId] IN (SELECT  [OT].[RecordId]     FROM dbo.[OOLEnginecodes] [OT] WITH (NOLOCK)     WHERE [OT].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodeEngine] [CT]     WHERE [CT].[Code] LIKE '6000%'))) [R]  GROUP BY [R].[DeelId], [R].[SoortId]" }, "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": { "25137062": 1, "25137141": 2 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "France", "CountryId": 250, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

{ "Data": { "SessionId": 6, "Match": null, "Timestamp": "2026-08-18T15:18:03.9040061+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/1cd/piece/boitier-papillon/id-piece/17675294/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/1cd/piece/boitier-papillon/id-piece/17675294/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/1cd/piece/boitier-papillon/id-piece/17675294/" ], "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-18T15:18:05.3883747+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/dtr/piece/condenseur-de-climatisation/id-piece/25626983/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/dtr/piece/condenseur-de-climatisation/id-piece/25626983/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/dtr/piece/condenseur-de-climatisation/id-piece/25626983/" ], "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-18T15:18:08.8995112+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/m16a/piece/boite-de-vitesses/id-piece/22840934/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/m16a/piece/boite-de-vitesses/id-piece/22840934/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/m16a/piece/boite-de-vitesses/id-piece/22840934/" ], "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-18T15:18:12.1707006+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/ahr/piece/injecteurs/id-piece/23005243/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/ahr/piece/injecteurs/id-piece/23005243/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/ahr/piece/injecteurs/id-piece/23005243/" ], "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-18T15:18:13.9363324+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/entrepot/code-moteur/79/piece/echappement-silencieux-arriere/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/entrepot/code-moteur/79/piece/echappement-silencieux-arriere/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/entrepot/code-moteur/79/piece/echappement-silencieux-arriere/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @RM TABLE ([RecordId] BIGINT NOT NULL, [xPR] DECIMAL(9, 2), [xPS] BIT NOT NULL, [xPD] INT, [xTP] DECIMAL(5, 2) NOT NULL, [xTT] INT NOT NULL, [xShopState] INT, [xShippingState] TINYINT, [Match] INT, [XChange] BIT, [xPF] DECIMAL(9, 2), [xPE] DECIMAL(9, 2), [xPI] DECIMAL(9, 2) PRIMARY KEY CLUSTERED (RecordId ASC)) INSERT INTO @RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [Match], [XChange], [xPF], [xPE], [xPI]) SELECT  *,  CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 1 THEN CAST([xPF] / ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPE],  CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 0 THEN CAST([xPF] * ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPI]     FROM (SELECT  *,  CASE WHEN [xPS] = 1 AND [xPR] IS NOT NULL THEN CAST(CASE WHEN [xPD] IS NOT NULL THEN (CAST((100 - ISNULL([xPD], 0)) AS DECIMAL) / 100) * [xPR] ELSE [xPR] END AS DECIMAL(10, 2)) END AS [xPF]     FROM (SELECT  [R].[RecordId],  (ISNULL(CASE WHEN [R].[Shop] = 1 THEN ISNULL([R].[PriceShop],ROUND ( [R].[Prijs] * ((100 + ISNULL([D].[ShopPricePercentage], 0)) / 100), 2)) END, [R].[Prijs])) AS [xPR],  CASE WHEN [R].[PrijsTonen] IS NOT NULL THEN [R].[PrijsTonen] WHEN [R].[SoortId] = 0 THEN [D].[OOLPrijzenG] WHEN [R].[SoortId] = 1 THEN [D].[OOLPrijzenR] WHEN [R].[SoortId] = 2 THEN [D].[OOLPrijzenN] ELSE 1 END AS [xPS],  (SELECT [T].[Discount] FROM dbo.[AutomatePartDiscount] [T] WHERE [T].[SupplierId] = [R].[DebiteurId] AND [T].[StateId] = [R].[SoortId] AND [T].[PartAutomateId] = [R].[DeelId]) AS [xPD],  ISNULL([VT].[General], 21) AS [xTP],  CASE WHEN [R].[SoortId] = 0 AND NOT ISNULL([R].[PrijsSoort], 0) = 1 THEN 2 WHEN [D].[OOLPrijzenExcl] = 0 THEN 1 ELSE 0 END AS [xTT],  CASE WHEN NOT [D].[ShopActive] = 1 THEN 11 ELSE dbo.fnGetOOLShopStateQuick([R].[RecordId], 1, 5, xShippingState) END AS [xShopState],  xShippingState AS [xShippingState],  NULL AS [Match],  CASE WHEN [RM].[xPM] = 4 THEN 1 END AS [XChange]     FROM (SELECT  [RM].[RecordId],  MAX([RM].[xPM]) AS [xPM]     FROM (SELECT  [R].[RecordId],  10 AS [xPM]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[DeelId] IN ('8815X') AND [R].[RecordId] IN (SELECT  [OT].[RecordId]     FROM dbo.[OOLEnginecodes] [OT] WITH (NOLOCK)     WHERE [OT].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodeEngine] [CT]     WHERE [CT].[Code] LIKE '79%')) 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, 101444, 111111, 123456, 123457, 123462) UNION SELECT  [R].[RecordId],  4 AS [xPM]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] = '8815X' AND ([R].[RecordId] IN (SELECT  [OX].[RecordId]     FROM dbo.[OOLXchg] [OX] WITH (NOLOCK)     WHERE [OX].[CollectionId] IN (SELECT  [DX].[CollectionId]     FROM dbo.[DebtorXchgEnginecode] [DX]     WHERE [DX].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodeEngine] [CT]     WHERE [CT].[Code] LIKE '79%'))))) [RM]  GROUP BY [RM].[RecordId]) [RM]  LEFT JOIN dbo.[OOLInternet] [R] ON [R].[RecordId] = [RM].[RecordId]   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)   LEFT JOIN [Basis].dbo.[CountryVatRate] [VT] ON [VT].[CountryId] = [D].[LandId] AND [VT].[Active] = 1  OUTER APPLY (SELECT dbo.fnGetOOLShippingStateExtended([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 250, NULL) [xShippingState]) [SHS]) [R]) [R]; SELECT  [R].[DeelId],  [R].[SoortId],  COUNT(*) AS [Aantal]     FROM (SELECT  [R].[DeelId],  [R].[SoortId],  [R].[RecordId],  [R].[DebiteurId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) [R]  GROUP BY [R].[DeelId], [R].[SoortId]; SELECT  [R].*,  [xTP] AS [PrijsTaxPerc],  [xPD] AS [PrijsKorting],  (SELECT [VIBM].[Bouwmaand] FROM dbo.[VOLInternet] [VIBM] WHERE [VIBM].[RecordId] = [R].[AutoRecordId]) AS [ConstructionMonth],  [xPE] AS [PrijsAlt],  STUFF((SELECT '|' + CAST([V].[VeldId] AS VARCHAR(10)) + '^' + [V].[Waarde] FROM (SELECT [V].[VeldId], [V].[Waarde], [V].[OrderId] FROM dbo.[OOLVelden] [V] WHERE [V].[RecordId] = [R].[RecordId] AND [V].[VeldId] IN (26, 230, 231, 232)) [V] ORDER BY [V].[VeldId], [V].[OrderId] FOR XML PATH('')), 1, 1, '') AS [Automate2Velden],  CASE WHEN [R].[GarantieToelichting] IS NOT NULL THEN (SELECT TOP 1 [TV].[Translation] FROM [Storage].dbo.[TranslateTextResult] [TV] WHERE [TV].[TextId] = (SELECT [TR].[TextId] FROM [Storage].dbo.[TranslateTextRecord] [TR] WHERE [TR].[RecordId] = [R].[RecordId] AND [TR].[TextTypeId] = 2) AND [TV].[LanguageId] IN (5, 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 (5, 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] = 5 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 5 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] = 5), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 5), '')) 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] = 5 AND [XVT].[Waarde] = [XOV].[Waarde] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 17 ORDER BY [XOV].[OrderId] FOR XML PATH('')), 1, 1, '') AS [17],  CASE WHEN [XChange] = 1 THEN ISNULL([R].[Motorcodes] + '|', '') + ISNULL((SELECT TOP 1 [CT].[Code] FROM dbo.[OOLXchg] [X] LEFT JOIN dbo.[DebtorXchgEnginecode] [XP] ON [XP].[CollectionId] = [X].[CollectionId] LEFT JOIN dbo.[CodeEngine] [CT] ON [CT].[Id] = [XP].[CodeId] WHERE [X].[RecordId] = [R].[RecordId] AND [CT].[Code] LIKE '79%'), '79') ELSE [R].[Motorcodes] END AS [108],  TRY_CAST([18] AS INT) AS [18],  [V19].[NaamLang] AS [19],  CASE WHEN [22] = '2' THEN '2 portes' WHEN [22] = '4' THEN '4 portes' WHEN ISNULL([22], '') = '' THEN NULL ELSE [22] END AS [22],  [V23].[NaamLang] AS [23],  CASE WHEN [182] = 'R' THEN 'Droite' WHEN [182] = 'L' THEN 'Gauche' WHEN [182] = 'M' THEN 'Milieu' WHEN ISNULL([182], '') = '' THEN NULL ELSE [182] END AS [182],  (SELECT TOP 1 [XOV].[Waarde] FROM dbo.[OOLVelden] [XOV] WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 241 ORDER BY [XOV].[OrderId]) AS [241],  TRY_CAST([26] AS INT) AS [26],  [25],  [R].[Artikelnummers] AS [21],  ISNULL([D].[Bedrijfsnaam], '') + '|' + ISNULL([D].[BedrijfKort], '') AS [Leverancier],  [R].[BijzonderheidInet],  [R].[WarrantyText] AS [GarantieToelichting],  [R].[Shop],  [R].[Created],  [xShippingState] AS [ShippingState],  [R].[WarrantyConstruction] AS [WarrantyInstallation],  [R].[DeelId],  [R].[DebiteurRecordId],  [R].[AldocModelCode],  [R].[AldocTypeId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange],  [R].[SModelId],  [R].[ModelId],  [R].[PrijsSoort],  [R].[PriceShop]     FROM (SELECT  *     FROM (SELECT  [R].*,  [OV].[VeldId],  [OV].[Waarde]     FROM (SELECT  [R].[SortId],  [R].[RecordId],  [R].[DebiteurId],  [R].[ExternalId],  [R].[ReferenceId],  [R].[Youtube],  [R].[Fotos],  [R].[SoortId],  [R].[PrijsTonen],  [R].[Prijs],  [R].[Bouwjaar],  [R].[AutoRecordId],  [R].[Motorcodes],  [R].[Artikelnummers],  [R].[BijzonderheidInet],  [R].[WarrantyText],  [R].[Shop],  [R].[Created],  [R].[WarrantyConstruction],  [R].[DeelId],  [R].[DebiteurRecordId],  [R].[AldocModelCode],  [R].[AldocTypeId],  [R].[DebiteurLocatieId],  [R].[SModelId],  [R].[ModelId],  [R].[PrijsSoort],  [R].[PriceShop],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) AS [R]  LEFT JOIN dbo.[OOLVelden] [OV] WITH (INDEX(PK_OOLVelden)) ON [OV].[RecordId] = [R].[RecordId] AND [OV].[VeldId] IN (184, 190, 135, 37, 18, 19, 22, 23, 182, 241, 26, 25)) [R]  PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [18], [19], [22], [23], [182], [241], [26], [25])) AS [R]) [R]  LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V19] ON [V19].[VeldId] = 19 AND [V19].[Waarde] = [19] AND [V19].[LanguageId] = 5   LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 5   LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 5 AND [MOT].[Synoniem] = 0   LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 5   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) [R]  ORDER BY [SortId] DESC,  + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [RowId] ASC     OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY) [R]; WITH [R] AS (SELECT  [R].[RecordId],  [xPR],  [xPF],  [xPD],  [xPS],  [xPE],  [xPI],  [xTP],  [xTT],  [xShopState],  [xShippingState],  [XChange],  [Bouwjaar],  [xPI] AS [Prijs],  [ModelId]     FROM @RM [RM]  LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]   LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) SELECT  [VeldId],  [Waarde] AS [Value],  NULL AS [ValueMIN],  NULL AS [ValueMAX]     FROM dbo.[OOLVelden] [OV]     WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (184,190,37,17,19,22,23,182,241,25)  GROUP BY [VeldId], [Waarde] UNION SELECT  [VeldId],  NULL AS [Value],  MIN([Waarde]) AS [ValueMIN],  MAX([Waarde]) AS [ValueMAX]     FROM (SELECT  [VeldId],  TRY_CAST([Waarde] AS INT) AS [Waarde]     FROM dbo.[OOLVelden] [OV]     WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (135,18,26)) [OV]  GROUP BY [VeldId] UNION SELECT  12,  NULL AS [Value],  MIN([R].[Bouwjaar]) AS [ValueMIN],  MAX([R].[Bouwjaar]) AS [ValueMAX]     FROM [R] UNION SELECT  14,  NULL AS [Value],  MIN(CAST([Prijs] AS INT)) AS [ValueMIN],  MAX(CAST([Prijs] AS INT)) AS [ValueMAX]     FROM [R] UNION SELECT  1,  [ModelId],  NULL AS [ValueMIN],  NULL AS [ValueMAX]     FROM [R] ORDER BY 1, 2; SELECT  DISTINCT  [R].[DebiteurId]     FROM (SELECT  DISTINCT  [DebiteurId]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK)     WHERE [R].[RecordId] In (Select [RM].[RecordId] FROM @RM [RM])) [R]; SELECT  [R].[DeelId],  [R].[SoortId],  COUNT(*) AS [Aantal]     FROM (SELECT  [R].[DeelId],  [R].[SoortId],  [R].[RecordId],  [R].[DebiteurId]     FROM dbo.[OOLInternet] [R] WITH (NOLOCK FORCESEEK)     WHERE [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 101444, 111111, 123456, 123457, 123462) AND [R].[DeelId] IN ('8810X', '8813X', '8814X') AND [R].[RecordId] IN (SELECT  [OT].[RecordId]     FROM dbo.[OOLEnginecodes] [OT] WITH (NOLOCK)     WHERE [OT].[CodeId] IN (SELECT  [CT].[Id]     FROM dbo.[CodeEngine] [CT]     WHERE [CT].[Code] LIKE '79%'))) [R]  GROUP BY [R].[DeelId], [R].[SoortId]" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 1, "SizeMax": 150, "SetMax": false, "GetIndexMax": 1, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "6688128": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "France", "CountryId": 250, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

{ "Data": { "SessionId": 11, "Match": null, "Timestamp": "2026-08-18T15:18:19.26445+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/daj/piece/support-moteur/id-piece/19247335/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/daj/piece/support-moteur/id-piece/19247335/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/daj/piece/support-moteur/id-piece/19247335/" ], "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-18T15:18:21.0483143+02:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/hla/piece/injecteurs/id-piece/3928827/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/hla/piece/injecteurs/id-piece/3928827/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/hla/piece/injecteurs/id-piece/3928827/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": null, "CountryId": 0, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

Load

{ "Data": { "SessionId": 13, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": null, "CountryId": 0, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

LoadAlternatives

{ "Data": { "SessionId": 13, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": null, "CountryId": 0, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true }  }

Complete

{ "Data": { "SessionId": 13, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteCurrent": "/url_voorraad/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/stock-de-pieces-auto/composante/code-moteur/csub/piece/pompe-abs/id-piece/17371419/" ], "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 }  }