navitronic

SQL snippet to get an overview of the types of content in your wp_posts table.

SELECT post_type, COUNT(*) AS total
FROM wp_posts GROUP BY post_type;