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