フィギュア女子シングル ライバル対決
浅田真央とキム・ヨナですね、
シニアでは全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
※フィギュアスケートは演技を観て楽しみましょう。