Changeset 60981

Timestamp:

10/19/2025 09:42:39 PM (3 months ago)

Author:

peterwilsoncc

Message:

Users: Remove duplicate query generation from count_many_users_posts().

Removes duplicate code generating the WHERE clause and SQL query from the function.

Follow up to [60941].

Props spacedmonkey.
Fixes #63045.

File:

• trunk/src/wp-includes/user.php (modified) (1 diff)

trunk/src/wp-includes/user.php

@@ -700 +700 @@
 
     if ( false === $count ) {
-        $where  = get_posts_by_author_sql( $post_type, true, null, $public_only );
-        $result = $wpdb->get_results( "SELECT post_author, COUNT(*) FROM $wpdb->posts $where AND post_author IN ($userlist) GROUP BY post_author", ARRAY_N );
+        $result = $wpdb->get_results( $query, ARRAY_N );
 
         $count = array_fill_keys( $users, 0 );