Query All users that has post

Question

Query All users that has post

Marlon Buendia

2015年9月17日 00:23

I have this query so far :

        $user_args = array(
            'role'    = 'frontend_vendor',
            'orderby' = 'display_name', 
            'order'   = 'ASC',      
            'number'  = $no,
            'offset'  = $offset
        );

        $user_query = new WP_User_Query( $user_args );

Now what I want to do is to get all users that has only posts, i have an example query that i want to do. how do i do this with wp_query()?

SELECT users.id, posts.id 
FROM wp_users 
RIGHT JOIN wp_posts 
ON wp_users.id = wp_posts.user_id 
WHERE wp_posts.post_type = 'downloads'
AND wp_users.role = 'frontend_vendor' 
ORDER BY display_name 
ASC
LIMT 8
OFFEST 0

If the user has no posts, he should not be selected.

Topic join-tables mysql users query posts Wordpress

Category Web

kenn · Accepted Answer · 2015年9月17日 00:23

add this in your arguments 'query_id' => 'authors_with_posts',

    $user_args = array(
        'role'    => 'frontend_vendor',
        'orderby' => 'display_name', 
        'query_id' => 'authors_with_posts',
        'order'   => 'ASC',      
        'number'  => $no,
        'offset'  => $offset
    );

jas · Accepted Answer · 2015年9月16日 10:16

Here are below some possible options:

codex link

Order & Orderby Parameters we can add post_count otherwise there is no such parameter such as "posts_per_author" does not exist in wp_query refrence

please include orderby in your query

'orderby' => 'post_count'

FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) LEFT OUTER JOIN (
            SELECT post_author, COUNT(*) as post_count
            FROM wp_posts
            WHERE post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')
            GROUP BY post_author
        ) p ON (wp_users.ID = p.post_author)

Use count in code according to requirement.

Get Authors or users

<?php $list = wp_list_authors('show_fullname=1&optioncount=1&orderby=post_count&order=DESC&number=3'); ?>
<?php echo"<pre>";   print_r($list); echo"</pre>"; ?>

"optioncount" can help in this case.

with direct query please see this post:

Get users with atleast one post

Thanks!

Query All users that has post

About