22,210
社区成员
发帖
与我相关
我的任务
分享
select count(distinct a.uid)
from userLogin a
inner join r_game_new_user b on a.uid=b.uid and a.gameId=b.gameId
where a.gameId='1375682963962790' and a.dateTime=UNIX_TIMESTAMP('20131030') and b.dateTime=UNIX_TIMESTAMP('20131029')