SELECT * from inventory where hfdcat='2' and subcat='8' and catnr='3' and name='name' ORDER BY datetime DESC
Scania GRS 905
ZF Ecosplit 4 16S 2331 TD
Voith 864.3E
Mercedes-Benz G131-9
Mercedes-Benz G85-6
ZF Ecomat 2 6 HP 502 C
Mercedes-Benz GO210-6
Voith Turbo 854.3E
Voith Turbo 854.5
Voith Turbo Diwabus 854.5
Voith Turbo Diwabus 864.5
Eaton 8209
ZF ASTRONIC 12 AS 2130 TD
ZF S5-35/2
Volvo SR1900
Voith 854.3E
ZF S6-85
Mercedes-Benz GO 170 -6
ZF Ecolite 6 S 700 TO
Voith Diwabus 864.5
Iveco Eurocargo 2865.615699G99
ZF Ecomat 4 6 HP 504 C
Allison MT653
Mercedes-Benz G0190-6
Mercedes-Benz G04 160
Mercedes-Benz G0210-6
ZF 16 S 160 EPS
Mercedes-Benz G04/160-6/8,2
Mercedes-Benz G0170-6
Mercedes-Benz G100-12
Allison HT 750 DRD
Volvo SR1700
ZF Ecosplit 16 S 181 IT
Allison CLBT 750
[Other] ZF-Ecolife 6AP 1400B
ZF Ecolite S 6-85
ZF 16S160
ZF Ecolite S5-45
ZF Ecomat 2 6 HP 552 C
Iveco 2845.601 P99
Eaton FSO/4106B
ZF Ecosplit 16 S 151
Mercedes-Benz G210-16
ZF Ecomat 5 HP 600
ZF Astronic 12 AS 2301 IT
Mercedes-Benz G211-16
Voith Turbo 864.5
ZF ECOLITE 6 S 1600
ZF ECOMAT 5HP - 600
ZF ECOMID 6 S 150 C
Eaton Y08024 /100
ZF ECOSPLIT 16 S 151
Scania GR 801
Mercedes-Benz G04/160-6/718
Volvo R1700
ZF ECOMAT 4 6 HP 604 C
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
Spicer T5-X-2276
ZF Ecomat 2 6 HP 592C
Scania GRS 900R
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
ZF 16S181IT
ZF 16S151
Allison 07M14 TIDA
ZF Astronic 12 AS 2300 BIT
Voith 854.5
ZF 16 S 151
Scania GR801
ZF Ecolite 6S-1600 IT
ZF Ecomat 5HP-600
ZF 5HP500
ZF 8 S109
ZF 8 S 1600 IT
Voith Diwabus 864.3E
ZF Astronic 10 AS 2310
ZF Ecolite 6 S 1600
ZF Ecomat 2 5 HP 602C
ZF ECOMAT 2 5HP502C
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
Scania GR900R
ZF Ecomat 2 5HP-502C
ZF Ecomid 8 S180
Voith Diwabus 854.3E
ZF ECOMAT 5HP600
Scania GRS890
Allison HD3060
ZF 16S150
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
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
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 16S 181 IT
Mercedes-Benz G4
ZF ECOLITE 6S850
ZF 16S-130
ZF 6S-150 C
ZF NEW ECOSPLIT 16S 1920TD
Mercedes-Benz 715500
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
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
Scania GS771
Renault B18200.22
Iveco Astronic 16AS2200IT
Iveco Astronic 12AS-1800IT