Don't query all the users

git-svn-id: http://svn.automattic.com/wordpress-mu/trunk@1219 7be80a69-a1ef-0310-a953-fb0f7c49ff36

1 files changed, 11 insertions, 2 deletions

diff --git a/wp-includes/author-template.php b/wp-includes/author-template.php
index 795258d..adee80c 100644
--- a/wp-includes/author-template.php
+++ b/wp-includes/author-template.php
@@ -445,9 +445,18 @@ function wp_list_authors($args = '') {
 	$return = '';
 
 	/** @todo Move select to get_authors(). */
-	$authors = $wpdb->get_results("SELECT ID, user_nicename from $wpdb->users " . ($exclude_admin ? "WHERE user_login <> 'admin' " : '') . "ORDER BY display_name");
+ 	$users = get_users_of_blog(); 
+	$author_ids = array(); 
+	foreach ( (array) $users as $user ) { 
+		$author_ids[] = $user->user_id; 
+	} 
+	if ( count($author_ids) > 0  ) { 
+		$author_ids=implode(',', $author_ids ); 
+		$authors = $wpdb->get_results( "SELECT ID, user_nicename from $wpdb->users WHERE ID IN($author_ids) " . ($exclude_admin ? "AND user_login <> 'admin' " : '') . "ORDER BY display_name" ); 
+	} else { 
+		$authors = array(); 
+	} 
 
-	$author_count = array();
 	foreach ((array) $wpdb->get_results("SELECT DISTINCT post_author, COUNT(ID) AS count FROM $wpdb->posts WHERE post_type = 'post' AND " . get_private_posts_cap_sql( 'post' ) . " GROUP BY post_author") as $row) {
 		$author_count[$row->post_author] = $row->count;
 	}