{"id":3712,"date":"2024-03-28T13:50:37","date_gmt":"2024-03-28T21:50:37","guid":{"rendered":"https:\/\/crm270s.abramjmeister.com\/?p=3712"},"modified":"2024-03-28T13:50:37","modified_gmt":"2024-03-28T21:50:37","slug":"koreadaily-uniquephone","status":"publish","type":"post","link":"https:\/\/crm270s.mycpamytax.com\/?p=3712","title":{"rendered":"KoreaDaily UniquePhone"},"content":{"rendered":"\n<p class=\"has-white-color has-vivid-cyan-blue-background-color has-text-color has-background has-link-color wp-elements-1 wp-block-paragraph\"><strong>sorts out unique phone number from KoreaDaily comprehensive downloads:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT MIN(ID) AS min_ID, field9\nFROM combined_output_02\nGROUP BY field9\n<\/code><\/pre>\n\n\n\n<p class=\"has-white-color has-vivid-cyan-blue-background-color has-text-color has-background has-link-color wp-elements-2 wp-block-paragraph\"><strong>selects Unique phone:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from combined_output_02 where ID in (select min_ID from unique_phone)\n<\/code><\/pre>\n\n\n\n<p class=\"has-white-color has-vivid-cyan-blue-background-color has-text-color has-background has-link-color wp-elements-3 wp-block-paragraph\"><strong>AreaCode addition:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>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<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n","protected":false},"excerpt":{"rendered":"<p>sorts out unique phone number from KoreaDaily comprehensive downloads: selects Unique phone: AreaCode addition:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[26,42],"tags":[],"class_list":["post-3712","post","type-post","status-publish","format-standard","hentry","category-codes","category--yellowpage"],"_links":{"self":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/posts\/3712","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3712"}],"version-history":[{"count":0,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=\/wp\/v2\/posts\/3712\/revisions"}],"wp:attachment":[{"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crm270s.mycpamytax.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}