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. Post Query with Meta Query no longer working
  25. Meta_query compare operator explanation
  26. meta_query with meta values as serialize arrays
  27. How to print the excuted sql right after its execution
  28. Nested meta_query with multiple relation keys
  29. Can I force WP_Query to return no results?
  30. Resetting post data to previous loop in nested loops
  31. Some doubts about how the main query and the custom query works in this custom theme?
  32. meta_query ‘compare’ => ‘IN’ not working
  33. Get post count of current loop when using multiple queries on one page
  34. Multiple WP_Query loops with Pagination
  35. Pagination with custom SQL query
  36. Return only Count from a wp_query request?
  37. Using a custom WP_Query with get_template_part loop
  38. Use REGEXP in WP_Query meta_query key
  39. WP Query Args – Title or Meta Value
  40. Meta query with string starting like pattern
  41. compare meta_query in get_posts arguments
  42. How to query posts based on lat-lng coordinate as post meta?
  43. WP_Query vs get_posts
  44. how to show posts that are missing a meta_value
  45. Set Alias for meta_query arguments in get_posts()
  46. Sorting: custom query with orderby meta_value_num THEN by title
  47. Loop within a loop?
  48. WP_Query and next_posts_link
  49. Show posts without term
  50. Usage of the new “posts_clauses” filter in WordPress 3.1?
  51. How to list some posts first in the loop based on post id
  52. Pagination returns 404 after page 20
  53. Make loop display posts by alphabetical order
  54. WP_Query: query posts by ids from array?
  55. Use WP_Query with have_posts()?
  56. How to Compare Two Meta Fields
  57. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  58. how does $wpdb differ to WP_Query?
  59. get custom post type by tag
  60. Does tax_query really beats meta_query in all situations?
  61. How to get order of posts?
  62. Order posts by ID in the given order
  63. WP_Query with checkbox meta_query
  64. ACF Relationship Field Search Filtering [closed]
  65. Add indexing to meta_value in wp_postmeta
  66. Is it possible to orderby multiple meta_keys when using meta_value_num?
  67. Custom WP_Query order by post_meta and (author) user_meta
  68. Query WooCommerce orders where meta data does not exist
  69. Too slow when using both ‘tax_query’ and ‘meta_query’ both in WP_Query
  70. get_template_part in for loop
  71. Getting attachments by meta value
  72. Query Multiple Post types each with own meta query
  73. Get array of posts from the current archive page loop
  74. pre_get_posts with get_posts
  75. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  76. How-to exclude terms from the main query the most performant way?
  77. Pagination with WP_Query is buggy – working for some pages, but not the others
  78. Get the number of posts from the current page results
  79. Execute a large WP_Query with many “AND” Meta_Queries?
  80. Executing Queries in tag.php
  81. Display posts the match taxonomy term linked from wp_list_categoies?
  82. How can I save an array from a random post sequence for later use?
  83. How to place a loop within another loop?
  84. WordPress Custom Query to show posts from last x years
  85. Query causing load because of SQL_CALC_FOUND_ROWS post counting?
  86. Query all posts where meta value is empty
  87. How to order posts tag by tag?
  88. WP_Query min and max values
  89. Query Custom Meta Value with Increment
  90. “pre_get_posts” firing on every query
  91. Show two random posts from custom post type
  92. Add the “active” class only to the first loop item in a WordPress query [closed]
  93. Loop through all tags & output posts in alphabetical list
  94. Use WP_Query with a custom SQL query
  95. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  96. Pagination with 5 posts per page
  97. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  98. Using custom meta_query with relation not working as expected
  99. Identify which loop you are hooking into; primary or secondary?
  100. Perform query with meta_value date
Hata!: SQLSTATE[08004] [1040] Too many connections