회원가입
로그인
협회소개
주요행사
걷기기록
행사참여
알림마당
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순위
순위 이름 총 참가횟수 참가횟수 뱃지 총 누적거리 누적거리 뱃지
91 채종철 516 회 4830.18 km
92 01047335672 510 회 2360.00 km
93 차애숙 508 회 2535.00 km
94 조복자 506 회 2976.10 km
95 01048787480 506 회 4343.00 km
96 남영지 490 회 2760.02 km
97 시나브로 486 회 2453.00 km
98 김은희 482 회 1728.25 km
99 민나건 479 회 1688.84 km
100 미사키 474 회 8196.24 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.