Changeset 7698

Timestamp:

12/17/2013 11:15:43 PM (13 years ago)

Author:

johnjamesjacoby

Message:

Remove ignored DISTINCT from BP_XProfile_Group::get() queries. See #5303.

File:

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

trunk/bp-xprofile/bp-xprofile-classes.php

@@ -137 +137 @@
 
                 if ( !empty( $hide_empty_groups ) )
-                        $groups = $wpdb->get_results( "SELECT DISTINCT g.* FROM {$bp->profile->table_name_groups} g INNER JOIN {$bp->profile->table_name_fields} f ON g.id = f.group_id {$where_sql} ORDER BY g.group_order ASC" );
+                        $groups = $wpdb->get_results( "SELECT g.* FROM {$bp->profile->table_name_groups} g INNER JOIN {$bp->profile->table_name_fields} f ON g.id = f.group_id {$where_sql} ORDER BY g.group_order ASC" );
                 else
-                        $groups = $wpdb->get_results( "SELECT DISTINCT g.* FROM {$bp->profile->table_name_groups} g {$where_sql} ORDER BY g.group_order ASC" );
+                        $groups = $wpdb->get_results( "SELECT g.* FROM {$bp->profile->table_name_groups} g {$where_sql} ORDER BY g.group_order ASC" );
 
                 if ( empty( $fetch_fields ) )