Skip to content

Instantly share code, notes, and snippets.

@n8finch

n8finch/select_in_sql.sql

Created March 20, 2017 13:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save n8finch/ecfbba9bf559627ee50c8eedeff091c8 to your computer and use it in GitHub Desktop.
Save n8finch/ecfbba9bf559627ee50c8eedeff091c8 to your computer and use it in GitHub Desktop.
Download ZIP
SELECT in SQL
Raw
select_in_sql.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