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'
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'
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 '
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 = value or t1 . date_and_date < value
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 '