Select only post id and meta value with WP_Query

You will need to create your own MySQL query to achieve this. You may use PHP builtin functions or WPDB which is a MySQL wrapped used by WordPress:

https://codex.wordpress.org/Class_Reference/wpdb

Related Posts:

  1. Should we trust the post globals?
  2. Get first post from wp_query
  3. Querying post from a multisite network
  4. How to query serialized array by comparing greater than (>=)?
  5. How to know if get_posts() failed?
  6. Show related posts by category but ignore one category
  7. post__in for get_posts with a dynamic array
  8. Query posts distinct authors
  9. How to get previous 10 days post from a specific date – WP Query
  10. Post content being duplicated by the_content();
  11. Specific loop in Shortcode
  12. Sort posts by activity date
  13. How to add padding between posts
  14. prevent showing posts of an specific category in admin posts section
  15. Working Bootstrap Carousel Conversion to WP – Technical Questions
  16. Search widget breaks when using multiple loops?
  17. How to change bulk post status
  18. Add few specific post ids to wp_query
  19. WP_Query posts_per_page ignored
  20. wp_query ‘s’ parameter does not work with custom post type
  21. WP Query related posts by current page Tag ID
  22. WP_Query get posts from custom posts by category
  23. Accessing post->ID outside of the loop for listing child pages
  24. WP Query – duplicated posts once including tags in search results
  25. List posts in a given category
  26. Reset Popular post query?
  27. Query Posts multiple conditions
  28. how to get posts ids inside pre_get_posts filter?
  29. Future post ID not showing
  30. How do I use WP_Query to get a range of posts with custom fields that have numbers with letters in them?
  31. recent posts for different categories
  32. Search by post title and content in wp_query without order
  33. Change post order random through out the entire WordPress
  34. Setup a custom dynamic post
  35. Anyway to grab author name and featured image in an embeded in inital array of posts outside of loop?
  36. Removing noindex posts from wp_query
  37. How safe is renovating $wp_query when doing WP_Query pagination in Page Template
  38. posts_per_page option limits the number of Gallery items
  39. wp_query random post
  40. how to get post order by post id wp_query?
  41. Possible to alternate between two loops
  42. How to display all posts divided/ordered by post date? [closed]
  43. Is it possible to use WP_Query to only pull posts with attachments?
  44. Every second post different class in blog view
  45. Get posts with multiple categories
  46. Do not show children of a category
  47. Display posts of specific category term
  48. Can’t understand why sometimes a [caption] field appears
  49. search blog posts by author first name and or last name
  50. Display current post position in Elementor Posts widget
  51. Why in my query is display two title?
  52. wp_query with ajax
  53. How to give classname to post if post has no content?
  54. Custom wp-query in wordpress rest api
  55. posts_per_page returning only one post
  56. Need to know custom code to display random and most viewed posts in wordpress posts and pages
  57. How to retrieve certain number of images from a wordpress post?
  58. WordPress post filter menu
  59. How to display post list in a table layout (multiple queries in single loop)
  60. WP_Query custom field pass the post id
  61. How to convert query sql to shortcode in wordpress?
  62. Use posts_where to exclude posts ids from wp_query
  63. Current and next month posts
  64. Why does WordPress search returns same number of results for every search query?
  65. Same post appears in related Posts?
  66. Sidebar limiting to 10 posts?
  67. Override WordPress core post-template.php block template
  68. WP_Query outputs wrong post in custom post type
  69. how to show comments only author which send own posts in wordpress
  70. Change Old WordPress Post Date Year
  71. Display/Filter post using if else statement
  72. How to sort WP_Post Object array by object field in php?
  73. Search results for ACF data
  74. Query prints posts without specific categories
  75. Numbered Pagination Showing The Same Posts After Altering WP_Query
  76. Order by meta_key field in WordPress not meta_value field value
  77. How to create page with post content in it?
  78. How to remove a post from results by ID after query?
  79. Override wp_link_pages pagebreak with filter
  80. Loop through all posts showing duplicates
  81. WP_Query extended with AJAX
  82. Manipulate query to show specific post
  83. WordPress text field in array problem
  84. Random order of the 5 most popular posts
  85. My custom query is displaying random posts in random order
  86. Get query result according to merged array
  87. Blog only showing one post even though more published
  88. Sort / Filter Queries
  89. How to show the posts list into a static page? Problems to use the loop into a static page
  90. How do I control the fallback query after the original query returned cero posts?
  91. Order posts by separate menu order for different sub-categories
  92. Adding a category at even positions on main loop with modified pagination
  93. Displaying Results From Custom Taxonomy Query
  94. Multiple loops on a Search result page?
  95. What is wrong with this wp_query?
  96. WP_Query: Fetch posts that are in (category1 and not in category2), OR posts that are not in cagegory1
  97. Exclude sub sub categories from displaying in the archive page
  98. How do I show the post title if an advanced custom field hasn’t been used?
  99. How add class the_content();?
  100. Image inside the content is replaced with featured image from my older post