SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'cn') AND (U.number = 7059) SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 121) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 125) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 284) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 288) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 291) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 299) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 321) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 323) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 324) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 326) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03') SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 345) AND (S.locationID = L.ID) AND (S.dt >= '1999/1/1') AND (S.dt <= '2009/06/03')
