TRAINGEEK.CA | SIGHTINGS | CLASS 1 | SHORTLINES | MUSEUMS | DOCS |

SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'nbec') AND (U.number = 1867)

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 14) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 255) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 301) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 305) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 380) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 382) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 385) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 397) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 399) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 412) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 459) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 463) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 618) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 621) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 748) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 751) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 756) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 890) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1043) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1101) AND (S.locationID = L.ID) AND (S.dt >= '1998/1/1') AND (S.dt <= '2009/11/04')

Date/Time | Location | Prov | Train # | Comments |