Task: Text to Code
Input (English): Step 1: For each row in Things table, find the corresponding rows in Timed_Status_of_Things table.
Step 2: find without repetition Things's thing_id, service_type_code of the results of step 1 whose Status_of_Thing_Code equals Close or Date_and_Date less than 2017-06-19 02:59:21
Output (English): SELECT DISTINCT T1.thing_id , T1.service_type_code FROM Things AS T1 JOIN Timed_Status_of_Things AS T2 ON T1.thing_id = T2.thing_id WHERE T2.Status_of_Thing_Code = "Close" OR T2.Date_and_Date < "2017-06-19 02:59:21"