Skip to content

Instantly share code, notes, and snippets.

@seanconklin

seanconklin/report-post-types.sql

Last active August 24, 2020 00:06
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 seanconklin/52e4f1ca5e4a53eb853c62f22bca122d to your computer and use it in GitHub Desktop.
Save seanconklin/52e4f1ca5e4a53eb853c62f22bca122d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
report-post-types.sql
SELECT post_type, count( post_type )
FROM wp_posts
GROUP BY post_type
ORDER BY count( post_type ) DESC
LIMIT 50;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment