Using Offset in Custom Post Type Query

Reason of this behavior is pretty simple. First of all you have to know that get_posts uses WP_Query to get posts.

So let’s look at WP_Query implementation. On line 1998 of query.php you can find:

if ( $q['posts_per_page'] == -1 ) {
    $q['nopaging'] = true;

Then on line 2544 of query.php you find:

if ( empty($q['nopaging']) && !$this->is_singular ) {
    $page = absint($q['paged']);
    if ( !$page )
        $page = 1;

    if ( empty($q['offset']) ) {
        $pgstrt = ($page - 1) * $q['posts_per_page'] . ', ';
    } else { // we're ignoring $page and using 'offset'
        $q['offset'] = absint($q['offset']);
        $pgstrt = $q['offset'] . ', ';
    }
    $limits="LIMIT " . $pgstrt . $q['posts_per_page'];
}

It’s the only part where LIMIT for posts is added. And, as you can see, it is added only if nopaging is not set. So if posts_per_page is set to -1, then paging part of SQL query is not added.

So what can you do to work it around? You can set numberofposts to some big positive number.

Related Posts:

  1. How do I query a custom post type with a custom taxonomy?
  2. Get the ID of the latest post
  3. Return all custom meta data for one custom post type
  4. Fail to compare dates in meta_query
  5. Custom post type archive 404’s with paginate_links
  6. Display Custom Post Type Fields
  7. Loading Custom Post Type Events into jQuery-based FullCalendar?
  8. Limit the post for differents custom post type in the same wp_query
  9. order by meta_value serialized array
  10. Loading post content in FancyBox
  11. Multiple templates for custom post type
  12. Query post types with multiple keys
  13. posts_nav_link on single post template
  14. Used with meta_query in query_posts works slowly
  15. Query for posts in 2 taxonomies
  16. Prevent change with new query_posts()
  17. How to make an archive page displaying posts in a date range
  18. Get permalink and title by post name?
  19. Custom Post Type sorted by Title
  20. Get all posts WHERE custom_field is LIKE value
  21. Conditionally Query Custom Post Types by Post Meta for Blog Home Page?
  22. Display custom post types with custom date field value (before today) & order by custom date field
  23. reference the current category being used in the category.php page
  24. How to dynamically build a multiple taxonomy query loop within a post type’s single loop?
  25. List custom post type by custom tax term as page title
  26. Multiple post type queries (with specific arguments for each)
  27. Custom query works but returns “Undefined Offset: 0”
  28. What’s a better alternative to this code?
  29. Archive for custom taxonomy lists all posts instead of current taxonomy
  30. How to query_post custom posts within default taxonomy?
  31. How to use custom taxonomies to reference complex relationships?
  32. Order query using custom meta data
  33. Query Custom posts of same taxonomy as the post itself
  34. Get latest 3 posts from multiple CPT in one query
  35. Conditional Query of Custom Post Type and custom taxonomy
  36. will post_id ever change? Can I safely use post_id for custom queries?
  37. Show a Category X’s custom post type on Category X archive page?
  38. How to edit this code to get the categories in achieve page?
  39. Category with post type pagination returns 404
  40. Homepage’s content is dependent on the custom field values (set automatically), how do I get homepage to update without manually updating page?
  41. Query posts based on the meta key values of logged-in users?
  42. Different Ways to Query Custom Post Types?
  43. Listing all term items alphabetically / sorting loop
  44. query_posts adding extra code to homepage
  45. How to show only the most recent post on my custom post type archive?
  46. How to make WP_Query not to show irrelevant posts?
  47. What is the ID parameter for custom post types in query_posts?
  48. Loop for custom post types filtered by a taxonomy
  49. Why are some of my custom posts not showing up on my page?
  50. post-per-page and offset not working
  51. Custom post type, custom taxonomy, query posts only from taxonomy (children of)
  52. Querying multiple values from a single key
  53. find custom post type post by searching its custom field with my string
  54. FacetWP paging custom wp_query
  55. Can’t change posts per page in WordPress Post Type Query
  56. postsperpage value not being applied
  57. Incorrect ordering of custom post type based on time
  58. List all posts in taxonomy term
  59. Query all post types but limit to parents
  60. Query Multiple Custom Post Types & Exclude a Taxonomy Term
  61. Query Custom Post Type based on text input
  62. Custom Post Type Query W/Category Dropdown
  63. Query all posts under one taxonomy? Why is my code not working?
  64. Custom Post Types Not Showing Up In query_posts Result
  65. Find Posts based on Child Post value
  66. Custom Post Type ‘Event’: Chronological list of recurring events from meta_values in array
  67. Showing only posts from the current user who is logged in?
  68. returning the currect URL for nested posts
  69. Create a post automatically if search result has zero results
  70. custom post type and user post count shortcode
  71. Limit custom post type to the authors only on front-end!
  72. Posts per Page on custom Taxonomy Template
  73. Use WP_query to match post types based on custom field values
  74. minimize wp_query call to database
  75. Group Custom Posts Types in a Relation field of ACF
  76. Use WP pagination functions on a custom page template
  77. Getting Custom Posts with Custom Taxonomy
  78. How do I get the posts from single page custom post type from a sidebar to display in a page?
  79. How to set class to “current-page” on the currently viewed single post within a CPT
  80. WordPress custom post type
  81. Display 2nd category, only once, as sub-heading, in the loop
  82. WordPress custom post type queries
  83. query_post causes the posts to be loaded twice on load more posts
  84. Query Distinct Taxonomies of Custom Post Type
  85. Custom Query With Multiple Meta Key Value
  86. Ordering custom post type by custom field without a title
  87. How can I list custom post by custom category?
  88. Query Posts From Multiple Post Types
  89. Return only custom post types for the page, not all
  90. Advanced Custom Fields: query posts filtered by multiple field values
  91. WP Build-In Post selector for CPT
  92. How to apply order on custom taxonomy and custom meta key on custom post type
  93. send user to first page of results when reposting to page?
  94. Inserting two categories
  95. How to exclude certain portfolios from a loop
  96. Render a loop in Timber (twig for WordPress)
  97. show custom post’s post in two different divs [duplicate]
  98. How to get Custom post type by related category ID
  99. Quering array of post types & pagination. Articles are repeating sometimes on different pages
  100. Assign a tag to custom post type using a query

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedusedueduseduseduedueduseduedus