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. How to do a meta query using REST-API in WordPress 4.7+?
  2. Meta query terribly slow
  3. meta_query sorting by 2 keys
  4. Get result from meta_query() between two numbers
  5. How to handle optional end date in compare clause in meta_query
  6. Using meta_query on pre_get_posts to exclude a particular meta_key value
  7. Query between two meta keys
  8. Archives for custom post type based on a “date” meta value
  9. How to check a single number value against an array of meta_key values?
  10. get_users meta_query
  11. Meta query with multiple logic (AND / OR)
  12. Best practice – Meta Query vs. post_clauses for “left join” ordering
  13. meta_query with multiple values
  14. Different page parameters inside query
  15. Return posts with specific meta key first, but the rest in alpha order by last name
  16. meta_query key value from array
  17. LIKE %…% Meta Query
  18. Multiple Values stored as array in Meta Query
  19. Order by nested named meta queries with ‘exists’ and ‘not exists’
  20. Documentation for post meta
  21. Advanced orderby with multiple meta_query
  22. Arrange Posts By Date In Order Of Closest To The Current Date
  23. Using get_terms() with meta_query parameters
  24. WP_User_Query with meta_query array relation ‘OR’
  25. meta_query problem
  26. Custom Upcoming Events List for Events Manager Plugin
  27. Very slow query with meta_query on large database
  28. How to use meta_query to check if a meta field has something set?
  29. How to exlude posts that have certain meta_value?
  30. User Relationship
  31. meta_query results not the same with and without spaces
  32. meta_query all posts between to ages
  33. How to make a WP REST API query with meta_query in WP4.7?
  34. WordPress Core – Optimizing meta_query generated SQL?
  35. Edit post_content on posts with Featured Image
  36. Nested Queries using meta_query
  37. Display no post when metavalue is 0
  38. Use both meta query and tax query
  39. Wildcard with LIKE operator in Meta query
  40. meta_query, number comparison, not quite working as it should
  41. Meta Query Compare with Date
  42. Query posts only if meta_value is not empty
  43. Does meta_query working with value paramater higher then 999?
  44. meta_query keys and sticky posts
  45. How to pass user meta_key and meta_value (values as array)
  46. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  47. Query Multiple values for same key
  48. Custom post type archive with rand and meta_value
  49. Comparing a field with several values at once with meta_query
  50. Meta query with a sub query group possible?
  51. meta_query compare=’!=’ with multiple custom fields
  52. Query posts with numeric meta values within a given range
  53. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  54. meta_query not working on live site
  55. How to query post only with different excerpt?
  56. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  57. Query custom field with date
  58. Meta query with regular expression does not work
  59. Searching in title or meta, with a tax query too!
  60. WP_Query with meta_query no results
  61. Documentation for post meta
  62. WP User Query Issues
  63. How to use meta query for greater than value in array?
  64. Wp Query custom search by meta query
  65. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  66. Filter posts by meta query?
  67. Help on multiple meta_query
  68. Meta query – How to display a null meta key
  69. pre_get_posts and set
  70. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  71. How to query wp_postmeta table for any specific meta_value?
  72. User meta query results in PHP notice: only variables should be passed by reference
  73. meta_query with multiple values optimization
  74. Meta query date column add [x] days to validate
  75. Get a single post ID based on an exact match of 1 or more meta values
  76. How to use orderby with meta_query?
  77. wordpress Meta_query between numbers range (not working)
  78. meta_query with multiple key
  79. Orderby doesn’t work like expected on custom query
  80. I would like to have add_post_meta to return the ID instead of true or false
  81. Order by meta value
  82. last_name + first_name orderby with meta_query [solved]
  83. meta query based on month regardless of year
  84. Extend meta query arguments
  85. get_posts( $args ) return empty data
  86. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  87. meta query or with meta value
  88. how to get post meta where value is an array of key value pairs
  89. meta_query array in ‘values’ returns an error
  90. Meta Query Based on Month Range
  91. how to search all user meta data that have value like “vivek”
  92. Find posts by related taxonomy field
  93. wordpress meta value compare between two date
  94. Can I use pre_get_posts to add up values from two different meta_keys?
  95. WP JSON API meta_query not working
  96. get_users with Serialized Custom Meta Value
  97. Sorting posts by ACF field
  98. Ordering custom posts by meta field date
  99. Unable to use meta_query between currency values when value is over 1 million
  100. latitude/longitude meta_query
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)