bitscn.com select u.*,count(u.id) as sum
02
from user as u
03
left join post as p
04
on p.user_id = u.id
05
right join user_has_group as up
06
on up.user_id = u.id
07
right join user_has_email as ue
08
on ue.user_id = u.id
09
where u.username != ''
10
and up.group_id = {$args['groupid']}
11
and ue.email = '{$args['useremail']}'
12
group by u.id order by u.id desc bitscn.com