What is their distinct id and type?
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'
* I have left the chat *
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' and t1.date_and_date < '2017-06-19 02:59:21'