CREATE TABLE Timed_Status_of_Things (thing_id VARCHAR(255), Status_of_Thing_Code VARCHAR(255), Date_and_Date VARCHAR(255)); CREATE TABLE Things (thing_id VARCHAR(255), Type_of_Thing_Code VARCHAR(255))
What are the distinct id and type of the thing that has the status 'Close' or has a status record before the date '2017-06-19 02:59:21'
    
SQL: SELECT DISTINCT T2.thing_id, T2.Type_of_Thing_Code FROM Timed_Status_of_Things AS T1 JOIN Things AS T2 ON T1.thing_id = T2.thing_id WHERE T1.Status_of_Thing_Code = 'Close' OR T1.Date_and_Date < '2017-06-19 02:59:21'