TRAINGEEK.CA
SIGHTINGS
CLASS 1
SHORTLINES
MUSEUMS
DOCS
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 = 'nbsr') AND ((U.number >= 1) AND (U.number <= 9999)) GROUP BY Unit ORDER BY Unit
Unit
Count
NBSR 2
1
NBSR 2317
90
NBSR 2318
74
NBSR 2319
62
NBSR 2610
32
NBSR 2612
32
NBSR 3
1
NBSR 3700
7
NBSR 3701
39
NBSR 3702
49
NBSR 3703
54
NBSR 3709
1
NBSR 3744
5
NBSR 3760
2
NBSR 3764
3
NBSR 3787
3
NBSR 3788
1
NBSR 4022
1
NBSR 5448
27
NBSR 5471
27
NBSR 5537
27
NBSR 6315
1
NBSR 6318
1
NBSR 6700
2
NBSR 8
4
NBSR 906
1
NBSR 911
1
NBSR 913
1
NBSR 9801
66
NBSR 9802
61
NBSR 9803
38
Add a sighting