How should I intercept the main query and inject custom join / order by / group by criteria

If I understood you right…

  • [A] Multi-Tax queries have the problem that they’re doing a JOIN of the meta table for every term. So imho it’s not the best idea to use the built in way.
  • [B.1.a] I’d simply do a normal query with a one (main-)tax arg and then do the sorting depending on the meta values. So actually just calling get_post_custom() and merging it with a single post object during a loop and then appending it to a resulting array.
  • [B.1.b] Then modifying the query through posts_clauses if some bits doesn’t meet the requirements.
  • [B.2] Start sorting for e.g. by name.
  • [B.3] Then I’d go and run some foreach/etc loop on the resulting array.

The benefit of browser/php vs. DB isn’t there so far (as long as the site hasn’t got much hits). But if you start minifying css/js/html and caching the resulting stuff (and delivering the results from the hard disk), I think this would be the way I’d go.

Related Posts:

  1. How to return results of a get_posts() in explicitly defined order
  2. Modify main WordPress loop with a parse_query filter
  3. Dynamically excluding current page id
  4. How to order results by date and meta key?
  5. Static Front-Page Excerpts
  6. Is it possible to query_posts using post__in and then Loop through them in the ordered they were queried?
  7. query_posts() ALWAYS displays something?
  8. How to remove a plugin filter’s priority on specific loops (custom queries)?
  9. Custom loops, sticky posts, and pagination nightmare
  10. Filter Loop by Custom Field Value
  11. Modify loop but keep the original query, what am I doing wrong?
  12. When to use WordPress loop or Foreach loop?
  13. Post per page not working if no category specified
  14. INSERT in table row fatal error
  15. Calling Posts from Specified Cat
  16. Most Effective Method? Exclude Category and Number of Posts Per Page
  17. How do I query based on the modified date?
  18. Script that gets the first tag of post and query all other posts with the same tag
  19. How to add an “or” instead of and “and” (&) in a WordPress query?
  20. Modify main loop query for paged and meta key
  21. Create a Loop with Posts Ordered by Most Recent Comments
  22. Query posts based on parents attribute
  23. query_posts and sub pages?
  24. The_content display a different content from a previous loop
  25. WordPress loop problem: Multiple loops, index.php and is_paged causing duplicate posts on next page
  26. Including post data in a sidebar occurring outside of and before the Loop
  27. Multiple loops with / without sticky posts and different post limits
  28. Some doubts about how the main query and the custom query works in this custom theme?
  29. Is there a way to exclude the content from the post variable to save on RAM usage?
  30. Display/query post formats
  31. How to query post by user role?
  32. query_posts() in function makes global $wp_query out of sync?
  33. WordPress Custom Query
  34. advice on creating a ‘related posts’ query like the one used on stackexchange
  35. order post my meta value m/d/y format with year as included value
  36. Order posts by custom field and if custom field is empty return remaining posts
  37. Using dynamic conditions in ‘posts_where’ filter
  38. List users with the most total posts view
  39. get_post_meta causes database queries
  40. Why is that gdsr_sort=thumbs (GD start rating plugin) only works with query_posts and not with WP_Query?
  41. Query_posts $query_string
  42. How to order posts by slug using query_posts/ Wp_query
  43. Order by meta_key with two meta_queries
  44. Search stores (custom postcode field) within 5, 10, 15 miles of user inputted postcode.. Code modification
  45. What is the difference between “manage_{$post_type}_posts_columns” and “manage_edit-{$post_type}_columns”?
  46. How to show only today’s post?
  47. Insert all post IDs in new database table
  48. use query_posts to return a post OR a page by ID
  49. ACF Custom Field WP_Query, but need to get all posts, if field doesn’t exist
  50. How do I make archives.php for one category only?
  51. query_posts for child pages
  52. orderby:date not working
  53. Placing post data (title, date, and excerpt) nested in static content
  54. Single meta key with multiple meta value in like comparison
  55. Inserting custom data to the_post() during loop
  56. Displaying terms based on loop posts?
  57. list child page items (1 level with meta keys)
  58. Sorting a query Field by date
  59. Trying to package posts for republishing by partner offsite
  60. How to order posts in an arbitrary order?
  61. How to order by multiple fields using standard query_posts?
  62. number of posts per page + random + exclude categories
  63. Pagination not working in category listing [duplicate]
  64. How to Query Post
  65. WordPress website loads more posts than expected
  66. query_post and wpdb returning different results
  67. Exclude current sticky post
  68. Using WP_Query and Query_post for the loop?
  69. Page title in post query
  70. query_posts pagination will always show identical content
  71. WordPress Custom Query to get Most Commented Posts in the Past 7 Days
  72. Conditional operator OR not working with custom fields
  73. Get posts that do not have the same tags as current
  74. Pagination not working on custom query on a page
  75. Loop through posts of only 2 statuses
  76. Should I reset $wp_query?
  77. Posts are not looping through correctly
  78. Query posts only with actual text content (not including shortcode or images)
  79. Display specific posts on home page
  80. Restrict query_posts by Date?
  81. How to solve this without flushing the rewrite rules for each post query the visitor triggers?
  82. Sort post by custom field numeric value
  83. Notting but the latest post content keeps on being loaded
  84. query_posts doesnt show pages with given ID when post_type => page
  85. How to put posts in pages using query posts
  86. Query add html after set amount of posts?
  87. Custom loop off by one post
  88. How to setup blog page to render blog posts minus afew categories
  89. How to get max value of filtered query post
  90. Ordering of posts, 2020 Year showing as next event when should be last
  91. Problem with my loops
  92. How to append the excerpt to the content in the single post page?
  93. How to add in WP_Query to every 3 posts displayed? [duplicate]
  94. Use special template for the first post in the loop
  95. How to display most popular post by views count in WordPress?
  96. show latest authors blog post
  97. Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
  98. query multiple posts by id using a string parameter, not array()
  99. Query posts in a category and include only one post per author?
  100. Use a woocommerce hook to create a table and populate it with a query

Leave a Comment

tech