Looking Up Posts Per Page

[ShannonA]

I'd like to look up what percentage of our readers are viewing more than 10 posts per page on our forums. How to do so (presumably from within MySQL)?

Thanks!

[Seven Skins]

Try this query:

SELECT * FROM `user` WHERE `maxposts` > 10;

[ShannonA]

Well, that's unexpectedly easy. My eyes must have just passed right over that field. Thanks!

For anyone curious, the answer is 4% of our registered users, though I bet it's higher for active users.