Skip to content

Instantly share code, notes, and snippets.

@bigandy

bigandy/guids-for-template-list.sql

Created August 31, 2018 13:18
Show Gist options
  • Save bigandy/17a613cdac7fbfd313c851d111c8fd22 to your computer and use it in GitHub Desktop.
Save bigandy/17a613cdac7fbfd313c851d111c8fd22 to your computer and use it in GitHub Desktop.
Download ZIP
WordPress Get list of post guids for template type with SQL
Raw
guids-for-template-list.sql
SELECT
posts.guid
FROM wp_pswe_posts AS posts
JOIN wp_pswe_postmeta AS template ON posts.ID = template.post_id
WHERE template.meta_key='_wp_page_template'
AND template.meta_value='templates/vs-page-v4.php'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment