Replacing raw database query to WP_Query

Finally found the answer.

Since I had not specified 

            'orderby' => 'meta_value_num',
            'meta_key' => '_recommended',

The limit was being considered as count. I am not sure if am explaining this right

Related Posts:

  1. When to use WP_query(), query_posts() and pre_get_posts
  2. WordPress Pagination Not Working – Always Showing First Pages Content
  3. Whats the difference between post_limits and pre_get_posts?
  4. WP query taxonomy input differs to output?
  5. Query WooCommerce orders where meta data does not exist
  6. How to get Page/Post Gallery attachment images in order they are set in backend using WP_Query()?
  7. What exactly does the ‘s’ parameter search for in WP queries?
  8. WP_Query min and max values
  9. post_type is ignored by WP_Query when ‘tag’ argument is included
  10. get_posts not finding argument: post_name
  11. get query’s query string
  12. Show only oldest post by author
  13. assign 2 $args to one wp_query
  14. WP_Query OR clause for tax_query and keywords
  15. Revolution Slider Orderby Two Custom Fields
  16. Calling a custom excerpt function in a local loop
  17. Dynamically Override Fancy Title – Part II
  18. Transient pagination not working properly
  19. How to run query inside a class with namespace?
  20. Which filter/action hook gets triggered after a query has been performed?
  21. Modify existing query and change order of posts
  22. Why does the_content not work like others for a set post id?
  23. pre_get_posts filter meta_query without conflicting existing meta_query
  24. How would I format a query that depends on post parent taxonomy
  25. Minimising Database Queries when using Advanced Custom Fields
  26. Rewrite rule to prettify two $_GET variables while in a new endpoint from a page
  27. Creating a custom search for a specific post type
  28. How to add post_distinct filter to WP_Comment_Query?
  29. WP_Query Group by Author and Order each group DESC
  30. List only posts from specific category on category page
  31. Most popular post for last 7 days
  32. WP Pagination on Posts Search Results Page resulting from AJAX WP Query
  33. How to avoid wp_query returning the same post I’m on in results?
  34. Query multiple meta values
  35. Why isn’t my multiple orderby working?
  36. WordPress Loop and $post
  37. How can I create ‘future’ and ‘past’ parameter for restAPI by filtering the CPT custom date field by greater than / less than current datetime?
  38. WP_Query ignoring tax_query when is_singular
  39. WP_Query() order by post content lenght?
  40. Query posts without meta preload
  41. How to implement a new row_count method in WordPress?
  42. Excluding pages in WP_query using ACF
  43. reset to main loop doesnt work
  44. Applying posts_clauses filter to specific queries only
  45. Pagination on static Posts page
  46. Shortcode for latest -not expired- posts
  47. How to show more post at a given category?
  48. WP_Query returns posts_per_page + 1 every time
  49. Custom WP query with polylang term
  50. All posts returned when author of 0 is queried
  51. Merge two search functions for custom post type
  52. WP_Query – Accessing MetaValue from Query Result
  53. problems with comments_number()
  54. Trying to retrieve random post, getting a page
  55. get_the_terms – but only show 4 Posts
  56. Does WordPress have something like Drupal’s DB API?
  57. PHP – Loop custom post type categories within jQuery Tabs
  58. How order posts from category by date and comment count?
  59. Get a list of ACF Repeater-Fields as array
  60. query_vars empty when using custom url with custom rewrite rule
  61. Get query results with a page title
  62. Show single posts date, in a page of posts
  63. Post archive for certain post format
  64. Compare “Main” post ID to ID inside wp_query loop
  65. Attempt to display site authors in a carousel – User Image not Outputting inside li tags
  66. Add AJAX “Load more” on custom query block
  67. problem with the loop
  68. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  69. Why my query is not “Main_query”?
  70. Filter sub-category from checkbox form
  71. Facing problem with tax_query results
  72. How to add a “base” filter for all posts visible to visitors on the site?
  73. sanitize_post() is not sanitizing Post Object
  74. WP_Query() not filtering posts for category
  75. wp query search multi terms
  76. How to get top rated posts using wp query?
  77. Unusual high query of user meta data
  78. Woocommerce featured products query no longer working
  79. add action for wordpress query at a specific position
  80. How to query wordpress with array of meta_values?
  81. Updating an intensive wp_query result once daily
  82. Custom WP_query and integrating into theme file
  83. Empty ‘terms’ in ‘tax_query’ returns an empty array
  84. Get newest value of an array
  85. Filter custom post type by custom taxomony
  86. ordering and optimizing functions
  87. Why does order ASC break offset in WP_Query?
  88. new WP_query using custom fields
  89. Having Trouble Running Query From Shortcode Using Tribe’s Events Plugin
  90. Change ‘post_modify’ with a query
  91. An archive page without post format (just standard post)
  92. Ordering Custom WP_Query loop by meta key value with pagination
  93. WordPress Query Returning Every Post
  94. Pagination showing same posts despite changing page
  95. shortcode with $atts with strange results
  96. Query custom post types by meta field in a term from custom taxonomy
  97. Refresh wp_query with no changes
  98. SQL query into to WP query
  99. WordPress WP_Query Search (‘s’) With Multiple Search Terms
  100. I want to place a post before all others from an ACF boleen field
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduedueduedusedueduseduseduedus