회원가입
로그인
협회소개
주요행사
걷기기록
행사참여
알림마당
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순위
순위 이름 총 참가횟수 참가횟수 뱃지 총 누적거리 누적거리 뱃지
151 01025481705 288 회 421.00 km
152 최희윤 287 회 2481.57 km
153 김명중 282 회 2923.23 km
154 김명순 275 회 2016.92 km
155 한기영 269 회 1365.95 km
156 신경애 264 회 1701.41 km
157 김인선 264 회 2264.00 km
158 조인철 263 회 1880.52 km
159 01024769504 256 회 1091.00 km
160 권용급 247 회 1589.79 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.