Sort posts by post views and consider meta key

The SQL looks correct. (You can substitute new WP_Query for get_posts and echo $my_posts->requests to see it.)

So I am going to guess that the sticky posts are making it look as though the sorting doesn’t work. Add 'ignore_sticky_posts' => true to your arguments.

Related Posts:

  1. Meta query terribly slow
  2. meta_query sorting by 2 keys
  3. How to handle optional end date in compare clause in meta_query
  4. Using meta_query on pre_get_posts to exclude a particular meta_key value
  5. Query between two meta keys
  6. How to check a single number value against an array of meta_key values?
  7. Meta query with multiple logic (AND / OR)
  8. Best practice – Meta Query vs. post_clauses for “left join” ordering
  9. Different page parameters inside query
  10. LIKE %…% Meta Query
  11. Multiple Values stored as array in Meta Query
  12. Documentation for post meta
  13. Advanced orderby with multiple meta_query
  14. Arrange Posts By Date In Order Of Closest To The Current Date
  15. Custom Upcoming Events List for Events Manager Plugin
  16. Very slow query with meta_query on large database
  17. How to use meta_query to check if a meta field has something set?
  18. meta_query results not the same with and without spaces
  19. meta_query all posts between to ages
  20. How to make a WP REST API query with meta_query in WP4.7?
  21. Nested Queries using meta_query
  22. Wildcard with LIKE operator in Meta query
  23. Query posts only if meta_value is not empty
  24. How to pass user meta_key and meta_value (values as array)
  25. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  26. Query Multiple values for same key
  27. Custom post type archive with rand and meta_value
  28. Comparing a field with several values at once with meta_query
  29. Meta query with a sub query group possible?
  30. meta_query compare=’!=’ with multiple custom fields
  31. Query posts with numeric meta values within a given range
  32. meta_query not working on live site
  33. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  34. Query custom field with date
  35. Meta query with regular expression does not work
  36. Searching in title or meta, with a tax query too!
  37. WP_Query with meta_query no results
  38. Documentation for post meta
  39. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  40. Help on multiple meta_query
  41. Meta query – How to display a null meta key
  42. pre_get_posts and set
  43. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  44. How to query wp_postmeta table for any specific meta_value?
  45. User meta query results in PHP notice: only variables should be passed by reference
  46. meta_query with multiple values optimization
  47. Get a single post ID based on an exact match of 1 or more meta values
  48. wordpress Meta_query between numbers range (not working)
  49. meta_query with multiple key
  50. Order by meta value
  51. last_name + first_name orderby with meta_query [solved]
  52. meta query based on month regardless of year
  53. Extend meta query arguments
  54. get_posts( $args ) return empty data
  55. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  56. meta query or with meta value
  57. how to get post meta where value is an array of key value pairs
  58. meta_query array in ‘values’ returns an error
  59. how to search all user meta data that have value like “vivek”
  60. Ordering custom posts by meta field date
  61. Unable to use meta_query between currency values when value is over 1 million
  62. Filtering all posts AND sticky posts through meta_query
  63. How to properly escape values in meta query
  64. How to cache the results of a query and display the cached results
  65. Fetch custom post related to a User
  66. How to Ordering by user meta
  67. Order resultset by configured value and then list all the rest
  68. How to send variable to wp meta_query value?
  69. get_user can’t read variable
  70. meta_query check multiple date formats
  71. WordPress meta query not working
  72. Get meta_value from GDRating
  73. Reading Content in an Array as it relates to a meta_query
  74. Why does this incorrect pre_get_posts meta_query work for sort order?
  75. Meta_Query with multi select values
  76. How to sort custom posts including null meta-values ​in admin columns with meta_query?
  77. Trouble with calling an imploded variable in an array
  78. Meta Query returning empty array
  79. Query for user roles and their skills
  80. Get Posts from Custom Meta Query
  81. meta_query for user ID in array
  82. Display query post based on two orderby value in wordpress
  83. Search using specific meta fields only (excluding post title and content)
  84. How to fetch WP_User_Query with multiple role arguments [duplicate]
  85. How to get meta value based on latest post id with group by term name
  86. Meta query not returning results even though the sql contains the information
  87. Display Users from two roles in one list
  88. How to compare date in post meta value
  89. Multiple Queries with meta_query
  90. Which Meta Query Compare Method Should I use?
  91. meta_query and strange orderby behaviour
  92. Sorting not working with get_posts
  93. order by meta_key [duplicate]
  94. Meta query with string NOT ending like pattern
  95. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  96. acf/save_post affecting WP_Query results
  97. Merge meta_value’s into a single row and then loop
  98. Is it possible to customize meta query in this way?
  99. How making a new search box in admin post table working on a specific column
  100. wp_user_query with meta_value_num for leaderboard