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 = 'nbsr') AND ((U.number >= 1) AND (U.number <= 9999)) GROUP BY Unit ORDER BY Unit
UnitCount
NBSR 21
NBSR 231790
NBSR 231874
NBSR 231962
NBSR 261032
NBSR 261232
NBSR 31
NBSR 37007
NBSR 370139
NBSR 370249
NBSR 370354
NBSR 37091
NBSR 37445
NBSR 37602
NBSR 37643
NBSR 37873
NBSR 37881
NBSR 40221
NBSR 544827
NBSR 547127
NBSR 553727
NBSR 63151
NBSR 63181
NBSR 67002
NBSR 84
NBSR 9061
NBSR 9111
NBSR 9131
NBSR 980166
NBSR 980261
NBSR 980338


Add a sighting