Skip to:
Content

BuddyPress.org

Changeset 7698


Ignore:
Timestamp:
12/17/2013 11:15:43 PM (10 years ago)
Author:
johnjamesjacoby
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/bp-xprofile/bp-xprofile-classes.php

    r7564 r7698  
    137137
    138138        if ( !empty( $hide_empty_groups ) )
    139             $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" );
     139            $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" );
    140140        else
    141             $groups = $wpdb->get_results( "SELECT DISTINCT g.* FROM {$bp->profile->table_name_groups} g {$where_sql} ORDER BY g.group_order ASC" );
     141            $groups = $wpdb->get_results( "SELECT g.* FROM {$bp->profile->table_name_groups} g {$where_sql} ORDER BY g.group_order ASC" );
    142142
    143143        if ( empty( $fetch_fields ) )
Note: See TracChangeset for help on using the changeset viewer.