Use have_posts() with array of post results retrieved by $wpdb->get_results

setup_postdata will let you use loop functions with post results via get_posts.

another option is to use the various filters available to alter WP_Query‘s behavior- posts_join, posts_where, posts_orderby.

Related Posts:

  1. Custom loop – Isolating post meta output depending on current query taxonomy terms
  2. Display products from specific category in shop page
  3. Exclude post on loop by multiple meta key value
  4. How to change a custom query into a standard loop?
  5. How to query ‘posts_per_page’ to display a different blog posts index template?
  6. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  7. Query sticky posts with thumbnails
  8. WP_Query on custom field and order results
  9. Any number in meta key (wp query)
  10. Filtering posts from different categories into different section by doing WP_Query only once
  11. WordPress query with items from more than one selfdefined taxonomy as `term` argument
  12. Query most popular terms by taxonomy over 2 week period
  13. Custom taxonomy.php not working
  14. Array as ‘key’ in WP_Query
  15. How to provide meta_key array to wp_query?
  16. Wp_query with 2 meta keys and array of meta values
  17. Meta query compare for ID’s greater than specific ID
  18. WP_Query not returning correct result with meta_query parameter
  19. show most viewed post
  20. Meta Query if Values Don’t Exist
  21. Custom query (author is post_author or meta co_author) with Pagenavi pagination
  22. Output ACF field dynamicaly within a taxonomy loop [closed]
  23. get_post_meta bringing back results, but $wpdb->postmeta doesn’t
  24. Pagination with custom SQL query
  25. How to list some posts first in the loop based on post id
  26. Add indexing to meta_value in wp_postmeta
  27. Custom WP_Query order by post_meta and (author) user_meta
  28. WordPress Custom Query to show posts from last x years
  29. How to order posts tag by tag?
  30. Pagination with 5 posts per page
  31. Perform query with meta_value date
  32. Custom archive page based on array of categories and tags
  33. How can I connect to another WP database and use WP_Query?
  34. datetime picker, timestamps and meta queries
  35. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  36. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  37. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  38. Order WP Query posts by custom order calculated from post meta values
  39. how to speed up a complex wp_query?
  40. How to query for custom field within Gutenberg block from outside of that post? [closed]
  41. WP_Query doesn’t get sticky post at the top, when used in a page template
  42. Meta Query for specific months
  43. Meta query with JSON value
  44. Prevent duplicate post from dynamic multiple loops
  45. Get meta info related to current post
  46. if/else on custom query gives 200 OK when condition not met?
  47. Creating arguments from loop for WP_Query meta_query
  48. Select from wp_post and multiple meta_value from wp_postmeta
  49. Multiple Loops Inside a Function
  50. Sticky posts are not showing at the top of category posts
  51. ACF Date Based wp_query
  52. Using meta_query with multiple keys and compare values
  53. Can I set my WP_Query to be a Main Query?
  54. Mysql query and order meta value
  55. Group and list posts by custom taxonomy
  56. Show scheduled posts in main loop but not in WP_Query?
  57. meta_query BETWEEN, but the range is stored in the custom field
  58. Is it possible to set specific posts to show first in a query?
  59. Order ascending is ignored in meta query?
  60. How to get list of posts from permalinks?
  61. different for loop if screen resolution < 1000px
  62. Ajax future single post query doesn’t work when NOT logged in
  63. Conditional sorting with variable using WP Query
  64. Advanced WP_Query with meta_query, orderby?
  65. sort and display posts by custom field (wp-query and the loop))
  66. Issues with search after added meta_query
  67. WP_Query: apply an SQL function to meta fileld value
  68. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  69. How to create dynamic value in WP_Query meta_query
  70. query post by author gender
  71. Filtering by multiple conditions in the loop
  72. How to access $wp_query object from array of posts given by get_posts?
  73. Display all attached image of every post of custom post type and link to original post
  74. How do I add an item to the WP admin menu?
  75. Multiple meta query from array
  76. WP_Query with 4 post meta field arguments gives 500 internal server error
  77. WordPress Queries Not Working?
  78. Filter subpages in while loop from WP Query object
  79. What’s missing in this wp_query and meta_query
  80. duplicated posts when using pagination
  81. How can I have sticky posts while ALSO showing posts from a specific category using one WP_Query?
  82. Trouble with serialized metadata
  83. meta_query order by date present -> future then show null
  84. display the children of the post using the current page as the main parent
  85. Display 3 levels of categories on page
  86. Custom post type loop error: Trying to get property of non-object
  87. In Product Category archives how to show Posts having same/similar prod_cat slug structure?
  88. How to make a wordpress loop file that displays posts based on certain conditions
  89. WP_Query with MetaQuery issue
  90. How do I display posts with specific value in a custom field into my loop?
  91. Orderby Meta Value and Query from Meta Query
  92. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  93. Order by multiple meta keys on wordpress
  94. Sort posts in dashboard using custom field; also include posts where field isn’t set
  95. Display First posts without the default featured image
  96. WP_Query with several meta_query-statements and order by meta_value
  97. wpdb LIKE request shows all database data
  98. How do I split a large query with a semi-expensive function included into multiple smaller queries
  99. Query All Posts: Either Display Most Recent or One with Particular ACF Value Chosen
  100. Display only posts with thumbnails