wp-admin/users.php does not show pages under "posts" column

[novasource]

For some reason, the SQL query in wp-includes/user.php that gets the count of a user's posts excludes pages, so /wp-admin/users.php will not show an accurate picture of a user's contributions. This makes no sense at all: 1. posts and pages are first-class content types in WordPress and 2. they are both stored in the same table.

Proposed solution: remove

AND post_type = 'post'

from function get_usernumposts in wp-includes/user.php.

This defect could result in incorrect interpretation of user activity, so marked as major severity.

Why should a Posts column include the page count too? - Afterall, Its a Posts column.

Should it include Attachments too? What about custom post types?

The other option, is to change it to list the contributions, Ie:
"Activity: 5 Posts, 1 Page, 50 Comments" inline with your other ticket: #10629

Why should a Posts column include the page count too? - Afterall, Its a Posts column.

Because a page and a post are both posts. They are both first-class content types in WordPress that are remarkably identical.

When I delete spam users, a heuristic is those with a strange email address, 0 posts, and 0 comments (they are spammed or deleted). But suppose a user has 3 pages but 0 posts? Right now his post count would be 0. Is that a spam user?

Should it include Attachments too?

Not sure that provides much value. Attachments are a piece of a page/post.

What about custom post types?

Not familiar enough with the custom post type ecosystem to comment.

The other option, is to change it to list the contributions, Ie: "Activity: 5 Posts, 1 Page, 50 Comments" inline with your other ticket: #10629

That consolidates all three counts in one field and makes it more difficult to scan large lists. In that other ticket, I also proposed a way to make a sparse matrix more usable--use a blank instead of a 0. This would defeat that significant usability improvement.

Closing as invalid.

The posts column on the users list is just that the number of posts a user has written and this works as designed.