Where-is-my-Coc 2020-05-26 11:45:20 233次浏览 1条回复 0 0 0
SELECT DISTINCT(m.uid), m.nickname, m.city, m.sex, m.constellation, m.avatar, m.vip, m.hot_num, m.order_end_num, m.active_num, m.recommend_status, m.lat, m.long,e.vip_icon,
    FLOOR((DATEDIFF(CURDATE(),`birthday`) / 365)) age,
    ROUND(auth_num/11, 2) degree, m.birthday,
    ROUND(
        6378.138 * 2 * ASIN(
            SQRT(
                POW(
                    SIN(
                        (
                            39.910286 * PI() / 180 - lat * PI() / 180
                        ) / 2
                    ),
                    2
                ) + COS(39.910286 * PI() / 180) * COS(lat * PI() / 180) * POW(
                    SIN(
                        (
                            116.43244 * PI() / 180 - `long` * PI() / 180
                        ) / 2
                    ),
                    2
                )
            )
        ) * 1000
    ) AS juli FROM `frd_member` `m` LEFT JOIN `frd_member_authentication` `is_auth` ON `m`.`uid` = `is_auth`.`uid` LEFT JOIN `frd_experience` `e` ON m.vip = e.grade and m.sex = e.type WHERE ((`m`.`invisible`=0) AND (`m`.`status`=0) AND (`m`.`del_flg`=0))
亿速云
您需要登录后才可以回复。登录 | 立即注册