フィギュア女子シングル ライバル対決

浅田真央キム・ヨナですね、
シニアでは全13戦あったのですね

No 浅田 キム 勝者 url 大会名
1 2 1 KIM http://figure2.me/slfs/competitions/viewrd/83/10 ISU Grand Prix of Figure Skating Final 2006
2 2 3 ASADA http://figure2.me/slfs/competitions/viewrd/80/10 ISU World Figure Skating Championships 2007
3 2 1 KIM http://figure2.me/slfs/competitions/viewrd/77/10 ISU Grand Prix of Figure Skating Final 2007
4 1 3 ASADA http://figure2.me/slfs/competitions/viewrd/47/10 ISU World Figure Skating Championships 2008
5 1 2 ASADA http://figure2.me/slfs/competitions/viewrd/68/10 ISU Grand Prix and Junior Grand Prix Final 2008
6 3 1 KIM http://figure2.me/slfs/competitions/viewrd/69/10 ISU Four Continents Figure Skating Championships 2009
7 4 1 KIM http://figure2.me/slfs/competitions/viewrd/36/10 ISU World Figure Skating Championships 2009
8 2 1 KIM http://figure2.me/slfs/competitions/viewrd/31/10 ISU GP Trophee Eric Bompard 2009
9 2 1 KIM http://figure2.me/slfs/competitions/viewrd/26/10 Vancouver Olympic 2010
10 1 2 ASADA http://figure2.me/slfs/competitions/viewrd/20/10 ISU World Figure Skating Championships 2010
11 6 2 KIM http://figure2.me/slfs/competitions/viewrd/17/10 ISU World Figure Skating Championships 2011
12 3 1 KIM http://figure2.me/slfs/competitions/viewrd/110/10 ISU World Figure Skating Championships 2013
13 6 2 KIM http://figure2.me/slfs/competitions/viewrd/123/10 Sochi Olympic 2014

キムさんの9勝で、なかなか強いですね

関係ないですが、忘備録にSQLをつけときます。

select * from (
select a.rank_no as Asada, k.rank_no as Kim,
case
when ( a.rank_no - k.rank_no ) > 0 then 'KIM'
else 'ASADA'
end winner,
concat( 'http://figure2.me/slfs/competitions/viewrd/', c.id, '/10') url,
c.name competition
from (
select pp.id, pp.id * 1000000 + 6588 asada, pp.id * 1000000 + 7232 kim
from (
select distinct c.id
from scores sa,scores sk, competitions c
where
c.id = sa.competition_id
and c.id = sk.competition_id
and sa.player_id = 6588
and sk.player_id = 7232
) pp
) ids, rks a, rks k, competitions c
where
a.id = ids.asada
and k.id = ids.kim
and c.id = ids.id
order by c.start_d
) k


フィギュアスケートは演技を観て楽しみましょう。