get_posts gives different result than wpdb->get_results

Why is it always that I look for a solution for hours… then post it here and within a few minutes I find the solution myself….

I found the solution in this post.

The default arguments for get_posts() function include ‘numberposts’ => 5.

So when I set number, it was ignored and 5 was set for numberposts. The correct values are posts_per_page and numberposts (imo a poorly chosen variable).

Related Posts:

  1. What does setup_postdata ($post ) do?
  2. Query for custom post type? [closed]
  3. get_posts – get all posts by author id
  4. Exclude Current Post from Recent Posts Loop
  5. get_post random and order by not working
  6. get_posts with meta_compare=’LIKE’ not working
  7. Sort “get_pages” by menu order not ordering
  8. Get the exact SQL query that get_posts() generated
  9. get_posts inside cron
  10. get_posts returning empty array
  11. Problem with get_posts, tax_query and counting the number of posts
  12. Filtering custom post type query
  13. Check If posts exist in custom post type category, outside of loop
  14. data returned from get_post($postId) have different keys than wp-json/wp/v2/posts/{postId}
  15. How to limit get_posts()?
  16. meta_query date and time comparisons
  17. get_posts from post x(offset=>x) to end
  18. What’s the difference between “get_posts” and “wp_get_recent_posts” when used with “setup_postdata”?
  19. Increase the page size of the WordPress REST API
  20. How to generate a list of posts published on current day?
  21. Get latest posts from multiple categories
  22. get_posts() returns all posts rather than the ones specified with ‘post_author’ =>
  23. Get_Posts, only if in both categories
  24. Posts not showing in correct Alphabetical or ID order when using get_posts / orderby but only on production server
  25. get_posts() excluding all children of a specific post/page
  26. Secondary Query Is Breaking Main Query
  27. If clauses in get_posts query
  28. var_dump and print_r cause white screen
  29. excluding current post from get_posts
  30. How to query posts to include specific pages of one post type, and all pages of another post type?
  31. Only retrieve posts where post_excerpt has been filled out
  32. Can I use numberposts=-1 and offset together when using get_posts()?
  33. Ordering posts in get_posts
  34. How can I display a single post link, based on title sample and change monthly?
  35. get_posts() doesn’t consider user permissions
  36. Get posts inside Get terms problem
  37. Ho to add get_relative_date and post_except to this get_latest_post query?
  38. How to update all posts but the current one (post__not_in not working?)
  39. Only showing the_date and the_excerpt for first entry in get_posts
  40. Query Problem in getting top viewed posts
  41. get_posts not working as expected
  42. Get all pages and posts with get_pages() or get_posts()
  43. Getting only a specific post type with get_post?
  44. Exclude post format from get_posts
  45. Memory issue with get_posts( ) function
  46. get_posts() using an array of post ids [closed]
  47. Iterate over get_post_meta() result
  48. How can I show the author’s latest post with title?
  49. Unique Problem with the php date and get_posts
  50. get the post_date of ID
  51. Get posts by language in Polylang plugin
  52. Auto-change Post Status on First Page Load
  53. Not able to get random post
  54. Override Blog pages show at most with get_posts
  55. SQL query generated by WP_Query is not the same what request echoes
  56. Calling setup_postdata() causes “Call to undefined function get_userdata()” error?
  57. ‘child_of’ in get_posts not working
  58. Cron task firing but function not working
  59. wp json api – get posts by category
  60. Custom Post type Query post is not working
  61. Fetching All Posts (200+) in a Category – Performance Issues?
  62. Get all posts with a certain meta key, except for one with specific title
  63. How do I get only a certain number of images from a post (minus the featured image)?
  64. Modified home page query does not yield expected results
  65. Sort get_children by menu_order
  66. Working with get_posts parameters/arrays/strings
  67. Getting post by specific date in Advance Custom Field
  68. Add ul to its children with get_posts
  69. get_posts by id not working
  70. Select objects from get_posts()
  71. Using post title as term in query, only working with single word titles
  72. Single random post in homepage
  73. Get posts in archive page
  74. Paging result of get_posts in function
  75. How to get a custom post with the largest ID (not the last post by date)
  76. get_posts returning empty array
  77. Update all WordPress posts’s title and content then display them in a table
  78. get_post Question
  79. get the_content by ID and save the result to one array
  80. Zero posts returned with get_posts() on edit.php, but posts are returned on post.php
  81. Better way to query posts?
  82. Using get_posts, I need to use a combination of OR & AND relations
  83. Get number of posts in each category since last visit
  84. Get_posts not returning any posts when used with switch_to_blog
  85. get_posts array ‘between’ not behaving
  86. Get images by category
  87. How To Use get_posts & get_the_post_thumbnail Outside The Loop
  88. How to show only 1 post from a specific category on the front-page
  89. Query for draft or scheduled post
  90. get_posts() and ‘posts_per_page’ arg
  91. get_pages not returning any results or error when get_posts works
  92. Show posts in a list separated by day
  93. Function to get content by ID
  94. Display all Post titles with Category and Tag
  95. Intergrate WP into website
  96. Latest post on specific category and custom css
  97. Display post’s description and caption
  98. get posts based on category and post meta
  99. How to show only text from post in WordPress
  100. Install wordpress and replace database (from previous site)
tech