mustardBees/post_types.sql

Created October 26, 2022 08:15

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mustardBees/2df3170a5d1a41a6ec34114e4a56fe8d.js"></script>
Save mustardBees/2df3170a5d1a41a6ec34114e4a56fe8d to your computer and use it in GitHub Desktop.

Download ZIP

WordPress SQL query to return a count of each post type.

Raw

post_types.sql

	SELECT
	post_type,
	count(*)
	FROM
	wp_posts
	GROUP BY
	post_type
	HAVING
	count(*)
	ORDER BY
	count(*) DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment