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 641417
VIA 641526
VIA 641619
VIA 641712
VIA 641816
VIA 641912
VIA 642029
VIA 642121
VIA 64222
VIA 642418
VIA 64257
VIA 642619
VIA 642717
VIA 642817
VIA 642912
VIA 643122
VIA 643221
VIA 643310
VIA 643414
VIA 643510
VIA 643612
VIA 643711
VIA 643814
VIA 643912
VIA 644014
VIA 644110
VIA 644217
VIA 64439
VIA 64441
VIA 64458
VIA 644617
VIA 64486
VIA 644911
VIA 645111
VIA 645216
VIA 645314
VIA 64548
VIA 645511
VIA 645627
VIA 64577
VIA 645829
VIA 64598


Add a sighting