Query Drupal Nodes By Type And Count

Mysql query to show the number of nodes of each type.

select type, count('nid') as count from node group by type;

Example

mysql> select type, count('nid') as count from node group by type;

+--------+--------------------------+
| count  | type                     |
+--------+--------------------------+
|     61 | article                  |
|      8 | event                    |
|     42 | page                     |
|   1684 | promo                    |
|    224 | recipe                   |
|    716 | video                    |
|     22 | webform                  |
+--------+--------------------------+