TRAINGEEK.CASIGHTINGSCLASS 1SHORTLINESMUSEUMSDOCS

Start Date/time
End Date/time
Reporting Mark
Unit Number
 
SELECT Concat(U.roadmark, ' ', U.number) AS Unit, COUNT(*) AS RecCnt FROM units U WHERE (U.roadmark = 'via') AND ((U.number >= 6400) AND (U.number <= 6499)) GROUP BY Unit ORDER BY Unit
UnitCount
VIA 64009
VIA 640116
VIA 64028
VIA 640320
VIA 640420
VIA 640516
VIA 640621
VIA 640716
VIA 640817
VIA 640921
VIA 641025
VIA 641120
VIA 641220
VIA 641312
VIA 641416
VIA 641526
VIA 641619
VIA 641712
VIA 641816
VIA 641912
VIA 642028
VIA 642121
VIA 64222
VIA 642418
VIA 64257
VIA 642618
VIA 642717
VIA 642817
VIA 642912
VIA 643122
VIA 643221
VIA 643310
VIA 643414
VIA 643510
VIA 643610
VIA 643710
VIA 643814
VIA 643912
VIA 644014
VIA 64419
VIA 644217
VIA 64438
VIA 64441
VIA 64458
VIA 644617
VIA 64485
VIA 644911
VIA 645111
VIA 645216
VIA 645313
VIA 64548
VIA 645511
VIA 645625
VIA 64576
VIA 645827
VIA 64597


Add a sighting