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?
- Get all authors with at least one post of ‘custom post type’
- Show list of authors with latest post NOT older than a month
- “There doesn’t seem to be a wp-config.php file.” despite wp-config.php in root
- How blog page in WordPress works : blog page retrieve first post ID
- Posts with multiple authors with different roles
- Showing a list of posts when homepage is custom
- How do I set up my blog home page to show only this weeke’s posts automatically?
- Show certain posts in a LIST format that members have been granted access to
- get author in blog posts?
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- Is it possible to send blog posts via email to subscribers?
- Author’s Id from wp list authors function
- How to get the latest URL of my blog?
- Later blog post pages give 404 error
- Is there a way to multiply archive loop results sequentially?
- Display subcategories in dropdown
- WordPress loop is not working
- Wrap posts p tags in div
- Direct some posts to only appear on a specific page
- How to add a “Who’s who” on a wordpress blog post?
- List of all authors avatars
- Blog page with posts from specific categories
- Move blogs but with applied filters
- How to use a PHP file to control the content of a blog post
- List post categories that link to a page showing those posts
- blank page with no code or errors on blog
- Link to blogg-page
- How do I remove blog entries from home page Twenty Eleven child theme?