WP_Query: offset ignored when posts_per_page is -1?

posts_per_page => -1 is equivalent to 'nopaging' => true, which basically means no LIMIT clause is used at all.

The workaround is to set posts_per_page to a large number.

This is a limitation of the LIMIT syntax itself:

http://dev.mysql.com/doc/refman/5.0/en/select.html

Related Posts:

  1. WP_Query offset argument does not work
  2. Exclude the first ‘n’ number of posts of a tag from home page?
  3. Exclude some posts from displaying in wp_query based on some condition
  4. Manipulated offset and pagination, can’t display last post anymore
  5. The next_posts_link() works only with original $wp_query
  6. Query *only* sticky posts
  7. Skipping first 3 posts in wp query
  8. Accessing the post content with WP_Query
  9. Most viewed post for the last 2 days using WP_Query
  10. Adding Post Counts to Menu (Nav) Programmatically?
  11. This AJAX Code Doesn’t Work – Looking for elegant solution
  12. Get only modified posts
  13. How to output comments number of a post per day?
  14. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  15. If specific user role then sticky post
  16. Display posts with comments closed, with pagination?
  17. posts_per_page doesnt work
  18. Blogroll – Different layout for first post
  19. How do I use `posts_distinct` correctly?
  20. Automatic value for custom fields for posts
  21. Loop through all product posts?
  22. Improving WP_Query for performance when random posts are ordered
  23. Why won’t my taxonomy query show up?
  24. How to find what index page a post is on?
  25. Display post from current category and same tag?
  26. Get Posts that are in the current month or later
  27. WP Query to Get Array of Slugs
  28. WP_Query with ajax handler returns the same posts
  29. Why WP_Query(‘showposts=5’) shows only 1 post?
  30. How can I sort posts by the date and a custom meta field?
  31. Hiding Draft Post In Admin
  32. How to insert 2 args into 1 Wp_Query for a slideshow
  33. How to verify wp user password by sql query in wp? [closed]
  34. Blog page pagination is not working after using the offset argument
  35. WP Query – Posts Per Page not working in combination with category__in
  36. Lost draft under all posts and drafts
  37. Get user categories with most posts in it
  38. how to change the number of posts returned in a specific loop without making it global?
  39. List authors with the last post title and order by last post date
  40. How to order posts by meta_value and title
  41. Nested WP_Query breaking loop
  42. WordPress query_posts by tag doesn’t work anymore(?)
  43. Why Query is returning empty array?
  44. Ignore latest two posts
  45. meta_value timestamp older than now
  46. Print out last 3 blogposts
  47. Query for first 3 posts to change the look and feel
  48. Why posts array is empty?
  49. Getting blog pagination to work on page set as front page
  50. How to group only VISIBLE posts? [closed]
  51. Shortcode with ‘year’ parameter
  52. search blog posts by author first name and or last name
  53. On what hook can I get the queried object’s final state?
  54. unique post in “$args” of wp_query display more than one post
  55. How can I insert a new markup element after 4 posts automatically? [closed]
  56. How to display post list in a table layout (multiple queries in single loop)
  57. Not all posts showing in query
  58. Get all custom posts with a certain taxonomy
  59. Link to date_query results in WordPress
  60. When WP_Query only returns 1 post, how do I automatically redirect to that post?
  61. WordPress query portfolio posts
  62. Get latest author posts inside the loop
  63. Limiting post list by taxonomy
  64. Display 3 posts with different HTML markup using a loop
  65. Optimal WP Web App Backend for mobile app development
  66. How to show multiple posts thumbnail, title and date in widget
  67. Group first, 2nd, 3rd, etc posts by category terms
  68. Function is printing twice – any suggestions?
  69. How to display particular set of wordpress post on a webpage?
  70. query posts with selected post ids first
  71. How to use two query result together in one loop
  72. show loop id post , only first id can read
  73. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  74. Counting Posts by Category
  75. show image gallery in archives or category page
  76. Page with Category Returning 1
  77. filter posts based on menu_order
  78. Show 5 posts and than 3 posts offset with pagination
  79. Change archive results based on GET request
  80. wp_query args with relation
  81. Wp_query loop is not working as it should
  82. Show all posts from the tags without having to set all of them
  83. Is it possible to query a category with specified posts?
  84. Creating Ordered Query using Meta_key
  85. Is there a global page/post/product/anything ID?
  86. WordPress loop uses unmodified posts array, why?
  87. wp query custom orderby not custom field
  88. Show posts between two Custom Fields date
  89. Query to get data of a post, if in category?
  90. Order posts by custom field
  91. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  92. Remove duplicated posts in the loop if post has more than one category
  93. How to Include a common category in a custom Category Search
  94. Why I getting only 1 post?
  95. The next_posts_link() works only with original $wp_query
  96. wp_query posts sorting doesn’t work
  97. Limit amount of pages shown in pagination within wp_query
  98. First post in loop displays twice
  99. Filters do not work when there are multiple (one works)
  100. date_query returning only the most recent post instead of the post published before today