SELECT * from inventory where hfdcat='2' and subcat='8' and catnr='3' and name='name' ORDER BY datetime DESC
Voith Turbo 854.5
Scania GR 801
Volvo R1700
ZF ECOLIFE 6 AP 1200 B
ZF ECOLIFE 6 AP 1400 B
ZF ECOMAT 4 6 HP 604 C
Voith Turbo 864.5
Allison 2000 Series
Mercedes-Benz W4B 110/3,6 RN
ZF ECOMID 8S180
ZF 16S190
ZF S 6-90
ZF ECOMAT 4 6HP 554C
ZF S6-90
ZF New Ecosplit 16S2520 TO
ZF Ecomat 4 5 HP 504C
Spicer T5-X-2276
ZF Ecomat 2 6 HP 592C
Scania GRS 900R
ZF Ecomat 2 6 HP 502 C
ZF Ecolife 6 AP 2000 B
ZF Ecolite 6 S 1600 BO
Scania GRS 900S
Iveco 2895.911F99
ZF ECOSPLIT 16S181 IT
ZF 16S130
Allison EV50 09L10
ZF Ecomat 2 6 HP 502C
Voith 864.3E
ZF 16S181IT
ZF 16S151
ZF Ecomat 4 6 HP 594C
Allison 07M14 TIDA
Voith Turbo 854.3E
ZF Astronic 12 AS 2300 BIT
ZF ECOLITE 6 AS 1000 TO
Voith 854.5
ZF 16 S 151
Scania GR801
ZF Ecolite 6S-1600 IT
ZF 6 S 700
ZF Ecomat 5HP-600
ZF 5HP500
ZF 8 S109
ZF 8 S 1600 IT
Voith Diwabus 864.3E
ZF Astronic 10 AS 2310
Mercedes-Benz G85-6
ZF Ecolite 6 S 1600
ZF Ecomat 2 5 HP 602C
ZF ECOMAT 2 5HP502C
Mercedes-Benz G0210-6
ZF Ecomat 2 6HP502C
ZF Ecolite S 5-42
MAN G 172 Z
ZF 5S - 111GP
[Other] GETRAG 2478507 KZ 304/22
[Other] GETRAG 42026684KZ395/20
ZF 5S-110GP
ZF 4S-120GP + Z90/2
Allison HD 3000 P
Voith Turbo Diwabus 854.5
Scania GR900R
ZF Ecolite 6 S 1900 IT B0
ZF Ecomat 2 5HP-502C
ZF Ecomid 8 S180
Voith Diwabus 854.3E
ZF ECOMAT 5HP600
Scania GRS890
DAF Den Oudsten
Allison HD3060
ZF 16S150
Leyland GB 340/6
ZF Ecosplit 16S221
ZF 8S180IT
ZF Ecomat 2 5 HP-592C
ZF Ecomat 6HP-592 C
ZF ECOSPLIT 16 S 181
ZF 12 AS 1931 TD
ZF Astronic 12 AS 1931 TD
ZF 6S150C. AVS
Mercedes-Benz G04 160
ZF ECOLITE S5-42
Mercedes-Benz G4/65-6/9.0
ZF ECOMAT 5HP500
ZF 16S221IT
ZF ECOMID 8 S 140 IT
ZF ECOLITE S 6 1600 IT
ZF 6S150 C
ZF 8S180
ZF ECOMID 8 S 180
Allison transmission AT 542
Allison Transmisson 1000
ZF New Ecosplit 16S2220TD
Eaton RTSO17316A
ZF Astronic 12AS 1931 TD
ZF ECOMAT 2 6HP592C
Voith Turbo Diwabus 864.3E
ZF Astronic
[Other] DANA Spicer Off Highway 13.7LHR32384-630
Volvo G 8 E.G.S.
ZF ECOMAT 2 5HP502 C
ZF ECOMAT 2 5 HP 502C
ZF ECOLITE S 6-85
ZF New Ecosplit 16S151 IT
ZF 8 S 180 IT
Mercedes-Benz G211 - 16
Mercedes-Benz G04/160 IT
ZF ECOMAT 5HP590
ZF 8S-180IT
ZF Astronic 12 AS 1800 IT
ZF ECOMAT 2
ZF Ecolite 6S850
ZF 8S 180
Mercedes-Benz VG1700
ZF S 6 - 85
ZF S6-66
ZF ZF
ZF Ecolite S 6-85
ZF 16S 181 IT
Mercedes-Benz G4
Mercedes-Benz G211-16
ZF ECOLITE 6S850
ZF 16S-130
ZF 6S-150 C
ZF NEW ECOSPLIT 16S 1920TD
Mercedes-Benz 715500
Mercedes-Benz G210-16
ZF 8S180 IT
ZF 8S-180
MAN ZF ECOSPLIT 16S181 IT
ZF 16S109
Scania GR870
Mercedes-Benz DAF MAN SCANIA VOLVO IVECO RENAULT MAGIRU MISCELLA
ZF UNKNOWN
Magirus 45625
ZF MERCEDES
ZF G800
Mercedes-Benz VG200003W 1436
Mercedes-Benz VG24003 W1448
Mercedes-Benz VG8503/WI
Mercedes-Benz VG 1400 W
Mercedes-Benz VG1150/3 WI
Mercedes-Benz VG
Mercedes-Benz 1619
Mercedes-Benz VG2000/3 W1436
Magirus 4X4
Magirus 120GP-110
ZF VG250-2
ZF AKG-55 / VG800-2
Volkswagen MAN
ZF S6-36
ZF S5-24-3
Iveco 000028046
Mercedes-Benz G3-90 GP
Mercedes-Benz G3-90
ZF S6-90 INTARDER
ZF ECOSPLIT 16S 130
ZF 16S110
Scania GRS900 INTARDER
Mercedes-Benz AKG4.110-6.90
Mercedes-Benz AKG4.95-7.110
Mercedes-Benz AKG4
Mercedes-Benz G135-16
Eaton TF6362E17G4
CAPPELLOTTO OM81
ZF ECOSPLIT 16S181
ZF ECOSPLIT 16S151 IT
ZF ECOSPLIT 16S151
ZF ECOMID 16S109
ZF 16S130 STEYR
ZF 12AS1631TD
ZF 16S181
ZF Ecosplit 16S130
Scania GR871 Retarder
Renault B13
Mercedes-Benz G211 EPS
Mercedes-Benz G135 Eps handgeschakeld
Mercedes-Benz G 155 EPS
Mercedes-Benz G 135 EPS
ZF ecosplit 16S181IT
ZF ecosplit 16S151IT
ZF Ecosplit 16S151
ZF 9S109
Volvo SR1900
Scania GS771
Renault B18200.22
Iveco Astronic 16AS2200IT
Iveco Astronic 12AS-1800IT