You could try the following SQL query:
"SELECT DISTINCT post_author FROM $wpdb->posts WHERE post_author NOT IN (1,3,4)"
to exclude authors 1,3 and 4.
In general it would be more handy to retrieve the user ids automatically, so you wouldn’t need to update your SQL query every time you want to exclude someone.
You could for example use the user meta to label those users that you want to exclude.
Related Posts:
- Can you have a blog in a subdirectory hosted on a different server?
- Move WordPress from /blog folder to root but leave post at /blog
- Moving my current wordpress blog to a subdomain
- Could not load the preview image. Please reload the page and try again – error on image upload
- How to display blog posts on a dedicated page?
- Two Blog Layouts, Same Theme
- Show first sentence of blog post in blog roll
- Keep WYSIWYG on Blog Page
- Detect archive and category page
- Custom URL for all posts in WordPress
- List all blog categories
- A garbled copy of MY blog on this site? [closed]
- A different thumbnail to the blog index vs. the image on the top of a post?
- Deleting a blog
- Why does this snippet in a blog post make WordPress crash?
- How to move all theme templates into a subfolder WP
- Where can I find my blog page?
- implement authentication and authorization to user
- How to display the posts and news in front page?
- How do I change the taglines next to the featured image on my posts?
- WordPress Blog – Grid View
- How to show latest blog post rather then earliest
- inviting people to blog and editing roles
- Removing blog page images
- problem with wordpress author profile page URL
- How to make blog posts appear under different menu items?
- Portfolio & Blog cohabitation : multiple single.php files?
- How to add list of other blogs, with latest posts from those blogs, to a single page of my website?
- Put post urls into their own category
- I want to display my 2. latest post
- Why the Gutenberg Editor is Not Available In My WP Site?
- How to prevent WordPress from auto creating ol li on list elements?
- How do I add a sign up form to my blog?
- WordPress blog assign unqiue body class
- I am getting “0” in the starting of my post description at home page
- How can I make my Blog category unindexed in Google?
- How to modify display of blog listing page?
- Internal and External Blog
- Can I make a parent page of the blog and have it display a paragraph/thumbnail of certain entries?
- How can I set a vote on the comments?
- co-authors plugin – inline listing
- Making a column vector in wordpress blog using Latex
- How do you allow users to subscribe to a WordPress blog?
- Blog on a separate server from WooCommerce WITHOUT effecting SEO?
- what is the address of default home page?
- Get top authors for the last 30 days with posts count and avatar
- Creating new page overwrites old page
- How to set condition for all posts with one label
- Blogs got Deleted automatically
- Integrate wordpress blog into existing html site
- Retrieve details of my wordpress site
- Blog post stuck in drafts
- I need to customize wordpress “previous” “next” links
- I Have No List Of Blogs – Empty Blog Folder Recreating Itself
- How to change the layout of blog posts to that a compressed snippet shows rather than full text
- Can I create mini-WordPresses on my WordPress?
- How to create library of HTML snippets to use in posts
- Adding a WordPress Blog to a current WordPress site
- Two blogs one page
- Blog Displays Only Sticky Posts
- Uploading a external squeeze page within WP
- Posts page drop down is not selecting the selected page
- URL of blog when using index.php as blog and front-page.php as homepage
- Not showing up on WordPress Reader
- Blog as a part of a WordPress site?
- Fatal error: require() [function.require]: Failed opening required in wordpress
- how to show content of latest blog post with read more link?
- Auto-posting Facebook posts to blog [closed]
- How to access the so called “Posts page”
- Home page of blog displays no posts
- How to turn off “you have to login to comment” on blogs
- How can I get blog content from SFTP?
- Multiple versions of RSS feed? One with full content, one with the excerpt
- I put my blog on a subpage, how do I get page title?
- Is it possible to set a page template on a dynamic home page (articles list)?
- blog page showing only first post
- Get List of all the Authors
- Custom Author Loop
- How do I set up my blog home page to show only this weeke’s posts automatically?
- How can i redirect my Blog to a Subdomain?
- wp_enqueue_style and different styles for blog template
- WordPress Plugin manipulate have_posts()
- Allow users to create post without logging in?
- How can I show the author’s latest post with title?
- Functions.php: Exclude Category from “Blog”
- Blog automatically redirected to error page
- Filter authors on meta value
- Fatal error: Cannot redeclare comment_theme()
- Customizing SERP content for WordPress Blog
- Displaying the blog entries in a Page (using get_posts to retrieve the posts)?
- Pagination not give another posts
- “Blog pages show at most” in setting not working
- How to pull sticky post permalink inside php?
- Is it possible to set up blog categories without changing permalink structure
- How to make cover image in post block expand to entire screen?
- Custom homepage with recent blog posts
- Blog styling in SASS
- WordPress.com blog migration to self hosted WordPress website [closed]
- WordPress Custom Theme: My site shows the same posts on Page 1 and Page 2 and so on [duplicate]
- list all authors outside of loop with photo from /uploads