SELECT * from inventory where hfdcat='2' and subcat='8' and catnr='2' and name='name' ORDER BY datetime DESC
Iveco FAE3681A*S
Paccar MX340.U1
Scania R480 XPI DC1307
Deutz F4L913
Cummins ISBE 220 31
Cummins ISBE4 225B
Paccar PR265U1
DAF XE 315 C1
MAN D0836LOH50
DAF PE 228 C
MAN D2876LF01
Mercedes-Benz OM904LA.V/2-01
Deutz F6L912
Mercedes-Benz OM906LA.V/3-01
Renault Midliner 160
Renault Saviem
Renault Midliner 210
Renault Midliner 180
Mercedes-Benz OM906LA.111/4-00
Mercedes-Benz OM441A
Volvo D12A420 EC93
Cummins ISBE220 31
Paccar PR 228 S2
Iveco Tector N6OENTC22 00A017
Iveco Tector F4AE3481 B*U100
Iveco Tector F4AE3481
MAN D2876
Scania DSC 911
Scania DSC 913
Iveco Eurocargo 8061
MAN D0836 LOH51
MAN D0836 LOH60
Cummins ISBE 220
Volvo TD61
Mercedes-Benz OM 360
MAN D0836LF01
Mercedes-Benz OM 401
Mercedes-Benz OM 352
Volvo TD123 ES
Mercedes-Benz OM 402
Iveco Cursor 10 F3AE0681B-B371
Mercedes-Benz OM 422
Scania 113
Mercedes-Benz OM 404
Mercedes-Benz OM 403
Volvo THD 102 NF
Mercedes-Benz OM904LA
Iveco 8060 45B
Volvo D7C275 EC99
Cummins ISBE4 185
Mercedes-Benz OM 314
Iveco 8460
MAN D0836 LF03
Caterpillar C 7 Acert
Mercedes-Benz OM422A
Iveco Cursor 10
Renault DCI 11
Mercedes-Benz OM 441 LA 1/11
Mercedes-Benz OM 501 LA.11/1-00
MAN D2866LF20
Renault DCI 11 C+J01
Mercedes-Benz OM904LA.11/1-02
Volvo D9B 310 - EC06
MAN D2865LF
Renault Premium
Renault Premium 250
Renault Premium 340
Mercedes-Benz OM 441 LA
DAF DNT 620
DAF RS 222 L
Deutz BF6L913
Deutz F4L912
Deutz F3L912
Scania F95 DC9.29
MAN D2866LOH28
MAN D2866LOH22
Volvo Penta TAD 720 VE
John Deere M 53 ZC
Deutz F4L912W
MAN D2866LF09
MAN D2866
Mercedes-Benz OM906 LNG
Mercedes-Benz OM423
Mercedes-Benz OM442A
Iveco 8240
Volvo D7A285 EC96
Iveco Cursor 8 F2BE3682_*S001
Cummins ISBE4-225B
Cummins ISBE220.31
Mercedes-Benz OM355
Scania DSC11
Deutz BF4L913
Iveco Cursor 8
Renault Premium 385
Volvo TD71A
MAN D2566
Cummins NT 335 BI
Mercedes-Benz OM442LA
Deutz F6L812
Deutz BF6L913T
Iveco Cursor 13
Mercedes-Benz OM442
Mercedes-Benz OM421
Mercedes-Benz OM443
Iveco 8210
Iveco Cursor 8 F2BE0681B
Iveco Eurotrakker 340
Iveco Turbostar 190.38
Iveco Turbostar 190-360
Volvo D7E
Deutz F6L413FR
Deutz F6L914
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
Liebherr D 906 T
Deutz F8L413F
MAN D2866LF290
Cummins DAF 45
Paccar PE228C
MAN D2866 LF 28 LOH
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
Cummins ISB6.7E5250B
DAF DHS 825
Iveco Eurotech 8460
Scania D11
Cummins ISBE 6.7 E4B
Cummins ISBE 6.7 I
Paccar PR 228S2
MAN D2865LF24
Deutz BF12L413F
Scania DC9.29
Renault Premium 400
Paccar GR 165 U1
Deutz BF6M1013
Deutz F6L912W
Liebherr D 904 N A
Cummins 6BT 5.9
Deutz F2L912
Paccar PR183S2
Deutz F5L912
Cummins ISBE5-225B
Deutz F6L413F
Cummins 6T-590
Renault FR340
DAF NT133
Scania DC 09
DAF DH 825
Deutz BFM1012
Iveco Tector F4AE3481B*S103
DAF DHR 825
Paccar PR 183 S3
Deutz TCD2013L064V
Renault Premium 300
Mercedes-Benz OM441
Mercedes-Benz OM906LA.11/2-00
DAF 825
Renault 400
Renault G340
MAN D2866LOH23
Deutz BF8L513
Deutz TCD 2013L06 4V
Mercedes-Benz OM906LA.111/2-00
Caterpillar 3412
Deutz F6L413W
Cummins LT10-C-225
Mercedes-Benz OM457LA
Mercedes-Benz OM457HLA.111/6-00
DAF PE 183C1
Komatsu S6D105-B-1
Iveco Cursor 10 F3BE06810
Mercedes-Benz OM 404.1
DAF PE228C
Scania DS902
MAN D0836LOH
MAN D0826
Paccar PR228S1
Mercedes-Benz OM402LA.1/3
DAF WS315M
Deutz F6L413
MAN D2866LOH
DAF WS268M
Renault FR385
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
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
Deutz F8L413 F
DAF 75
Cummins ISBE
MAN D0826LUH12
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
Mercedes-Benz OM447
MAN D2866LF31
Iveco CURSOR F3AE0681D
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