회원가입
로그인
협회소개
주요행사
걷기기록
행사참여
알림마당
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순위
순위 이름 총 참가횟수 참가횟수 뱃지 총 누적거리 누적거리 뱃지
41 권기현 1049 회 5973.00 km
42 01063328690 1028 회 9204.00 km
43 원숙자 1027 회 4435.95 km
44 강기홍 999 회 5406.67 km
45 여창환 996 회 4255.28 km
46 greenfield 990 회 4392.83 km
47 민순분 972 회 10225.30 km
48 이명용 951 회 8149.45 km
49 엄호섭 948 회 3797.87 km
50 김효영 945 회 7735.42 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.