Skip to content

Instantly share code, notes, and snippets.

@redroot

redroot/gist:3838739

Created October 5, 2012 08:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save redroot/3838739 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save redroot/3838739 to your computer and use it in GitHub Desktop.
Download ZIP
Wordpress: Find posts with a specific meta key
Raw
gistfile1.sql
# swap out 'videoid' for whichever meta keys you want
SELECT A.ID, B.post_id, A.post_title, A.post_date FROM
(SELECT ID,
post_date, post_title
FROM wp_posts
WHERE post_status = "publish"
) as A
JOIN
(SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE meta_key = "videoid") as B
ON A.ID = B.post_id
ORDER BY A.post_date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment