SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'VIA') AND (U.number = 8329) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1583) 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 = 1606) 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 = 1613) 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 = 1700) 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 = 1861) 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 = 1918) 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 = 1968) 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 = 2004) 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 = 2006) 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 = 2050) 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 = 2086) 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 = 2132) 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 = 2326) 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 = 2400) 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 = 3274) 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 = 3553) 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 = 3643) 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 = 3813) 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 = 4078) 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 = 4481) AND (S.locationID = L.ID)
