Changeset 7324 for branches/1.8/bp-activity/bp-activity-classes.php
- Timestamp:
- 07/27/2013 06:09:57 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/1.8/bp-activity/bp-activity-classes.php
r7228 r7324 156 156 157 157 // Select conditions 158 $select_sql = "SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name";158 $select_sql = "SELECT DISTINCT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name"; 159 159 160 160 $from_sql = " FROM {$bp->activity->table_name} a LEFT JOIN {$wpdb->users} u ON a.user_id = u.ID"; … … 248 248 } 249 249 250 $total_activities_sql = apply_filters( 'bp_activity_total_activities_sql', "SELECT count( a.id) FROM {$bp->activity->table_name} a {$index_hint_sql} {$join_sql} {$where_sql} ORDER BY a.date_recorded {$sort}", $where_sql, $sort );250 $total_activities_sql = apply_filters( 'bp_activity_total_activities_sql', "SELECT count(DISTINCT a.id) FROM {$bp->activity->table_name} a {$index_hint_sql} {$join_sql} {$where_sql} ORDER BY a.date_recorded {$sort}", $where_sql, $sort ); 251 251 252 252 $total_activities = $wpdb->get_var( $total_activities_sql );
Note: See TracChangeset
for help on using the changeset viewer.