How to retrieve zero post users in wordpress?

I want to retrieve those authors that have zero or no posts in wordpress. what will be the easiest way?

Answers


This query should do the magic for you.

SELECT * 
FROM wp_users
LEFT OUTER JOIN wp_posts ON ( wp_users.id = wp_posts.post_author ) 
WHERE wp_posts.post_author IS NULL

<?php wp_list_authors('exclude_admin=0&hide_empty=0'); ?>

if you set hide_empty=1 - it will show those with 1 or more posts.


Need Your Help

RelativeLayout: how to center something in the screen unless the view is too small

android android-layout

I'm trying to achieve a quite simple layout, but I can't get it to work well when the height is getting too small (landscape mode).

ASP.NET hosting with unlimited single-node scalability

asp.net hosting cloud-hosting

Since this question is from a user's (developer's) perspective I figured it might fit better here than on Server Fault.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.