Profiles

Mentioned in [46878] on Core SVN:
Comments: Optimize the query for pending comments count in `wp_notify_moderator()` for better performance on large tables.

Created ticket #48514 on Core Trac:
Performance issue in COUNT query pluggable.php