Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT in SQL
SELECT wp_term_relationships.term_taxonomy_id, wp_term_relationships.object_id, wp_postmeta.post_id, wp_postmeta.meta_key, wp_postmeta.meta_value
FROM wp_term_relationships
JOIN wp_postmeta
ON wp_postmeta.post_id=wp_term_relationships.object_id
WHERE term_taxonomy_id = 9 AND meta_key = 'issue_id' AND meta_value != 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment