How to change a custom query into a standard loop?

How I have done custom queries in the past is use $wpdb->get_col() and just returned an array of IDs of the posts. Then I pass that to a get_posts() passing the IDs to the post__in parameter. That way you can then use WP standard controls.

Related Posts:

  1. Filtering posts from different categories into different section by doing WP_Query only once
  2. Use have_posts() with array of post results retrieved by $wpdb->get_results
  3. How to print the excuted sql right after its execution
  4. Can I force WP_Query to return no results?
  5. Resetting post data to previous loop in nested loops
  6. Some doubts about how the main query and the custom query works in this custom theme?
  7. Get post count of current loop when using multiple queries on one page
  8. Multiple WP_Query loops with Pagination
  9. Pagination with custom SQL query
  10. Return only Count from a wp_query request?
  11. Using a custom WP_Query with get_template_part loop
  12. WP_Query vs get_posts
  13. Loop within a loop?
  14. WP_Query and next_posts_link
  15. Show posts without term
  16. Usage of the new “posts_clauses” filter in WordPress 3.1?
  17. Display products from specific category in shop page
  18. How to list some posts first in the loop based on post id
  19. Pagination returns 404 after page 20
  20. Make loop display posts by alphabetical order
  21. WP_Query: query posts by ids from array?
  22. Use WP_Query with have_posts()?
  23. how does $wpdb differ to WP_Query?
  24. get custom post type by tag
  25. How to get order of posts?
  26. Order posts by ID in the given order
  27. Too slow when using both ‘tax_query’ and ‘meta_query’ both in WP_Query
  28. get_template_part in for loop
  29. Get array of posts from the current archive page loop
  30. pre_get_posts with get_posts
  31. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  32. How-to exclude terms from the main query the most performant way?
  33. Pagination with WP_Query is buggy – working for some pages, but not the others
  34. Get the number of posts from the current page results
  35. Executing Queries in tag.php
  36. Display posts the match taxonomy term linked from wp_list_categoies?
  37. How can I save an array from a random post sequence for later use?
  38. How to place a loop within another loop?
  39. WordPress Custom Query to show posts from last x years
  40. Query causing load because of SQL_CALC_FOUND_ROWS post counting?
  41. How to order posts tag by tag?
  42. Query Custom Meta Value with Increment
  43. “pre_get_posts” firing on every query
  44. Show two random posts from custom post type
  45. Add the “active” class only to the first loop item in a WordPress query [closed]
  46. Loop through all tags & output posts in alphabetical list
  47. Use WP_Query with a custom SQL query
  48. Pagination with 5 posts per page
  49. Identify which loop you are hooking into; primary or secondary?
  50. In loop: posts have thumbnail AND other variables
  51. How to make an activities stream mixing posts and comments?
  52. Group posts by custom field
  53. How to order category.php loop by ‘meta_value’?
  54. Pagination/infinite scroll with WP_Query and multiple loops
  55. Merging a complex query with post_rewind and splitting posts into two columns
  56. Sort posts by custom taxonomy name
  57. How can I connect to another WP database and use WP_Query?
  58. Add inline HTML to posts published within last 24hrs
  59. Move posts to top of WP_Query if in certain Taxonomy?
  60. Loop inside the loop
  61. Pagination Not working on Home Page with 2 Query
  62. meta_query not working properly
  63. Ajax Infinite Scroll In Custom WP_Query Loop Not Working
  64. Display different number of posts from one category on the different pages
  65. Looping through tabular data
  66. Trying to list out child pages with WP_Query
  67. Exclude post on loop by multiple meta key value
  68. Pagination not working Search posts
  69. Get number of comments after modifying comment query
  70. Transient pagination not working properly
  71. Show default content if custom WP_Query has no posts
  72. get_posts() seemingly ignoring post_type
  73. cloning a WP_Query
  74. Injecting content with $wp_query->current_post restarts from zero on paged pages. How to inject content after X posts, regardless of pagination?
  75. How to query ‘posts_per_page’ to display a different blog posts index template?
  76. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  77. Display featured products through custom loop in WooCommerce 3 [closed]
  78. Woocommerce custom loop to show all the products [closed]
  79. Sort by meta key on archive page
  80. Exclude first 5 posts of specific categories in the main loop
  81. How to bring specific post to front of wordpress loop?
  82. meta_query on a date range using an array of values
  83. How to display 3 different loops in 3 columns on homepage
  84. How is WP_Query connected to WP_Post in The Loop?
  85. Should close $wpdb via $wpdb->close()
  86. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  87. Can certain (site-crashing) limitations on WP_Query in shortcode be overcome?
  88. Query sticky posts with thumbnails
  89. Show all parents and children in custom post type in right order
  90. Why is this coming back as null? Thats wrong. There is one post
  91. How to show the posts of some category first, and then all other
  92. Why execute the_post()?
  93. wordpress query in header won’t reset and corrupts other loops
  94. Ignore post by meta value in the main query
  95. $wpdb->insert inserting two rows in database
  96. Pagination stops at page 6
  97. Paginated HTML Sitemap
  98. WP_Query to get posts in a specific category and post format
  99. Multiple WP_Query loops with Pagination Not Working
  100. Get the Plugin Which Triggered a MySql Query in WordPress?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)