多表联合查询

select m.username uname, mc.extcredits2 uext,m.uid from pre_common_member m, pre_common_member_count mc where m.adminid not in(1,2,3) and m.uid=mc.uid group by mc.extcredits2 desc limit 14