How to get top 10 user is based on user meta value

I guess you can do with get_users, something like:

$topusers = get_users( array (
    'meta_key'     => 'todayuserclicks',
    'meta_value'   => '',
    'meta_compare' => '!=',
    'orderby'      => 'meta_value',
    'order'        => 'DESC',
    'number'       => '10',
) );

Related Posts:

  1. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  2. Search multiple meta keys at once
  3. Querying Email Addresses for a List of Users with Same Last Name?
  4. In what part of the WordPress core does the users table and usermeta table get joined?
  5. Modify Database in Multi-Site wp_usermeta table
  6. Get an array of meta_values for a user meta_key
  7. mysql query two database tables, users and usermeta and sort by custom meta int value
  8. WordPress SQL Issue not returning correct reselts
  9. get_results not returning anything
  10. Get emails from users by custom field SQL
  11. How to relate the Category to user?
  12. How to get image path from id using SQL
  13. Intermittent problem writing update_user_meta
  14. Checking if meta_value exists for any user
  15. user_login vs. user_nicename
  16. How to parse row results from $wpdb -> get_results
  17. $wpdb->insert not working in any way
  18. get_results on large datasets
  19. $wpdb->insert() and Values for Datetime Columns?
  20. Getting all user metadata from user
  21. Extending WP_User class and using this sub-class during the whole lifecycle
  22. Change post status based on meta value
  23. Show Biographical Info while creating new user
  24. Speed optimization of $wpdb->get_results
  25. $wpdb is get_results escaped
  26. Hide a user from WordPress
  27. $wpdb insert array
  28. get_user_meta Short Profile Section
  29. How to update records using $wpdb?
  30. Exclude subscriber users from user list
  31. Memory usage for scalable usermeta queries
  32. Select Multiple meta_value from WP DB; Single Query
  33. show badge with count for pending items in custom post type
  34. Get all user meta by meta key instead of ID
  35. wpdb->insert and stripslashes against sql injection
  36. create drop down menu in theme customizer from custom db
  37. Average Account Age
  38. Are there risks associated with using wp_options table using wpdb to update theme options
  39. WordPress User Meta & ChromePHP or other way to debug/view php variables
  40. How to keep users unique id stored in session in addition to IP in WordPress plugin?
  41. $wpdb->insert is running multiple times on page load, but only called once
  42. Force a user’s posts category
  43. $wpdb select query by month, post type, and taxonomy term
  44. Confused by $wpdb->prepare
  45. WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
  46. How to display user_nicename and usermeta values by custom query in WordPress?
  47. Users create/join groups
  48. How to get entry by title by using wpdb
  49. How to list users by custom field?
  50. users and usermeta table
  51. $wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
  52. WordPress is trimming leading 0s
  53. Gather posts into a cart/lightbox and share with another user
  54. “the_author_meta(‘url’)” not working inside “href”
  55. How to left join meta in queries [closed]
  56. Save data from a checkbox to a wpdb array
  57. How to get user ID’s from multiple usernames?
  58. WP-PostRatings: list current user’s rated posts
  59. Get the users that my following users are following
  60. WPDB Join with custom table
  61. Getting values from wpdb
  62. Why is this $wpdb query looping 5 times?
  63. wpdb query not returning results containing single quotes
  64. duplicate entries in database while using save_post or wp_insert_post
  65. get_users with Serialized Custom Meta Value
  66. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  67. Inserting a MySQL record into a table with an array of field names and an array of values
  68. Incorrect Use of wpdb::prepare()
  69. Ascending order of yearly archives [closed]
  70. WP_User_Query not searching
  71. Uses for function: wp_update_user
  72. how to list all post that are in the custom taxonomy using $wpdb
  73. Get UserInfo from WordPress
  74. Display current user metadata on WordPress page
  75. wpdb prepare placeholders for MySQL keywords
  76. Escaping a WPDB Object in One Shot
  77. show user based on user_meta
  78. REST_query_vars for users
  79. Create a stored procedure on plugin activation
  80. Get last element from wpdb as a string
  81. Extend WP_User_Query or WP_User to return all custom fields?
  82. Custom database query to validate data
  83. Update all fields of table with ON DUPLICATE KEY UPDATE command
  84. WordPress – wpdb query does not list same result as sql query
  85. What is the best practice to initialise $wpdb by loading wp-load.php?
  86. $wpdb->get_results in not an array
  87. How to make iteration on wpdb->update or query statement?
  88. User management missing after migration to new host
  89. Display and Allow users to edit their own profiles
  90. Validate user meta and redirect
  91. Let admin users edit member profiles from front end
  92. Jeditable Plugin working as it should – scope issue?
  93. Store subscription details for users in WordPress
  94. Site going down due to slow queries
  95. Call to a member function get_results() on a non-object in wordpress plugin
  96. How to add custom detail page for a Subscriber at Admin Panel
  97. How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]
  98. $wpdb The query does not contain the correct number of placeholders
  99. $wpdb:insert, more arguements in $format array than in $data
  100. Export user data from Squirrly’s Starbox plugin?