post__in for get_posts with a dynamic array

Here’s one way by using wpdb::get_col() and fetch the id column:

$pids = $wpdb->get_col( "SELECT id FROM my_table" );

We could then clean it by integer convert each id with:

$pids = wp_parse_id_list( $pids );

Just note the different max value for intval(), depending on 32 or 64 bits systems.

Related Posts:

  1. WP_Query to work with custom view
  2. Replace Main Query With Custom Query
  3. How to do set post permalinks using 6 digit random unique function?
  4. wp_posts table: safely remove unused columns to save database storage
  5. Why Query is returning empty array?
  6. meta_value timestamp older than now
  7. WP_Query post_tilte search in posts table
  8. Adding additional data to WP_Post object
  9. WP_Query: Why is sticky post not first item in loop?
  10. Displaying the category name of a custom post type
  11. How do I reorder (pop and push) items from WP_Query?
  12. How to exclude latest x posts from a paginated query?
  13. Reverse chronology of post listing
  14. WordPress Number of Posts Not Changing With posts_per_page
  15. How to add posts to wp_query result?
  16. Posts for next month
  17. Exclude posts with specific meta_value while sorting by a separate meta_value
  18. WP_Query only ONE post, won’t work
  19. Unable to modify(update) posts – Page not found
  20. Display the latest posts, published in the last hour, with WP_Query
  21. Fetch posts from current week (Sunday to Saturday)
  22. Hiding posts in a list from specified categories
  23. Converting multiple loops into one single loop with pagination
  24. Group posts by year in loop
  25. How would I get 1 latest post from a query for 5 posts?
  26. How to get posts by multiple post slugs? [duplicate]
  27. WP_Query do not load specifed number of post
  28. WP_Query: offset ignored when posts_per_page is -1?
  29. Exclude posts with empty post_content in wp_query
  30. Exclude posts from featuring
  31. Lazy Load using WP_Query pagination
  32. AJAX filter posts by year
  33. How can I remove posts of a certain category from homepage after a specified time period?
  34. Should $found_posts be returned as string in ‘found_posts’ filter hook?
  35. Get random posts between specific dates / of specific age
  36. Yearly archive page for future year
  37. Display post from current category and same tag?
  38. WP_Query orderby not working with meta_value_num and menu_order
  39. Custom WP_Query with complex ‘post_status’ argument
  40. is there a way to show the the post title after the image?
  41. How do I correctly set up a WP-Query to only show upcoming event-posts?
  42. Blog post per page setting conflicting with custom WP_Query?
  43. How to filter my search in post if contains a word in title, content or excerpt?
  44. How to return another post than requested
  45. Select only post id and meta value with WP_Query
  46. Random ajax load only works with posts_per_page set to -1
  47. Query posts and return XML
  48. Query Posts With Over 1000 Views
  49. Adding a blog archive with pagination using WP_Query
  50. How to get Tags with specific post id
  51. Show post content and title in diferent divs using WP_Query using a loop
  52. Show posts by author of membership level (Paid Membership Pro)
  53. Why posts array is empty?
  54. Page and post loop same template
  55. How to check in functions.php if there is data in a WP_Query?
  56. How can I insert a new markup element after 4 posts automatically? [closed]
  57. If no posts exist for current day and month, show the next available day of posts
  58. Related Posts function not working
  59. how to handle the loop using filling bootstrap grid structure?
  60. Query function not executed between element [closed]
  61. Custom WP_Query not working correctly
  62. Echo the number of posts being displayed
  63. remove all custom post created
  64. Creating a related posts section in wordpress inside a default post
  65. How to display WP Query filters?
  66. Finding a post’s slug
  67. Is there a function to get post info for any publish_status by post ID?
  68. How Can I Always Display A Particular Post First Using WP_Query?
  69. Optimal WP Web App Backend for mobile app development
  70. How do I display main query posts in random order using add_filter
  71. Why sorting posts doesn’t work properly?
  72. the wp_post_update isn’t working all the time
  73. Display specific posts based on an ID of another post
  74. query posts with selected post ids first
  75. Change URL of previous posts and next posts link in WordPress
  76. Order posts inside bootstrap card columns
  77. long-title posts do not want published
  78. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  79. Counting Posts by Category
  80. show image gallery in archives or category page
  81. Page with Category Returning 1
  82. wp_query args with relation
  83. WP_Query sort by meta_value_num or date
  84. Get 5 most recent categories
  85. Creating Ordered Query using Meta_key
  86. I am not getting result from php function that is json encoded
  87. WP Query between posts custom fields [duplicate]
  88. Retrieve latest post by multiple categories with ID
  89. Update Post with Modified Data
  90. How to Include a common category in a custom Category Search
  91. wp_query select if have comments
  92. wp_query posts sorting doesn’t work
  93. Order by ‘s’ using WP_Query()
  94. custom sort posts in archive/taxanomy page
  95. how to print loops for odd in 1st column and even in 2nd column in wordpress [closed]
  96. Trying to create shortcode listing custom posts, but formating not being included
  97. Show Title/Date/Excerpt of first post & only Title for rest in Query [duplicate]
  98. Get posts after calculating meta key
  99. Next and Previous buttons are not showing on home page for post
  100. Get related posts matching most of the provided tags using WP_Query

Leave a Comment

error code: 523