The most efficient means would be to query directly via wpdb
:
$author_ids = $wpdb->get_col(
"
SELECT DISTINCT post_author
FROM $wpdb->posts
WHERE post_type="job"
AND post_status="publish"
"
);
Related Posts:
- Change media attachment author via mysql query
- Order query by post meta value
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- List author’s posts with SQL
- Query parsing only author ids
- Query filter on custom post by current author in post widget for elementor query id
- Get all image from single page using this query
- simple sql query on wp_postmeta very slow
- wordpress query – orderby child post date
- Add multiple value to a query variable in WordPress
- wp_dropdown_categories with multiple select
- How to tune search argument in WP_Query to show only exactly the same results?
- Custom query filter not working on woocommerce category page
- How to get my loop to pull posts into three columns
- Custom $wpdb Query for Custom Post Type by Category
- Can’t pass table to $wpdb->prepare
- WordPress creating excessive joins on meta_query with search
- Date query year and month OR just year
- Are database queries created using WordPress filters protected from SQL injection?
- get post id using the $query_vars variable
- How to remove duplicate query on page load or make them cacheable
- Is there a conditional tag for latest post or do i need a query?
- How can I apply a meta query for a single custom post type in the main query?
- get_posts() loop returns the same the_title() for each post
- Huge amount of queries on my site
- How to check current user in meta value array in WP_Query meta_query
- How select a specific query when setting offset?
- Get post according to current taxonomy
- Temporarily storing main search result
- Help with MySQL to $WPDB query
- Alter query with posts_clauses to retrieve NULL values last
- sql select query in wordpress ‘page’ [closed]
- wpdb->term_taxonomy count posts from both published and private posts?
- Query based on title, with ‘compare’ => ‘IN’
- Group custom post listing in admin section
- problem with sql query in wordpress plugin
- Attempt to improve WP search, can someone check my SQL query?
- WordPress Query orderby title with UTF8 string in title
- Searching With Apostrophe
- Query posts according to specific post meta values
- Where is the query in wp-login.php
- Order posts by recent comments
- query if page has not child
- empty query breaks other queries
- Problem in exploding the_content to array
- get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
- Order by title – but now built in wordpress func, sort the_title
- Display posts between two particular dates
- pre saved posts query from db options table
- Order posts by date, but also give priority for a specific term
- $post->ID not working in combination with a custom query
- Custom Query returns array, but I can’t see it’s elements
- how to insert missing tags into the posts through mySQL?
- How to insert Collate into WordPress search query?
- Combine “Exclude” Query in functions.php
- Optimize slow SQL query for multiple meta values
- prepare function sql safe method
- Wrap/close ‘query’ for a first-letter ordered listing of posts
- wpdb query with dynamic column name?
- How do you display the number of a post in a query?
- How to return count of custom post type posts with a specific custom field value via $wpdb?
- How to rearrange a pool of posts joined using two queries?
- How can I get the name of term post meta value which equals term id
- Help with Related Posts Function
- wpdb update multiple row?
- Trying to use WP_Query to return post with and without meta values
- Custom query Custom-Post-Types creates error
- Formatting a date/time returned from a custom $wpdb query
- get products by custom date variable
- How to delete all images from code in all post_content
- How to sort by two meta keys in admin area?
- Restrict WordPress search to a single ACF field
- wp query multiple values > display a specific value first
- PHP Fatal error: Uncaught Error: Call to a member function insert() on null
- SQL query to delete users with multiple meta keys and comments
- Nested select statements not working
- OR condition not working
- Pagination adds search query (again)
- Fastest and most efficient SQL query to check if UID exists
- Counting And Monitoring How Much Queries My Script Used
- Use $wpdb->get_results with filter based on array
- Add Hook for clearing transient when post is added
- Run an update query in a function
- Add generic page to WP_Query
- Advanced Custom Fields Query with Different Values of the Same Key
- No results for taxonomy archive page
- search.php is not generating the right results
- How to have more post in a page than in your home page
- Find all posts via SQL beginning with A of type B
- Show links to child pages on both parent AND child pages
- Access Tables with number prefix
- Modify Global Posts Plugin
- How to reference same column name but different table in custom db query
- Retrieving custom field array value through db query
- SQL Query : how copy all tags of post into their post content in wordpress by sql query
- 3 queries to update WordPress
- How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
- update $wpdb one query
- Admin Post List table Query filtering “WHERE” for custom post type
- How to use a dynamic term id for the query block