Find total number of articles in Confluence

Finds the number of article pages in Confluence. The PREVVER field is a link back to the current page id, the current page has a NULL value in there.

mysql> select count(*) from CONTENT where CONTENTTYPE='PAGE' and isnull(PREVVER);
+----------+
| count(*) |
+----------+
|     1413 |
+----------+
1 row in set (0.01 sec)

The different types can be found using:

mysql> select CONTENTTYPE from CONTENT group by CONTENTTYPE;
+-------------------+
| CONTENTTYPE       |
+-------------------+
| BLOGPOST          |
| COMMENT           |
| DRAFT             |
| GLOBALDESCRIPTION |
| MAIL              |
| PAGE              |
| SPACEDESCRIPTION  |
| USERINFO          |
+-------------------+
8 rows in set (0.01 sec)