select * from users join (select userid, count(*) as count from fileshare group by userid) as t on users.id = t.userid order by count desc;
select * from users left join (select userid, max(dateupload) as dateupload from fileshare group by userid) as t on users.id = t.userid order by dateupload desc;