查询某段时间用户登录信息,并且当前版本不是1.72

最新推荐文章于 2024-10-17 11:21:39 发布

weixin_34269583

最新推荐文章于 2024-10-17 11:21:39 发布

阅读量86

点赞数

文章标签： python

原文链接：https://my.oschina.net/u/2253438/blog/667174

版权

2019独角兽企业重金招聘Python工程师标准>>>

SELECT
   user_account.account AS 账号,
   FROM_UNIXTIME(
       user_account.registerTime / 1000,
       '%Y-%m-%d'
   ) AS 注册时间,
   user_info.chineseName AS 姓名,
   user_info.uid 用户ID,
   user_info.personIUCode AS 用户行业,
   account_extension.curVersion 当前版本,
   FROM_UNIXTIME(
       user_account.lastActive / 1000,
       '%Y-%m-%d'
   ) 最后活跃日期,
   user_info.mobilePhone AS 手机号码
FROM
   user_account
INNER JOIN account_extension ON account_extension.uid = user_account.uid
INNER JOIN user_info ON user_info.uid = user_account.uid
WHERE
   account_extension.curVersion NOT IN ('1.72', '1.720')
AND user_account.lastActive >= UNIX_TIMESTAMP('2016-03-27') * 1000
AND user_account.lastActive <= UNIX_TIMESTAMP('2016-04-26') * 1000;