Changeset 3023 for trunk/bp-core/bp-core-classes.php

Timestamp:

06/08/2010 05:38:06 PM (15 years ago)

Author:

apeatling

Message:

Remove unnecessary DISTINCT call to speed up query.

File:

• trunk/bp-core/bp-core-classes.php (modified) (1 diff)

trunk/bp-core/bp-core-classes.php

@@ -112 +112 @@
         $sql = array();
 
-        $sql['select_main'] = "SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email";
+        $sql['select_main'] = "SELECT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email";
 
         if ( 'active' == $type || 'online' == $type )