SELECT SQL_CALC_FOUND_ROWS u.ID, u.user_login, u.user_email, u.user_nicename, u.display_name, UNIX_TIMESTAMP(u.user_registered) as joindate, mu.membership_id, mu.initial_payment, mu.billing_amount, mu.cycle_period, mu.cycle_number, mu.billing_limit, mu.trial_amount, mu.trial_limit, UNIX_TIMESTAMP(mu.startdate) as startdate, UNIX_TIMESTAMP(mu.enddate) as enddate, m.name as membership, umf.meta_value as first_name, uml.meta_value as last_name FROM wp_users u LEFT JOIN wp_usermeta umh ON umh.meta_key = 'pmpromd_hide_directory' AND u.ID = umh.user_id LEFT JOIN wp_usermeta umf ON umf.meta_key = 'first_name' AND u.ID = umf.user_id LEFT JOIN wp_usermeta uml ON uml.meta_key = 'last_name' AND u.ID = uml.user_id LEFT JOIN wp_usermeta um ON u.ID = um.user_id LEFT JOIN wp_pmpro_memberships_users mu ON u.ID = mu.user_id LEFT JOIN wp_pmpro_membership_levels m ON mu.membership_id = m.id LEFT JOIN wp_bp_xprofile_data x ON x.user_id=u.ID and x.field_id=2 WHERE mu.status = 'active' AND (umh.meta_value IS NULL OR umh.meta_value <> '1') AND mu.membership_id > 0 AND (u.user_login LIKE '%Drum%' OR u.user_email LIKE '%Drum%' OR u.display_name LIKE '%Drum%' OR um.meta_value LIKE '%Drums%' OR x.value LIKE '%70%') AND mu.membership_id IN(1,2,3) GROUP BY u.ID ORDER BY u.display_name ASC LIMIT 0, 15

Profiles Within Drum.

No matching profiles found within Drum.