SELECT distinct(aLuid.uid) as uid FROM {$this->server['log_dbname']}.accountLog as aLuid,{$this->server['log_dbname']}.accountInfo as aIuid WHERE aLuid.uid=aIuid.uid AND aIuid.adFrom='{$this->server['area_name']}' AND aLuid.action=2 AND FROM_UNIXTIME(aLuid.time,'%Y-%m-%d')='$day' GROUP BY aIuid.RegIP

SELECT uid FROM crystal_game_360s2.account WHERE adFrom='sy360forandroid' and DATE_FORMAT(reg_date,'%Y-%m-%d')='2015-05-09' group by platformRegIP

SELECT distinct(aLuid.uid) as uid FROM crystal_log_360s3.accountLog as aLuid,crystal_log_360s3.accountInfo as aIuid WHERE aLuid.uid=aIuid.uid AND aIuid.adFrom='sy360forandroid' AND aLuid.action=2 AND FROM_UNIXTIME(aLuid.time,'%Y-%m-%d')='2015-05-06' GROUP BY aIuid.RegIP

SELECT count(*) as new_login FROM (SELECT uid FROM crystal_game_360s3.account WHERE adFrom='sy360forandroid' and DATE_FORMAT(reg_date,'%Y%m%d')='2015-06-11' group by platformRegIP) as `linshitable` 

SELECT *,from_unixtime(`time`) FROM `mj_registration` ORDER BY `mj_registration`.`time` DESC 

SELECT * FROM `mj_data_clock_in_day` WHERE DATE_FORMAT(`date`,'%Y%m%d')>='20150701' and `usernumber`='00130' 

SELECT distinct(aLuid.uid) as uid FROM crystal_log_s1.accountLog as aLuid,crystal_game_s1.account as aIuid WHERE aLuid.uid=aIuid.uid AND aIuid.adFrom='jpuser' AND aLuid.action=2 AND FROM_UNIXTIME(aLuid.time,'%Y-%m-%d')='2015-05-27' and DATE_FORMAT(aIuid.reg_date,'%Y-%m-%d')<'2015-05-27' 
SELECT distinct(aLUID.UID) as UID FROM PlatformLog.tb_user_log as aLUID,PlatformCommon.tb_user as aIUID WHERE aLUID.UID=aIUID.UID AND aLUID.type=0 AND FROM_UNIXTIME(aLUID.UserTimestamp,'%Y-%m-%d')='2015-05-26' GROUP BY aIUID.RegIP