Discuz! X 查询用户注册信息的情况

Bruce.Kevin

查询用户的UID、用户名、用户组、管理组、扩展组、注册邮箱、注册时间及最后访问时间

1. SELECT
   
2.   aa.`uid` AS UID,
   
3.   aa.`username` AS 用户名,
   
4.   bb.`grouptitle` AS 用户组,
   
5.   (CASE WHEN aa.`adminid` = '0' THEN "无" ELSE bb.`grouptitle` END) AS 管理组,
   
6.   (CASE WHEN aa.`extgroupids` = '' THEN "无" ELSE cc.`grouptitle` END) AS 扩展用户组,
   
7.   aa.`email` AS 注册邮箱,
   
8.   FROM_UNIXTIME (aa.`regdate`, '%Y年%m月%d日') AS 注册时间,
   
9.   FROM_UNIXTIME (dd.`lastvisit`, '%Y年%m月%d日') AS 最后访问时间
   
10. FROM
    
11.   pre_common_member aa
    
12.   LEFT JOIN pre_common_usergroup bb
    
13.     ON aa.`groupid` = bb.`groupid`
    
14.   LEFT JOIN pre_common_usergroup cc
    
15.     ON aa.`extgroupids` = cc.`groupid`
    
16.   LEFT JOIN pre_common_member_status dd
    
17.     ON aa.`uid` = dd.`uid`
    
18. LIMIT 10000

复制代码