Whats the difference between post_limits and pre_get_posts?

Note that here you’re overriding the paging of the main query, with the posts_limits filter, by using hardcoded values:

'LIMIT 0, 25'

where 0 is the offset and 25 is the number of posts to display.

So in this case I would just use pre_get_posts with

$query->set( 'posts_per_page', 25 );

and we don’t have to worry about the paging.

If i wanted to return 5 posts conditionally without paginating the
remainder, would i use post_limits or pre_get_posts?

If we later decide that pagination is necessary, then we would need to rework your posts_limits code. The pre_get_posts filter would work as is and we could therefore say that it’s at least a more “future proofed” method.

Another thing: If you were using get_posts() or WP_Query() with suppressed filters, then the posts_limits filter wouldn’t be available while the pre_get_posts hook would be accessible.

Related Posts:

  1. How to filter sql only for a specific post type
  2. WP_Query with “post_title LIKE ‘something%'”?
  3. How to add taxonomy filter on the query fly?
  4. Changing Posts Per Page and offset with pre_get_posts
  5. Is it possible to select against a post’s parent’s fields with WP_Query?
  6. Ignore a filter on the media library
  7. How to make an activities stream mixing posts and comments?
  8. SQL query equivalent to WP User Query
  9. Which filter/action hook gets triggered after a query has been performed?
  10. Advanced WP Query hogs the SQL server
  11. Remove ellipsis from the excerpt retrieved using get_the_excerpt()
  12. SELECT * FROM $wpdb->posts WHERE ID > 160
  13. Removing posts from the returned wp_query. Cannot use object of type WP_Query as array
  14. Use ‘parse_query’ filter to show posts that from multiple criteria
  15. Query post with meta_query where date is not in future
  16. What is considered a default query for the request filter?
  17. Using apply_filters(‘the_content’, $custom_query->post_content) alters output
  18. Modifying the Search Results
  19. Query total number of posts
  20. How to add post_distinct filter to WP_Comment_Query?
  21. How To Fix WP Query Returns Results But Shouldn’t?
  22. Using Ajax to load more posts | Help me change the wording on my button to notify the user
  23. List of the years with posts presented
  24. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  25. Slow WP_Query for custom post type
  26. Complex WP SQL Query
  27. Optional Meta Query
  28. Order by title without taking into account ‘the’
  29. Sorting events by descending date, and ascending time if multiple events on a date
  30. Editing the default wordpress search
  31. How to filter, restrict and return posts based on custom user meta information
  32. Filter posts in category archive page by year using a dropdown
  33. How to extract specific post
  34. Woocommerce – Changing the order of the upsell products [closed]
  35. Changing sort order for presentation by Jetpack infinite scroll
  36. Applying posts_clauses filter to specific queries only
  37. Add class to first post in custom loop using post_class filter
  38. Include data from custom table in WP_Query
  39. Add posts to WP Query object
  40. how to access query string in wordpress?
  41. Filter Custom Taxonomy Posts
  42. Debugging wp_query orderby for taxonomy
  43. Is it possible to query from external database? [duplicate]
  44. Include posts from some categories while excluding from others
  45. Include post content of linked posts in search
  46. Make a SQL query with wpdb in WordPress
  47. List of ways to access WordPress database?
  48. Filter post query to only show direct children of category
  49. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  50. Getting rid of unwanted nonSQL syntax characters when debugging a query
  51. How I can change the condition or compare operator for WP_Query in pre_get_posts
  52. Change AJAX filter from POST to GET for URL Parameters
  53. Using post_where filter only on main query NOT sidebard new WP_Query
  54. Filtering posts by archive showing all years
  55. Query where ANDing slug values not working
  56. WP_Query – How to get all posts of specific days of week by custom field date?
  57. Multiple wp_query on archive page
  58. Retrieve select tag custom values from array and display them in current page with wp_query?
  59. How to use a dropdown to filter posts by custom field
  60. Remove post type filter added by the plugin in the final query
  61. relation OR instead of AND – Filtered term ID’s in loop
  62. Can’t order the query result as given posts id’s array
  63. How to avoid filling up an array each time I run a WP_query?
  64. How to SQL query posts IDs by categories AND authors?
  65. filter posts by meta key with pagination
  66. Why does apply_filters behave different inside and outside a loop?
  67. Custom post type – filter content by custom meta box content
  68. Filter sub-category from checkbox form
  69. My combination of ‘post_type’ and ‘tax_query’ not working?
  70. SQL query injection with fifu image
  71. How to add a “base” filter for all posts visible to visitors on the site?
  72. WP Query – grouping posts by same meta key, adding together values from another key
  73. What is the equivalent WP_Query of a SQL Query?
  74. WordPress – Form does not filter the results of taxonomies
  75. Translating WP query into to SQL query
  76. Query Posts | Combining multiple form inputs into query arguments to generate one filter result
  77. Sorting query_posts() with a complex orderby filter
  78. Filtering posts for unique titles, only the most recent
  79. WP Query filters active on wrong query
  80. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  81. How to search CPTs in draft using get_page_by_title()
  82. Custom category page with taxonomy filters
  83. Gather same custom field values in one value in a select tag with wp_query
  84. WP_Query doesn’t works inside loop
  85. Track write actions to the database
  86. What argument does my function need to echo get_results() query results
  87. Fetch only categorized posts
  88. Add filter to Orderby Parameter using Array
  89. Custom WP_Query with SQL directives for getting posts by authors and terms
  90. query post based on comparison
  91. How to return value from sql and display it
  92. orderby in WP_query doesn’t works
  93. Do not show a custom post if it belongs to a certain custom taxonomy
  94. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  95. wp_query->set for several categories
  96. Adding arguments to WooCommerce Product Loop using AJAX
  97. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  98. Add custom argument to WP_Query and modify SQL where clause
  99. I need to get all categories from a WP_Query
  100. Group By query based on Custom Field

Leave a Comment