WP Query – Show custom posts only if user contain some user meta

You could approach in two steps. First get all the users that match your criteria

$user_ids = get_users([
    'meta_key' => 'activeacc',
    'meta_value' => true, // or whatever value you are storing
    'fields' => 'ID',
]);

and then run your WP_Query for only those users

$properties = new WP_Query([
    'post_type' => 'property',
    'author__in' => $user_ids,
]);

There is no need to set post_status => 'publish' since it’s the default.

Also would be possible to accomplish the same in just one query with posts_clauses filter but I will not develop it here.

See https://developer.wordpress.org/reference/classes/wp_user_query/prepare_query/ for all available arguments for get_users.

Related Posts:

  1. Nested meta_query with multiple relation keys
  2. Query Multiple Post types each with own meta query
  3. Perform query with meta_value date
  4. Meta Query with date and time on the same Day before given time
  5. How do I create my own nested meta_query using posts_where / posts_join?
  6. How to query ‘posts_per_page’ to display a different blog posts index template?
  7. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  8. WP_Query last five posts, simply ordered by meta_value
  9. Fetch Record based on meta key dates
  10. How to display multiple custom fields with the same meta_key in an ascending order?
  11. how to make members list directory through wordpress post custom meta key.
  12. How to provide meta_key array to wp_query?
  13. Show single posts date, in a page of posts
  14. Why doesn’t my WP Meta Query return any results?
  15. WP_Query Class custom field parameters
  16. How do i create a custom post query when the meta value is an array?
  17. ElasticPress is (aparently) messing with my search filters
  18. Query for current post
  19. Custom query to retrieve oldest post and retrieve others with date interval
  20. Orderby query does not work for custom fields even with meta query
  21. Custom WP_query and integrating into theme file
  22. query post based on comparison
  23. WP_Query vs get_posts
  24. Order posts by ID in the given order
  25. ACF Relationship Field Search Filtering [closed]
  26. Get the number of posts from the current page results
  27. Execute a large WP_Query with many “AND” Meta_Queries?
  28. How to know which one is the main query?
  29. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  30. Is “orderby” in WP Meta Query conflicting with Meta Query?
  31. WP Meta Query for some meta (array) values
  32. Sort users by meta_value_num
  33. meta_query with array as value
  34. Using WP Query to search within ALL keys in meta query
  35. WP Query – Get WooCommerce Products with variation that is in stock
  36. Multiple search queries on one page
  37. Meta_query with or without value
  38. How add a custom posttype name using ACF field to a query post array
  39. Meta query field order together with post_date order causes posts without the meta field to be unordered
  40. Page navigation doesn’t show when query category
  41. Undefined property: WP_Query::$post
  42. 2 loops on page – one with orderby rand second orderby date
  43. WP_Query meta_query >= date
  44. wp_query not searching with apostrophe
  45. Extending woocommerce admin product search
  46. Custom query based on meta key – Reduce three states to two in results?
  47. Five posts from a category in footer
  48. Performance when getting post meta for post retrieved by meta value
  49. Query by multiple meta elements not seeming to work – wordpress is timing out
  50. Meta_query with multiple keys and multiple values
  51. Tax query AND/OR meta query [duplicate]
  52. Help ordering Post loop by two meta values
  53. How to exclude post formats from wordpress recent posts in a tabs widget [closed]
  54. How to increase load time of an archive/search page (WP_Query)
  55. Easy way to write complex queries in wordpress
  56. get_posts output always same post
  57. Query_posts works when appending via AJAX call wp_query doesn’t?
  58. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  59. Is this meta query problematic?
  60. Appending to existing WP_Query’s meta_query if exists
  61. Get meta_value of a specific meta_key from all posts belonging to a specific custom type
  62. Custom query filter by ACF date custom field
  63. Query by date from custom field
  64. Nested array issue in meta_query
  65. Error in meta_query not get result
  66. Get next/prev image/attachment in time with date query
  67. How to get current page nearest parent id?
  68. meta_query with array as value with multiple arrays
  69. Trouble Making WP_Query paged
  70. Sort posts using multiple custom fields and menu_order in single query?
  71. Optimising WP_Query with ACF Fields
  72. Filter products on category AND tag
  73. meta_query – check for multiple meta values in key which holds an array of values
  74. How do I stop the same post showing multiple times in a archive?
  75. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  76. Getting posts by custom field value
  77. WP_Query on custom key and value
  78. Get posts having meta value between two numbers
  79. wordpress multiple meta value query is not working
  80. trying to change from query_post to WP_Query
  81. Strange results from WP_Query
  82. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  83. Sorting with meta_query and multiple, optional meta keys
  84. WordPress For Loop Prints Unwanted Extra Paragraph Element
  85. Query by meta value (add a dropdown of all values)
  86. query_posts() doesn’t seem to be called in my page
  87. WP_Query returns empty if meta_query has more than 7 values
  88. Fetching $_POST from Page Template into functions.php
  89. Use not custom fields in get_posts() meta_query?
  90. WordPress meta_query not working
  91. Using orderby with 2 meta keys
  92. Optimising specific Query with ACF meta objects
  93. query_posts with sorting on a custom datestamp
  94. Passing conditional arrays to WP_Query() [closed]
  95. Query Posts by date range with fixed beginning and end
  96. Get all user with both meta_value
  97. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  98. Get posts using multiple values from ACF checkbox as meta query wordpress
  99. get_post_meta bringing back results, but $wpdb->postmeta doesn’t
  100. Custom query with custom filtering returning incorrect results
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)