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. Nested meta_query with multiple relation keys
  25. WP_Query vs get_posts
  26. Order posts by ID in the given order
  27. Query Multiple Post types each with own meta query
  28. How-to exclude terms from the main query the most performant way?
  29. Pagination with WP_Query is buggy – working for some pages, but not the others
  30. Get the number of posts from the current page results
  31. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  32. Ajax Infinite Scroll In Custom WP_Query Loop Not Working
  33. WP Meta Query for some meta (array) values
  34. Get number of comments after modifying comment query
  35. Injecting content with $wp_query->current_post restarts from zero on paged pages. How to inject content after X posts, regardless of pagination?
  36. WP Query – Get WooCommerce Products with variation that is in stock
  37. Meta_query with or without value
  38. $wpdb->insert inserting two rows in database
  39. Get image of latest post from taxonomies/categories
  40. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  41. 2 loops on page – one with orderby rand second orderby date
  42. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  43. wp_query not searching with apostrophe
  44. $wpdb select date range of posts
  45. Counter problem, infinite loop when post_per_page equals X
  46. How to delete taxonomy term when a wordpress user is removed?
  47. Custom query based on meta key – Reduce three states to two in results?
  48. Performance when getting post meta for post retrieved by meta value
  49. Wp_query function to search from product_title ‘OR’ product tags name
  50. How to display multiple custom fields with the same meta_key in an ascending order?
  51. Using the_post_thumbnail resets current loop item ID
  52. Meta_query with multiple keys and multiple values
  53. Tax query AND/OR meta query [duplicate]
  54. Help ordering Post loop by two meta values
  55. New WP_Query loop in admin causes problems
  56. Need to convert string of term ids into comma separated integers for use in an arguments array
  57. How do I get my custom query to work with search results after the first page?
  58. Issue with front page navigation after upgrading to 3.4
  59. Exclude recently updated post from custom WP_Query using multiple loops
  60. get_posts output always same post
  61. difference between querying database and using the loop
  62. Stomping WP_Query in author archive to facilitate pagination with custom queries
  63. Appending to existing WP_Query’s meta_query if exists
  64. Continue or break the while loop
  65. Loop posts based on permalink term
  66. Custom query filter by ACF date custom field
  67. Error in meta_query not get result
  68. Does putting queries within loops cause an issue on WordPress?
  69. How to get current page nearest parent id?
  70. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  71. Sort posts using multiple custom fields and menu_order in single query?
  72. Order (by ASC) posts with meta_key so posts without values are last
  73. Search filter between promo and exact price
  74. Bootstrap grid while loop
  75. Why can my filter query SOME metadata but not other metadata?
  76. Getting posts by custom field value
  77. How can I use WP_Query to sort ‘event’ custom post type by date?
  78. wordpress multiple meta value query is not working
  79. Strange results from WP_Query
  80. Display posts side by side with custom query
  81. Pre get posts sort by meta key returns no results if meta key does not exist
  82. WordPress For Loop Prints Unwanted Extra Paragraph Element
  83. WP Query for Multiple Post Types
  84. Order Posts By Custom Field That is an array of objects
  85. Orderby query does not work for custom fields even with meta query
  86. Select Unique Posts for a List of Tags
  87. Some doubts about how the main query and the custom query works in this custom theme?
  88. Ordering Posts by parent category, name ascending
  89. Use not custom fields in get_posts() meta_query?
  90. WP_Query a custom field value bringing back 0 results
  91. Set Transient on CPT
  92. Load 3 posts in flexslider slide [closed]
  93. Multiple wp_query loops showing first 5 posts on all pages instead of older posts[Resolved]
  94. How to exclude posts ordered by comment_count from subsequent wordpress loops using WP_Query?
  95. $query conflicting with other queries in the same page
  96. WordPress Post Looping? [duplicate]
  97. Wp query by 2 meta field – check if they exists / have value
  98. Show linked products using wp query and woocommerce
  99. Standard Loop – wp_query
  100. Custom Wp_query loop takes very long