WP- DB – Extraction
all-scribbly coding design - layout general accidget counts — 1. Master overview: all post types + statuses SELECT post_type, post_status, COUNT(*) AS count FROM wp_posts GROUP BY post_type, post_status ORDER BY post_type, post_status; — 2. Just posts/pages by status SELECT post_type, post_status, COUNT(*) AS count FROM wp_posts WHERE post_type IN ('post', 'page') GROUP BY post_type, post_status ORDER BY post_type, post_status; — […]
WP- DB – Extraction Read More »