richaber/post-format-counts.md

Created January 23, 2023 17:03

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/richaber/4555f1c99f0bfc129e90baf241ca9fe9.js"></script>
Save richaber/4555f1c99f0bfc129e90baf241ca9fe9 to your computer and use it in GitHub Desktop.

Get count of posts for "non-standard" post formats in MySQL

Raw

    mysql> SELECT 
    ->     t1.slug, t2.count
    -> FROM
    ->     local.wp_terms AS t1
    ->         INNER JOIN
    ->     local.wp_term_taxonomy AS t2 ON t1.term_id = t2.term_id
    -> WHERE
    ->     t2.taxonomy = 'post_format';
+---------------------+-------+
| slug                | count |
+---------------------+-------+
| post-format-gallery |    51 |
| post-format-video   |   192 |
| post-format-link    |     0 |
+---------------------+-------+
3 rows in set (0.00 sec)

  