SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'CN') AND (U.number = 5725) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 216) AND (S.locationID = L.ID) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 219) AND (S.locationID = L.ID) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3485) AND (S.locationID = L.ID) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3911) AND (S.locationID = L.ID) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3914) AND (S.locationID = L.ID) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 4208) AND (S.locationID = L.ID) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 4421) AND (S.locationID = L.ID)