queryList
===
    SELECT y.id, y.nick_name,y.user_name, y.mobile, y.regster_type, y.promoterName,y.promoter,y.real_user_id,
           	y.create_time, y.detail_address, y.address_remark, y.disc,x.regist_time, y.latitude, y.longitude, 
           	IFNULL(z.latitude, 0) AS latitudex, IFNULL(z.longitude, 0) AS longitudex
       FROM 
     (
    	select a.*,b.nick_name as promoterName,t.nick_name as promoter from xzx_user_target_info a 
    	left join xzx_user_other_info b on a.real_user_id = b.user_id
    	left join xzx_user_other_info t on t.user_id = a.user_id 
    	where a.del_flag = 0 
    	@if(!isEmpty(regsterType)){
            AND a.regster_type in (#regsterType#,#regsterType1#) 
        @}
        @if(!isEmpty(nickName)){
            AND a.nick_name like #'%'+nickName+'%'#  
        @}
        @if(!isEmpty(mobile)){
            AND a.mobile like  #'%'+mobile+'%'# 
        @}
        @if(!isEmpty(promoterName)){
            AND b.nick_name like #'%'+promoterName+'%'#  
        @}
        @if(!isEmpty(promoter)){
            AND t.nick_name like #'%'+promoter+'%'#  
        @}
    ) y 
    LEFT JOIN xzx_user_info x ON x.mobile_phone = y.mobile
    LEFT JOIN xzx_user_address_info z ON y.mobile = z.mobile_phone AND z.flag = 1 AND z.del_flag=0
    @if(!isEmpty(startTime)){
        where x.regist_time BETWEEN #startTime# AND #endTime#
    @} 
    GROUP BY y.id LIMIT #page#, #limit#
    
queryListCount
===
    SELECT COUNT(*) FROM (
    	SELECT y.*,x.regist_time FROM 
    	 (
    		select a.*,b.nick_name as promoterName from xzx_user_target_info a 
    		left join xzx_user_info b on a.real_user_id = b.user_id 
    		left join xzx_user_info t on t.user_id = a.user_id 
    		where a.del_flag = 0
    		@if(!isEmpty(regsterType)){
                AND a.regster_type in (#regsterType#,#regsterType1#) 
            @}
            @if(!isEmpty(nickName)){
                AND a.nick_name like #'%'+nickName+'%'# 
            @}
            @if(!isEmpty(mobile)){
                AND a.mobile like #'%'+mobile+'%'#  
            @}
            @if(!isEmpty(promoterName)){
                AND b.nick_name like #'%'+promoterName+'%'#  
            @} 
            @if(!isEmpty(promoter)){
                AND t.nick_name like #'%'+promoter+'%'#  
             @}
    	) y 
    	LEFT JOIN xzx_user_info x ON x.mobile_phone = y.mobile
    	LEFT JOIN xzx_user_address_info z ON y.mobile = z.mobile_phone AND z.flag = 1 AND z.del_flag=0
    	@if(!isEmpty(startTime)){
            where x.regist_time BETWEEN #startTime# AND #endTime#
        @} 
    	GROUP BY y.id 
    ) as tmp
    
    
queryUser
===
    SELECT a.mobile_phone as mobile, a.nick_name as nickName,
    b.order_id as orderId, c.longitude as longitudex, c.latitude as latitudex FROM xzx_user_info a 
    LEFT JOIN xzx_order_info b on a.user_id = b.create_user_id
    LEFT JOIN xzx_user_address_info c ON a.user_id=c.user_id
    WHERE a.user_type=1 and a.del_flag=0 GROUP BY a.mobile_phone