How to exclude latest x posts from a paginated query?

One way is to use the offset parameter in WP_Query, but it overrides the paged parameter according to the docs.

Example formula for an offset with pagination:

'posts_per_page' => $posts_per_page,
'offset'         => ( $paged - 1 ) * $posts_per_page + $offset_per_page,

Example:

Then for $posts_per_page as 4 and $offset_per_page as 5 we get the post numbers:

first page:   6,7,8,9    (skip first 5 posts)
second page: 10,11,12,13 (skip first 9 posts)
third page:  14,15,16,17 (skip first 13 posts)
...

Notes:

In this previous answer I’ve added a way to play with another type of formula.

There might be some performance issues for really large offset numbers.

Note that WordPress also has it’s own REST API that can in many cases be used instead of Ajax.

I also wonder if the offset is really needed here, if the original loop + Ajax can be replaced with a single REST API setup instead.

ps: above is untested.

Related Posts:

  1. How to exclude latest x posts from a paginated query?
  2. WordPress Number of Posts Not Changing With posts_per_page
  3. How would I get 1 latest post from a query for 5 posts?
  4. Why WP_Query(‘showposts=5’) shows only 1 post?
  5. Blog post per page setting conflicting with custom WP_Query?
  6. How to get posts published on the latest date?
  7. WP_Query: Show 10 posts in date order, first three random
  8. Display 3 posts with different HTML markup using a loop
  9. Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
  10. Adding a category at even positions on main loop with modified pagination
  11. Should we trust the post globals?
  12. How to get posts published between a date and today?
  13. Get first post from wp_query
  14. Query *only* sticky posts
  15. Reverse chronology of post listing
  16. Query posts distinct authors
  17. How to get previous 10 days post from a specific date – WP Query
  18. This AJAX Code Doesn’t Work – Looking for elegant solution
  19. Can’t show comments count per post outside loop
  20. Specific loop in Shortcode
  21. Search widget breaks when using multiple loops?
  22. Custom Order in WP Query
  23. Hiding posts in a list from specified categories
  24. Display posts with comments closed, with pagination?
  25. Group posts by year in loop
  26. Loop through all product posts?
  27. Improving WP_Query for performance when random posts are ordered
  28. WP Query – duplicated posts once including tags in search results
  29. Reset Popular post query?
  30. Display post from current category and same tag?
  31. how to get posts ids inside pre_get_posts filter?
  32. Inserting custom data to the_post() during loop
  33. How To Get Posts With A Specific Word
  34. Display all posts that were published before full post on single.php
  35. Two loops, one AJAX loop, exclude posts in first loop from second loop, loops are in different files
  36. Blog page pagination is not working after using the offset argument
  37. Posts will not display on page-mypage.php
  38. WP Query – Posts Per Page not working in combination with category__in
  39. Pausing and Resuming WP_Query results
  40. How to : pagination in 3 different custom loops on the same page
  41. posts_per_page option limits the number of Gallery items
  42. List authors with the last post title and order by last post date
  43. wp_query random post
  44. wp_posts table: safely remove unused columns to save database storage
  45. Query Posts by Custom Field
  46. How to order posts in an arbitrary order?
  47. Display Posts on Custom Page
  48. Possible to alternate between two loops
  49. Nested WP_Query breaking loop
  50. WordPress query_posts by tag doesn’t work anymore(?)
  51. why the same code got different results when using query_posts in functions.php and index.php
  52. Query for first 3 posts to change the look and feel
  53. How to only publish posts with image in it
  54. Getting blog pagination to work on page set as front page
  55. Shortcode with ‘year’ parameter
  56. On what hook can I get the queried object’s final state?
  57. Display current post position in Elementor Posts widget
  58. wp_query with ajax
  59. How to give classname to post if post has no content?
  60. WordPress Loop: How to display recent posts in multiple divs
  61. Random posts that always include a particular post?
  62. WordPress post filter menu
  63. How to display post list in a table layout (multiple queries in single loop)
  64. Not all posts showing in query
  65. WordPress query portfolio posts
  66. Display specific posts on home page
  67. WP_Query of Category Not Showing First Post
  68. WP_Query articles order by offset in collumns
  69. Change content off every sixth element
  70. How do I display main query posts in random order using add_filter
  71. While loop in functions.php outputting the_title() of each post on frontpage
  72. Show posts from two specific category in WP_Query
  73. How to create loop of posts except post ID defined via ACF field
  74. Displaying all posts from other sites on the network on one site
  75. Multisite how to display merged posts from two sites and sort by latest date?
  76. Numbered Pagination Showing The Same Posts After Altering WP_Query
  77. How to show post views shortcode data for each post on Posts List Page?
  78. show loop id post , only first id can read
  79. Show 5 posts and than 3 posts offset with pagination
  80. Double loop output
  81. wp_query args with relation
  82. Loop through all posts showing duplicates
  83. Manipulate query to show specific post
  84. Wp_query loop is not working as it should
  85. Use special template for the first post in the loop
  86. WordPress loop uses unmodified posts array, why?
  87. Sort / Filter Queries
  88. Modify WordPress loop after it has been run
  89. Advanced Post Display/Pagination/Ordering
  90. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  91. How to show the posts list into a static page? Problems to use the loop into a static page
  92. How do I control the fallback query after the original query returned cero posts?
  93. Remove duplicated posts in the loop if post has more than one category
  94. Make assigning post to a specific category equivalent to assigning it to all categories
  95. How to inject a post within a loop
  96. How do I show the post title if an advanced custom field hasn’t been used?
  97. First post in loop displays twice
  98. WP_query sort by custom meta_key “price”
  99. posts_per_page – Repeats only first posts ‘post__in’ array
  100. query_posts different amount of posts per page [duplicate]

Leave a Comment