WP_Query post at custom position

Pagination should be easy. You really just need to add pagination parameters to your query, and next/previous posts links, more or less like in another thread I posted in recently.

$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
$my_query = new WP_Query( 
    array(
        'showposts'=>10,
        'paged'    => $paged 
    )
); 
// run the loop then, 
// pagination links ...
var_dump(paginate_links( array(
    'base' => str_replace( $big, '%#%', esc_url( get_pagenum_link( $big ) ) ),
    'format' => '?paged=%#%',
    'prev_text' => __('« Previous'),
    'next_text' => __('Next »'),
    'current' => max( 1, get_query_var('paged') ),
    'total' => $my_query->max_num_pages
) ));

But… getting a two to one ratio in every result set isn’t.

I believe that I could pull this off with a custom SQL query (using a UNION) and $wpdb->get_results or $wpdb->get_col. However, the pagination would be a little tricky and you don’t get WordPress post objects that way so chances are you’d need a second query to create those (and you nearly always need them). The minimal SQL would look something like…

(SELECT ID FROM {$wpdb->posts} WHERE post_type="post-type-1" LIMIT a,b) UNION ALL (SELECT ID FROM {$wpdb->posts} WHERE post_type="post-type-2" LIMIT c,d)

The tricky part is getting the values for those LIMITs right.

In principle, with the right filters– posts_where, posts_fields, etc.— you should be able to alter a query to match the custom SQL alluded to above, but again the pagination would be a little tricky and the actual query that WP_Query uses is more complicated so you’d have to match that when you build the UNION.

With either of those solutions it might be necessary to sort the results before echoing them. I’d have to set up the queries, test it, and see.

Ultimately, I can’t convince myself that that either of those solutions are better than the simple and obvious one of just running two queries. I understand that you want to keep the query counts down. So do I, but sometimes two queries is the right move. Unless your server is severely underpowered or your site very badly designed in many other ways, two queries vs one for this page won’t make a difference.

So…

Is it possible in ONE query with filters or any other way ?

Yes, I think it is possible but you would have to use filters to radically alter the query and I don’t think it is worth the time it would take to develop the solution and I don’t think it is worth the saving in execution time that you may or may not get out of it.

Related Posts:

  1. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  2. Order posts alphabetically with numbers but some of the posts has numbers in the title
  3. SEARCH QUERIES – REVERSE OUTPUT
  4. Display all posts in a custom post type, grouped by a custom taxonomy
  5. How to use a custom post type as front page?
  6. Sort Order for a Custom Query in a Post Type Archive Not Working
  7. Display several random posts, but make sure a condition is met
  8. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  9. WP_Query to loop a Custom Field, Custom Post Types do not show
  10. Retrieving 3 latest post from each of 5 different custom post types
  11. WP_Query on custom post type not displaying, multiple loops & get_template_part
  12. How to show posts from multiple post types in a single loop? And display them separately on the same template
  13. How to create posts (not post template) to be displayed on projects page?
  14. WooCommerce – Show orders for a specific product ? [closed]
  15. Re-order posts in query after
  16. Query Custom Post by Category
  17. How do I Use Nested Loops of Custom Post Types for MultiSite Blogs using WP_Query()
  18. WP_Query and using a variable for ‘cat’=> in the args array = WP Bug?
  19. Separate Posts and Custom Post Type in Custom Taxonomy archive template
  20. Impossible to get Attachments Outside WordPress?
  21. Why does using WP_Query inside a shortcode in an elementor page cause the arguments for WP_Query to get malformed?
  22. Lists Posts from CPT that match the Title of the Page
  23. How to query different post types in specific order?
  24. Help Structuring Query for Archive Pages
  25. Loop on front-page.php
  26. wp_query to find posts by year and month
  27. WP_Query | ‘post_type’ doesn’t work
  28. Filter by custom taxonomy slug on a custom post type
  29. Query custom post type in the loop
  30. Loop through Custom Post Type, and then show children within each iteration
  31. Very Slow Page – How to Optimize # of Queries?
  32. Can I create a loop with multiple post types and specify different $args for each post type?
  33. WP_Query orderby modified to include custom meta changes
  34. How to make sure content doesn’t display if selection is empty
  35. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  36. Previous/Next Link by Meta Value in CPT
  37. Wp_query: sort by PHP variable
  38. Custom loop with multiple taxonomy queries
  39. How to do WP_Query with two meta fields with orderby clause
  40. What’s the WP way to load remaining custom posts?
  41. WP Query with categories only shows one post and ignores the category
  42. Order Custom Post Type by Custom Field Value
  43. Change sort order when using ‘orderby’ => ‘type’
  44. pagination not working for category.php (custom post types in categories)
  45. WP Query post__in not returning correct results
  46. Sort posts in loop by the WooCommerce Membership of the author
  47. 4 column-loop ordered alphabetically with entries grouped (and labeled) by their first letter
  48. How can I group posts by months and years?
  49. Multiple Custom Post Type queries, how to DRY it up
  50. Custon Content within WordPress Loop
  51. get_pagination not working on a custom post type query (using WP_Query)
  52. WP_Query with custom post type ID
  53. WP_Query of custom post type sorted by meta_key has unexpected results
  54. WP_Query not resetting after wp_reset_postdata
  55. display posts of custom post type with custom taxonomy
  56. Trying to add a class to post links
  57. postsperpage value not being applied
  58. Display the current post in browser as the first post in a loop (for a slideshow)
  59. Display post from custom post type
  60. foreach loop inside the loop creating duplicates in output
  61. How to retrive Custom Post Type Meta Fields in Custom WP_Query
  62. How to fetch posts that are stored in the different table than (default) wp_posts?
  63. Cant’ Display Custom Post Type Title Base on Tax Terms
  64. Loop for custom-post-type comparing taxonomy terms for “related” posts?
  65. Custom post type pagination error
  66. What is the most efficient way to execute recursive complex queries?
  67. posts_per_page in custom WP_Query does not override “Reading” settings?
  68. Display Parent-Child Posts in specific order by comparing IDs in array
  69. How can I sort the results of a REST API response by the title of a connected custom post type?
  70. Pagination Not Working When Used With WP_Query() `offset` Property
  71. Custom meta fields not showing up in WP_Response Object via custom endpoint
  72. post_type incorrect for custom post type
  73. Staggering featured post using ‘sticky’
  74. Wrapping an unknown amount of posts inside separate HTML Containers during WP_Query loop
  75. subtracting the current post form then whole loop, which is generating all CPT titles
  76. Mix Facebook and Twitter feed into custom posts
  77. sorting in wp query based on custom field value
  78. Custom post Query and WordPress Post Query Clash
  79. WordPress loop add heading before first of type
  80. Only show current category post
  81. How to make a shortcode for my WP_Query Loop? [duplicate]
  82. Strange behavior on WP_query
  83. get_post_meta for Custom Post Type ( CPT )
  84. Orderby modified only for specific post types
  85. How To Loop Through list with Custom Post Types
  86. Is it possible to add query parameters on the archive page?
  87. Custom Post Type + Category archive
  88. Loop with Custom Post Type and Taxonomies
  89. display news with pictures 3 small and one large (loop)
  90. How can I pull information from my loop and divide them seperately?
  91. Fallback if statement based on the number filtered from it
  92. Create custom post order (with custom post type meta)
  93. 404 on Pages for Custom Post Type & Query_Posts
  94. Custom post-type’s pagination not working in category.php
  95. Query Custom Post Type by Tag
  96. Fourth page of custom post type archive page does not exist
  97. Catergory args causing loop not to show
  98. Query order by meta value force specific tag first
  99. Order Wp Query by earliest of 3 dates meta query
  100. How can I show posts with the same tag?

Leave a Comment