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

SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'cp') AND (U.number = 5756)

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 570) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1588) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1631) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1753) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 2096) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 2152) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 2293) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3016) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3467) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 4459) AND (S.locationID = L.ID) AND (S.dt >= '2000/1/1') AND (S.dt <= '2010/02/22')

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