[buddypress-trac] [BuddyPress Trac] #5405: Can't go on the latest page of "Groups"

[buddypress-trac]

#5405: Can't go on the latest page of "Groups"
-------------------------------+------------------------------
 Reporter:  elpix              |       Owner:
     Type:  defect (bug)       |      Status:  new
 Priority:  highest            |   Milestone:  Awaiting Review
Component:  Groups             |     Version:  1.9.2
 Severity:  critical           |  Resolution:
 Keywords:  reporter-feedback  |
-------------------------------+------------------------------

Comment (by elpix):

 SELECT g.*, gm1.meta_value AS total_member_count, gm2.meta_value AS
 last_activity  FROM wp_bp_groups_groupmeta gm1, wp_bp_groups_groupmeta
 gm2,  wp_bp_groups g WHERE  g.id = gm1.group_id AND g.id = gm2.group_id
 AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count'
 AND g.id IN (1,2,3,4,5,6,7,9,10, ... ,91998,91999) ORDER BY last_activity
 DESC LIMIT 20, 20;

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5405#comment:2>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac