I'm using EE 1.7.3, and I'd like to know how many articles are present in my site (there are thousands, want an exact number). Where can I find this?

1 Answer 1


In the control panel go to Admin › Utilities › SQL Manager › Database Query Form

In the query form put

SELECT COUNT(*) FROM exp_weblog_titles;

This will give you the total number of entries on your site.

If you would like to know the number of entries in a specific Weblog you can do

SELECT COUNT(*) FROM exp_weblog_titles
WHERE weblog_id = X;

Just replace "X" with the weblog_id of the Weblog you are interested in.

An alternative to running MySQL queries in the control panel is to use an application like Sequel Pro or Navicat to browse your database and/or run these queries.

NOTE for EE v2.x users: alter the SQL by replacing "weblog" with "channel."

  • 3
    +1, If you want to only count those that are not closed you want to add AND status != "closed"
    – AllInOne
    Commented Jan 15, 2015 at 17:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.