회원가입
로그인
협회소개
주요행사
걷기기록
행사참여
알림마당
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순위
순위 이름 총 참가횟수 참가횟수 뱃지 총 누적거리 누적거리 뱃지
141 김숙자 304 회 4269.76 km
142 누리 302 회 3621.00 km
143 진대규 298 회 2435.27 km
144 이또한지나가리라 297 회 2657.55 km
145 이병희 297 회 493.15 km
146 이명숙 295 회 3911.20 km
147 01038299939 292 회 3287.00 km
148 최대현 291 회 2577.31 km
149 한봉문 291 회 4348.00 km
150 김선옥 289 회 1476.89 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.