jeudi 5 mars 2015

SQL to export post meta and latitude/longitude from Geo Data Store plugin


I'm using Geo Data Store plugin to tag geo based posts. However I'm trying to export all my post titles and their corresponding lat/long from the GDS table.


I have little experience with SQL and was hoping someone would know where to turn?


Something a long the lines of:



SELECT * post_title FROM wp_posts WHERE post_type = 'type' AND 'lat' AND 'long' FROM wp_geodatastore WHERE post_id MATCHES




Aucun commentaire:

Enregistrer un commentaire