{"id":1505950,"date":"2018-04-12T12:18:45","date_gmt":"2018-04-12T19:18:45","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/"},"modified":"2018-04-12T12:18:45","modified_gmt":"2018-04-12T19:18:45","slug":"mysql-query-to-output-all-event-venue-zip-codes","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/","title":{"rendered":"Mysql query to output all event venue zip codes?"},"content":{"rendered":"<p>Can anyone point me in the right direction to do a mysql query to list all the venue zip codes? I was surprised to see there is no export to csv functionality (maybe add this in the future?)<\/p>\n<p>Long story short, I need a csv listing the zipcodes of all the events on my site that were created with the events calendar tool. Hoping someone here can save me hours of digging in the code to try to figure it out.  Thanks!<\/p>\n","protected":false},"template":"","class_list":["post-1505950","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mysql query to output all event venue zip codes? -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mysql query to output all event venue zip codes? -\" \/>\n<meta property=\"og:description\" content=\"Can anyone point me in the right direction to do a mysql query to list all the venue zip codes? I was surprised to see there is no export to csv functionality (maybe add this in the future?) Long story short, I need a csv listing the zipcodes of all the events on my site [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/\",\"name\":\"Mysql query to output all event venue zip codes? -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2018-04-12T19:18:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Mysql query to output all event venue zip codes?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mysql query to output all event venue zip codes? -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/","og_locale":"en_US","og_type":"article","og_title":"Mysql query to output all event venue zip codes? -","og_description":"Can anyone point me in the right direction to do a mysql query to list all the venue zip codes? I was surprised to see there is no export to csv functionality (maybe add this in the future?) Long story short, I need a csv listing the zipcodes of all the events on my site [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/","name":"Mysql query to output all event venue zip codes? -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2018-04-12T19:18:45+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/mysql-query-to-output-all-event-venue-zip-codes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"Mysql query to output all event venue zip codes?"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1505950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1505950\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1505950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}