| 18 | | SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM wp_bp_activity a, wp_users u, wp_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 577900 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; |
| 19 | | |
| | 18 | SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value |
| | 19 | as user_fullname FROM wp_bp_activity a, wp_users u, wp_bp_xprofile_data pd |
| | 20 | WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 |
| | 21 | AND a.type = 'activity_comment' AND a.item_id = 577900 AND a.mptt_left |
| | 22 | BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; |