Skip to:
Content

BuddyPress.org

Changes between Initial Version and Version 1 of Ticket #4060, comment 17


Ignore:
Timestamp:
05/26/2012 11:33:13 PM (13 years ago)
Author:
shanebp
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4060, comment 17

    initial v1  
    1111
    1212{{{
    13  SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name  FROM wp_bp_activity a USE INDEX (date_recorded) LEFT JOIN wp_users u ON a.user_id = u.ID WHERE a.user_id IN ( 28221 ) AND a.component IN ( 'album' ) AND a.item_id IN ( 47715 ) AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20
     13 SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name
     14  FROM wp_bp_activity a USE INDEX (date_recorded) LEFT JOIN wp_users u
     15ON a.user_id = u.ID WHERE a.user_id IN ( 28221 ) AND a.component
     16IN ( 'album' ) AND a.item_id IN ( 47715 ) AND a.type != 'activity_comment'
     17 ORDER BY a.date_recorded DESC LIMIT 0, 20
    1418}}}
    1519
    … …  
    2226
    2327{{{
    24 SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email , um.meta_value as last_activity FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.user_status = 0 AND um.meta_key = 'last_activity' ORDER BY um.meta_value DESC LIMIT 0, 28
     28SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login,
     29 u.display_name, u.user_email , um.meta_value as last_activity FROM wp_users u
     30LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.user_status = 0
     31AND um.meta_key = 'last_activity' ORDER BY um.meta_value DESC LIMIT 0, 28
    2532}}}
    2633 
    … …  
    3037
    3138{{{
    32 SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email , um.meta_value as last_activity
     39SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login,
     40u.display_name, u.user_email , um.meta_value as last_activity
    3341    FROM wp_users u
    34     INNER JOIN (SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key = 'last_activity' ORDER BY meta_value DESC LIMIT 0, 28) AS um
     42    INNER JOIN (SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key =
     43'last_activity' ORDER BY meta_value DESC LIMIT 0, 28) AS um
    3544        ON u.ID = um.user_id;
    3645}}}