SELECT * from inventory where hfdcat='2' and subcat='8' and catnr='2' and name='name' ORDER BY datetime DESC
Iveco Cursor 8
Renault Premium 385
Scania DSC 9 12
Volvo TD71A
MAN D2566
Cummins NT 335 BI
Mercedes-Benz OM442LA
Mercedes-Benz OM423
Caterpillar C 7 Acert
Mercedes-Benz OM 422
Iveco Eurotrakker 340
Iveco Eurotrakker 380
DAF RS 222 L
Deutz BF6L913
Deutz F4L912
Deutz F6L812
Cummins 6T-590
Deutz F3L912
Deutz F6L912
Deutz BF6L913T
Iveco Cursor 13
Mercedes-Benz OM442A
Mercedes-Benz OM422A
Mercedes-Benz OM442
Mercedes-Benz OM421
Mercedes-Benz OM443
Iveco 8240
Iveco 8210
Mercedes-Benz OM441
Iveco Cursor 8 F2BE0681B
Iveco Turbostar 190.38
Iveco Turbostar 190-360
Volvo D7E
Deutz F6L413FR
Deutz F6L914
Komatsu S6D125-1
Renault DXI13
DAF WS 268 M
DAF PE 183 C1
Caterpillar 3116
DAF WS 315 M
Doosan 6 CIL
Doosan P158 LE
Iveco 8280
Volvo F10
Caterpillar 3306 PC
Volvo Penta TD71A
Perkins 2000 Series
John Deere 6068 HF285E
Scania DS1406
Liebherr D 906 T
Deutz F8L413F
MAN D2866LF290
Cummins DAF 45
Paccar PE228C
MAN D2866 LF 28 LOH
Cummins ISBE220.31
MAN D2866LF09
Scania DC1602
Mercedes-Benz OM421A
Deutz TCD 2015 V08
Scania DSC 1201
Mercedes-Benz OM352A
Iveco CURSOR 8 F2BE0681C
Paccar PR228U1
DAF XE315C1
MAN D2840LF06
Iveco EUROSTAR 8210
DAF DKS1160
Cummins ISB6.7E5250B
DAF DHS 825
MAN D2866LOH28
MAN D2866LF20
Iveco Eurotech 8460
Scania D11
Cummins ISBE 6.7 E4B
Cummins ISBE 6.7 I
Paccar PR 228S2
MAN D2865LF24
Deutz BF12L413F
Iveco Cursor 10
Cummins 6T830
Scania DC9.29
Renault Premium 400
Mercedes-Benz OM501LA.111/11-00
Deutz BF4L913
Paccar GR 165 U1
Deutz BF6M1013
Deutz F6L912W
Liebherr D 904 N A
Cummins 6BT 5.9
Deutz F2L912
Paccar PR183S2
Caterpillar 3306 D ITA
Deutz F5L912
Cummins ISBE5-225B
Deutz F6L413F
Cummins 4T390
Volvo Penta TD121G
Renault FR340
DAF NT133
Scania DC 09
Scania DSC 1415
DAF DH 825
Deutz BFM1012
Iveco Tector F4AE3481B*S103
Mercedes-Benz OM501LA.11/6-00
DAF DHR 825
Paccar PR 183 S3
Deutz TCD2013L064V
Renault Premium 300
Mercedes-Benz OM906LA.11/2-00
DAF 825
Renault 400
Renault G340
MAN D2866LOH23
Deutz BF8L513
Deutz TCD 2013L06 4V
Deutz BF4M1012
Mercedes-Benz OM906LA.111/2-00
Caterpillar 3412
Mercedes-Benz OM457LA
Deutz F6L413W
Cummins LT10-C-225
DAF PE265C
Mercedes-Benz OM457HLA.111/6-00
MAN D0836
DAF PE 183C1
DAF PE 183C
MAN D0836 LOH02
Komatsu S6D105-B-1
Mercedes-Benz OM904LA
Iveco Cursor 10 F3BE06810
Mercedes-Benz OM 404.1
DAF PE228C
Scania DS902
MAN D0836LOH
Mercedes-Benz OM906LA.111/4-00
MAN D0826
Mercedes-Benz OM501LA 11/6-00
Paccar PR228S1
DAF PE183C1
Mercedes-Benz OM501LA111/12-00
Cummins 6T-830
Renault Premium 420 DCI
Mercedes-Benz OM402LA.1/3
DAF WS315M
Mercedes-Benz OM501LA
Deutz F6L413
MAN D0826LOH17
MAN D2866LOH
DAF WS268M
Renault Midliner 160
Renault FR385
Mercedes-Benz OM447
Scania DC901
Mercedes-Benz OM904LA.1V/3-90
Mercedes-Benz OM904LA.111/6-00
Mercedes-Benz 904LA.11/3-00
MAN D2866LUH24
Mercedes-Benz OM457HLA
DAF WS268L
Renault Midliner
Renault G 340
Deutz 1013C
Volvo D12A380 EC96
Scania DC902
MAN TGA 460
Pegaso 360
Mercedes-Benz OM906HLA.11/2-01
Mercedes-Benz OM401LA
Volvo DH12D 340 EC01
MAN D2865LOH05
Volvo D7C
Mercedes-Benz OM 442 A
Mercedes-Benz OM 442A
Mercedes-Benz OM 442
Mercedes-Benz OM457
MAN 2565
Iveco 8460
Deutz F8L413 F
DAF 75
Cummins ISBE
MAN D0826LUH12
Mercedes-Benz OM 441 LA
Mercedes-Benz MO 441 LA
MAN 414
Mercedes-Benz OM447 turbo
Mercedes-Benz OM 447 HLA .1/1
Mercedes-Benz OM 401 0105600 80
MAN D0826 LUH03
MAN D0826 LUH 06
Mercedes-Benz OM 447 HLA 1/1
MAN D2866LF31
Iveco CURSOR F3AE0681D
Mercedes-Benz OM 403
Mercedes-Benz OM 402
MAN D2865LF02
MAN D2865
Mercedes-Benz 1840
Volvo D12A380 185 EC96
MAN D2866F
MAN D0826L0H07
MAN D2556MF
MAN D08226
MAN D2866 D2566
Mercedes-Benz OM447 OM447LA
Mercedes-Benz OM 402 MET ZF VERSNELLINGSBAK
MAN 19.414
MAN 19.403
MAN 26.320
MAN 18.256