Is there a way or a query that would allow me to search users based on their posts per day ratings?
Thank you,
Keith
Thank you,
Keith
vBulletin 3 is end of life and will not be receiving future development. Warning: vBulletin 3.8.11 is not compatible with PHP 7.2.0 or higher.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
Useful Links for Guests:
If you are having problems posting in the relevant areas for your software, please see this topic.
SELECT username, total_posts, first_post, day_count, (total_posts / day_count) AS posts_per_day FROM ( SELECT user.username AS username, user.posts AS total_posts, from_unixtime(post.dateline, "%Y-%m-%d") AS first_post, now(), datediff(now(),from_unixtime(post.dateline, "%Y-%m-%d")) AS day_count FROM user LEFT JOIN post ON user.userid = post.userid GROUP BY username ) AS wot ORDER BY posts_per_day DESC
Comment