KoreaDaily UniquePhone

sorts out unique phone number from KoreaDaily comprehensive downloads:

SELECT MIN(ID) AS min_ID, field9
FROM combined_output_02
GROUP BY field9

selects Unique phone:

select * from combined_output_02 where ID in (select min_ID from unique_phone)

AreaCode addition:

select combined_output_02_unique_phone.* , AreaCode_TimeZone.StandardTimeZone from combined_output_02_unique_phone LEFT join AreaCode_TimeZone on combined_output_02_unique_phone.AreaCode = AreaCode_TimeZone.AreaCode

---