Support » Plugin: User Role Editor » List users with certain role in template

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Vladimir Garagulia

    (@shinephp)

    Later is better than never :). Use the SQL query below to get needed users list:

    select b.user_login
    	from wp_usermeta a
    	join wp_users b on a.user_id=b.ID
    	where a.meta_key='wp_capabilities' and a.meta_value like '%advisors%';

    Thanks for this but not sure how I would then list those users in my template?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘List users with certain role in template’ is closed to new replies.