Can I use numberposts=-1 and offset together when using get_posts()?

I believe the issue is that the underlying MySQL query requires a LIMIT clause to go with the OFFSET clause. (I tried to verify this about MySQL and found this https://stackoverflow.com/questions/255517/mysql-offset-infinite-rows ). Since MySQL can’t accept those parameters (offset without a limit), WordPress seems to drop the offset argument.

It’s still a little hacky, but I think your only other option would be to set an arbitrarily high number for the ‘numberposts’ argument. I think it’s safe to say you wouldn’t want more than, say, 500 posts returned. So you could use:

$posts = get_posts(array(
    'offset'    =>  2,
    'numberposts'   =>  500,
));

numberposts is just a limit, so it shouldn’t cause any problems. You could go higher if necessary (MySQL seems to suggest 18446744073709551615 as a max).

From what I can tell looking at the core code, that seems like the best you can do. Hope it helps!

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. get_posts gives different result than wpdb->get_results
  20. How to generate a list of posts published on current day?
  21. Trouble using get_post
  22. Get latest posts from multiple categories
  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. Only retrieve posts where post_excerpt has been filled out
  31. Ordering posts in get_posts
  32. How can I display a single post link, based on title sample and change monthly?
  33. get_posts() doesn’t consider user permissions
  34. Get posts inside Get terms problem
  35. Ho to add get_relative_date and post_except to this get_latest_post query?
  36. How to update all posts but the current one (post__not_in not working?)
  37. Only showing the_date and the_excerpt for first entry in get_posts
  38. Query Problem in getting top viewed posts
  39. get_posts not working as expected
  40. Get all pages and posts with get_pages() or get_posts()
  41. Getting only a specific post type with get_post?
  42. Exclude post format from get_posts
  43. Memory issue with get_posts( ) function
  44. get_posts() using an array of post ids [closed]
  45. Iterate over get_post_meta() result
  46. How can I show the author’s latest post with title?
  47. Unique Problem with the php date and get_posts
  48. get the post_date of ID
  49. Get posts by language in Polylang plugin
  50. Auto-change Post Status on First Page Load
  51. Not able to get random post
  52. Override Blog pages show at most with get_posts
  53. SQL query generated by WP_Query is not the same what request echoes
  54. Calling setup_postdata() causes “Call to undefined function get_userdata()” error?
  55. ‘child_of’ in get_posts not working
  56. Cron task firing but function not working
  57. wp json api – get posts by category
  58. Custom Post type Query post is not working
  59. Get all posts with a certain meta key, except for one with specific title
  60. How do I get only a certain number of images from a post (minus the featured image)?
  61. Modified home page query does not yield expected results
  62. Sort get_children by menu_order
  63. Working with get_posts parameters/arrays/strings
  64. Getting post by specific date in Advance Custom Field
  65. Add ul to its children with get_posts
  66. get_posts by id not working
  67. Select objects from get_posts()
  68. Divide the list into two columns (get_posts)
  69. Using post title as term in query, only working with single word titles
  70. Single random post in homepage
  71. Get posts in archive page
  72. Paging result of get_posts in function
  73. How to get a custom post with the largest ID (not the last post by date)
  74. get_posts returning empty array
  75. Update all WordPress posts’s title and content then display them in a table
  76. get_post Question
  77. get the_content by ID and save the result to one array
  78. Custom Category widget
  79. Zero posts returned with get_posts() on edit.php, but posts are returned on post.php
  80. Better way to query posts?
  81. Using get_posts, I need to use a combination of OR & AND relations
  82. Get number of posts in each category since last visit
  83. Get_posts not returning any posts when used with switch_to_blog
  84. get_posts array ‘between’ not behaving
  85. Get images by category
  86. How To Use get_posts & get_the_post_thumbnail Outside The Loop
  87. How to show only 1 post from a specific category on the front-page
  88. Query for draft or scheduled post
  89. get_posts() and ‘posts_per_page’ arg
  90. get_pages not returning any results or error when get_posts works
  91. Show posts in a list separated by day
  92. Sorting posts by specific order
  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)
techhipbettruvabetnorabahisbahis forumueduedueduedueduedusedusedusedusedus