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. How to limit the number of posts that WP_Query gets?
  6. Should we trust the post globals?
  7. The next_posts_link() works only with original $wp_query
  8. Adding additional data to WP_Post object
  9. Get current post id in functions.php
  10. Random sort within an already sorted query
  11. Get first post from wp_query
  12. WP_Query: Why is sticky post not first item in loop?
  13. Displaying the category name of a custom post type
  14. Query *only* sticky posts
  15. Search by Hyphen
  16. Skipping first 3 posts in wp query
  17. Exclude drafts in all() view of edit.php
  18. Exclude posts that only have the ‘Uncategorized’ category [duplicate]
  19. How do I reorder (pop and push) items from WP_Query?
  20. Accessing the post content with WP_Query
  21. Querying post from a multisite network
  22. How to exclude latest x posts from a paginated query?
  23. How to query serialized array by comparing greater than (>=)?
  24. How to know if get_posts() failed?
  25. Show related posts by category but ignore one category
  26. post__in for get_posts with a dynamic array
  27. Keep getting same permalink with WP_Query?
  28. Reverse chronology of post listing
  29. Query posts distinct authors
  30. WP_Query to work with custom view
  31. How to query posts with current or future date only
  32. How to get previous 10 days post from a specific date – WP Query
  33. WordPress Number of Posts Not Changing With posts_per_page
  34. Most viewed post for the last 2 days using WP_Query
  35. Adding Post Counts to Menu (Nav) Programmatically?
  36. Pagination not working on Custom Page Template
  37. This AJAX Code Doesn’t Work – Looking for elegant solution
  38. Create new WordPress post [wp_insert_post] based on results of a WP_Query
  39. Post content being duplicated by the_content();
  40. Get only modified posts
  41. How to add posts to wp_query result?
  42. Posts for next month
  43. Exclude posts with specific meta_value while sorting by a separate meta_value
  44. Specific loop in Shortcode
  45. Sort posts by activity date
  46. How to add padding between posts
  47. prevent showing posts of an specific category in admin posts section
  48. How to output comments number of a post per day?
  49. Working Bootstrap Carousel Conversion to WP – Technical Questions
  50. Search widget breaks when using multiple loops?
  51. WP_Query only ONE post, won’t work
  52. How to change bulk post status
  53. Add few specific post ids to wp_query
  54. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  55. Unable to modify(update) posts – Page not found
  56. Display the latest posts, published in the last hour, with WP_Query
  57. Replace Main Query With Custom Query
  58. Custom Order in WP Query
  59. Fetch posts from current week (Sunday to Saturday)
  60. If specific user role then sticky post
  61. Hide Post comments when displayed via WP_Query
  62. Search query – exact post title match
  63. Hiding posts in a list from specified categories
  64. Converting multiple loops into one single loop with pagination
  65. Display posts with comments closed, with pagination?
  66. Group posts by year in loop
  67. posts_per_page doesnt work
  68. WP_Query posts_per_page ignored
  69. wp query with dynamic taxonomies and terms?
  70. How would I get 1 latest post from a query for 5 posts?
  71. How to get posts by multiple post slugs? [duplicate]
  72. Blogroll – Different layout for first post
  73. How to get most recent commented post above new submitted post in WordPress?
  74. WP_Query do not load specifed number of post
  75. wp_query ‘s’ parameter does not work with custom post type
  76. How to start with post number x?
  77. WP Query related posts by current page Tag ID
  78. Exclude posts with empty post_content in wp_query
  79. Exclude posts from featuring
  80. I want to query posts in monthly basis
  81. Lazy Load using WP_Query pagination
  82. Only display a certain number of posts, dependent on how many posts there are available in a query
  83. How do I use `posts_distinct` correctly?
  84. AJAX filter posts by year
  85. How can I remove posts of a certain category from homepage after a specified time period?
  86. Automatic value for custom fields for posts
  87. Loop through all product posts?
  88. Custom WP_QUERY $args
  89. Improving WP_Query for performance when random posts are ordered
  90. Automatic post deletion
  91. Why won’t my taxonomy query show up?
  92. Should $found_posts be returned as string in ‘found_posts’ filter hook?
  93. Get random posts between specific dates / of specific age
  94. WP_Query get posts from custom posts by category
  95. Accessing post->ID outside of the loop for listing child pages
  96. How to find what index page a post is on?
  97. WP Query – duplicated posts once including tags in search results
  98. Limiting the number of posts in WP_Query leads to unexpected result
  99. List posts in a given category
  100. Reset Popular post query?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)