회원가입
로그인
협회소개
주요행사
걷기기록
행사참여
알림마당
IVV 아시안피아드
걷기기록 순위
걷기기록
select * from (SELECT SUM(cnt) AS cnt, SUM(skm) AS skm, SUM(totalCnt) AS totalCnt, usr_name, usr_hPhone2, SUM(cnt0) AS cnt0, SUM(skm0) AS skm0, SUM(totalCnt0) AS totalCnt0, SUM(p_cnt) AS p_cnt, SUM(p_skm), p_skm, SUM(p_totalCnt) AS p_totalCnt FROM (SELECT allList.* FROM ( SELECT *, cnt+IFNULL(cnt0,0) AS p_cnt, skm+IFNULL(skm0,0) AS p_skm, totalCnt+IFNULL(totalCnt0,0) AS p_totalCnt FROM ( select COUNT(*) AS cnt, TRUNCATE(sum(AA.uco_km),2) AS skm, CC.totalCnt, usr.usr_name, usr.usr_hPhone2 FROM (SELECT CONCAT(usr_id,'-',SUBSTRING(uco_wdate,1,10)) AS ggg, uco_km, usr_id from bf_user_course WHERE uco_km >=2 GROUP BY ggg) AS AA LEFT JOIN bf_user AS usr ON usr.usr_id = AA.usr_id LEFT JOIN (SELECT COUNT(*) AS totalCnt, usr_id FROM bf_user_course GROUP BY usr_id) AS CC ON usr.usr_id = CC.usr_id GROUP BY AA.usr_id ) AS present LEFT JOIN ( SELECT DDD.*, EEE.totalCnt0 FROM ( SELECT CCC.p_hp, COUNT(CCC.p_hp) AS cnt0, TRUNCATE(sum(CCC.success_distance),2) AS skm0 FROM ( SELECT CONCAT(p_hp,'-',SUBSTRING(m_startdate,1,10)) AS hhh, success_distance, p_hp FROM v_walk_apply_member AS AAA LEFT JOIN v_walk_manage AS BBB ON AAA.m_idx = BBB.m_idx WHERE success_distance >= 2 GROUP BY hhh ) AS CCC GROUP BY CCC.p_hp ) AS DDD LEFT JOIN ( SELECT p_hp,COUNT(p_hp) AS totalCnt0 FROM v_walk_apply_member GROUP BY p_hp ) AS EEE ON DDD.p_hp = EEE.p_hp ) AS past ON present.usr_hPhone2 = past.p_hp ORDER BY p_totalCnt DESC LIMIT 0,200 ) AS allList WHERE 1=1 ) as CMV GROUP BY CMV.usr_hPhone2) as CC ORDER BY CC.p_totalCnt desc
KWL 걷기기록순위
KWL순위
IVV순위
순위 이름 총 참가횟수 참가횟수 뱃지 총 누적거리 누적거리 뱃지
1 bio 4179 회 35137.78 km
2 동해바다걷기왕 4100 회 39082.92 km
3 홍길동 3674 회 14956.04 km
4 정상희 2490 회 19158.64 km
5 eunji 2405 회 14968.17 km
6 비단길 2397 회 16043.08 km
7 김태호 2394 회 16951.42 km
8 김호윤 2098 회 3516.27 km
9 신치호 2066 회 14433.67 km
10 우채영 2004 회 14797.21 km
개인정보처리방침 이용약관 CONTACT US
서울시 중구 마른내로 155(광희동1가,금호트윈오피스텔) 2동 702호 | 찾아오시는길 | 한국체육진흥회는 기획재정부 지정 공익법인 기부금단체입니다
Tel.(02)2274-7077   FAX.(02)2272-2078   Mail. kapa7077@korea.com
COPYRIGHT Ⓒ KOREA WALK . ALL RIGHTS RESERVED.