Returning a list of custom post types excluding those without a specific meta_value

Considering your current code I think you missed the WP Meta Query class which can do what you want;

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

Related Posts:

  1. WP_Query orderby custom field then post_date in one query
  2. Filtering a WP_Query meta_query by numeric values isn’t working
  3. Comparing timestamps in meta query doesn’t work
  4. Display two post types ordered by two custom fields
  5. Filtering by Post Meta Custom Fields – Performance
  6. WP_Query: include custom post type only with specific meta value
  7. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  8. wp_query check if integer exists in custom field’s array
  9. Possible to filter custom post type with multiple meta data?
  10. Query based on custom fields start and end date
  11. Getting a custom post’s custom field based on another custom post’s custom field select
  12. meta query multiple values for the same key
  13. Sort custom post archives by a meta value from a different custom post type?
  14. Custom post types – meta_query: search lesson which starts sooner
  15. Meta_Query refuses to return results
  16. Query events post type after current date and timezone
  17. Selecting posts older than the current Unix epoch timestamp
  18. Querying meta values within an array
  19. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  20. Multiple orderby values in WP_Query
  21. Using meta_query, how can i filter by a custom field and order by another one?
  22. Mixing regular and custom post types (with meta_query) on home page
  23. meta_query for keys that aren’t yet set
  24. how to filter by last name for custom post
  25. Filtering a WP Query result
  26. Querying custom post type with 2 custom fields (date-range)
  27. Display Custom Post Type Fields
  28. How Can I save multiple records in same meta key?
  29. Using Query Posts With Multiple Post Types And A Taxonomy
  30. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  31. WordPress query by multiple Custom fields and order by date
  32. Can’t sort order of wp_query with 2 meta keys
  33. Get post info inside modal window?
  34. WP Query group/order by category name
  35. query order by date on custom type: wrong order
  36. exclude custom post type by meta key in wp_query
  37. Having trouble with custom date field for CPT query (WordPress)
  38. Display posts if a custom field value is equal to another custom field value
  39. WP Query—Relationship between two custom post types and their fields
  40. How to dynamically attach pictures to a carousel
  41. Is it possible to apply a meta_query to one specific post type in a query with multilple post types?
  42. Custom Post type and Custom Field WP_Query
  43. Setting proper query for multiple custom admin filters
  44. WP_Query orderby modified to include custom meta changes
  45. WordPress custom loop filter by meta_key and value with serialize data
  46. Problem querying Custom post type by custom fields
  47. WP_Query order by custom field, then randomly order some of results
  48. How to do WP_Query with two meta fields with orderby clause
  49. Meta Query Not Returning Output Despite Having Matching Values
  50. Query Multiple Custom Posts by Custom Fields
  51. Why is this query not working? (Standard posts + custom post type)
  52. Get Posts by multiple custom fields is not working
  53. Order Custom Post Type by Custom Field Value
  54. First custom field value (out of several) displayed twice after query
  55. Meta Query posts not showing on ending date of custom field
  56. Configuring a meta query with multiple post types that have the same relationship on a single page
  57. filter search custom field query
  58. post_per_page ignored in WP_Query
  59. WP_query – Filter by tax_query and meta_query using multiple select
  60. find custom post type post by searching its custom field with my string
  61. Display custom post type for specific user
  62. Group by custom field value (start and end times)
  63. WP_Meta_Query object with conditionals
  64. Using WP meta query to show custom post types by a start and finish date
  65. Two queries – one with checkbox ticked, one without – comparing meta_query
  66. How do I list a custom field and custom taxonomies for each result in a loop?
  67. WP query_posts group by meta field related
  68. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  69. order the meta query results by 2 custom fields
  70. WP Query from two Custom Post type fields as statement
  71. Query custom post type that has a serialized relational advanced custom field value
  72. Using OR relation in meta_query to check for a value before sorting by another
  73. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  74. WP_Query get always custom post_type for first
  75. build child and anchestor three from post parent
  76. How can I query and sort custom-post type using WP_Query
  77. Custom query result empty on page 2
  78. Meta query and compare “!=” not working as expected
  79. Show posts from WP Custom Post Type selected from a field in a metabox
  80. Query custom post type and custom field by URL parameters
  81. post type => ‘any’ not applied my custom queries
  82. How to get the posts that my following users are liked?
  83. Sort loop by custom field from different post type
  84. Meta_query by date for Events archive
  85. Not able to get my custom search result using meta_query and tax_query together?
  86. WordPress query in which condition uses custom field
  87. Error in WP Query. If variable is empty it is displaying previous post value
  88. Querying, storing, and using data from 2 separate custom post types
  89. Custom Query With Multiple Meta Key Value
  90. WP_Query get posts where post_name is empty
  91. Query recent posts by author
  92. loop through custom post-type with two meta_keys
  93. Filter Custom post type by another Custom post type
  94. Get Posts ordered by a date custom meta field
  95. Order Wp Query by earliest of 3 dates meta query
  96. Function to Compare CPT Post Custom Value with Default Posts CF Value
  97. Display ACF object field data using Elementor Custom Query
  98. WordPress custom field sorting, weird behavior: the latest post is at the end
  99. Sort CPT by taxonomy AND THEN by custom field
  100. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?