Skip to content

Instantly share code, notes, and snippets.

@kasparsb
Created September 16, 2013 21:01
Show Gist options
  • Save kasparsb/6586541 to your computer and use it in GitHub Desktop.
Save kasparsb/6586541 to your computer and use it in GitHub Desktop.
$data = DB::table( 'wp_usermeta' )
->join('wp_users', 'wp_users.ID', '=', 'wp_usermeta.user_id')
->where('wp_usermeta.meta_key', '=', 'wp_user_level')
->where('wp_usermeta.meta_value', '>', '0')
->orderBy('wp_users.display_name', 'asc')
->select('wp_users.ID as id', 'wp_users.display_name as name' )
->get();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment