番号、浅田順位、キム順位、勝者、URL、大会名
No Asada Kim winner url competition
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
http://figure2.me/slfs/
に登録しました。
サイト右のツリーより、□内に+のついたマークを
「GRAND PRIX」「2014」「ISU GP Lexus Cup of China 2014 ISU HP」
とクリックすると、カテゴリーが表示されるので、
「Ladies」の文字列リンクをクリックという操作で辿れます。
「!」つきの26要素
name name name goe score
ISU GP Lexus Cup of China 2014 Gabrielle DALEMAN 3F 20 603
ISU GP Skate Canada International 2014 Ashley WAGNER 3F 20 603
ISU GP 2014 Hilton HHonors Skate America Nam NGUYEN 3Lz 10 670
ISU GP Skate Canada International 2014 Takahito MURA 3F 0 583
ISU GP Lexus Cup of China 2014 Misha GE 3F* 0 0
ISU GP Lexus Cup of China 2014 Misha GE 3Lz -10 650
ISU GP 2014 Hilton HHonors Skate America Elena RADIONOVA 3F -10 520
ISU GP Skate Canada International 2014 Viktoria HELGESSON 2F -17 173
ISU GP Skate Canada International 2014 Satoko MIYAHARA 3F -20 510
ISU GP 2014 Hilton HHonors Skate America Nam NGUYEN 3Lz+3T -30 1081
ISU GP Lexus Cup of China 2014 Misha GE 3Lz+3T -30 980
ISU GP Skate Canada International 2014 Andrei ROGOZINE 3Lz -30 570
ISU GP 2014 Hilton HHonors Skate America Alexei BYCHENKO 2Lz -30 201
ISU GP 2014 Hilton HHonors Skate America Samantha CESARIO 3Lz -40 620
ISU GP Skate Canada International 2014 Satoko MIYAHARA 3F -40 543
ISU GP 2014 Hilton HHonors Skate America Brooklee HAN 3Lz -50 550
ISU GP 2014 Hilton HHonors Skate America Jorik HENDRICKX 3F+1Lo+3S -60 1040
ISU GP Skate Canada International 2014 Javier FERNANDEZ 3F+1Lo<+3S -70 1019
ISU GP Skate Canada International 2014 Andrei ROGOZINE 3Lz -80 580
ISU GP Skate Canada International 2014 Hae Jin KIM 3F -80 450
ISU GP 2014 Hilton HHonors Skate America Mirai NAGASU 3Lz< -90 330
ISU GP Skate Canada International 2014 Brooklee HAN 3Lz<< -90 120
ISU GP 2014 Hilton HHonors Skate America Tatsuki MACHIDA 3F -120 463
ISU GP Skate Canada International 2014 Stephen CARRIERE 3F -120 463
ISU GP Skate Canada International 2014 Takahiko KOZUKA 3F< -120 287
ISU GP Lexus Cup of China 2014 Hae Jin KIM 3Lz< -140 322
「*」つきの8要素
name name name goe score
ISU GP 2014 Hilton HHonors Skate America Gracie GOLD 2S*+2T*+2T* 0 0
ISU GP Skate Canada International 2014 Courtney HICKS 2Lz* 0 0
ISU GP Skate Canada International 2014 Florent AMODIO 2Lz* 0 0
ISU GP Skate Canada International 2014 Adam RIPPON 1Lz*+COMBO 0 0
ISU GP Skate Canada International 2014 Michal BREZINA 3F*+2T*+2T* 0 0
ISU GP Lexus Cup of China 2014 Hae Jin KIM 1A* 0 0
ISU GP Lexus Cup of China 2014 Jin Seo KIM 2Lz* 0 0
ISU GP Lexus Cup of China 2014 Keiji TANAKA 1A* 0 0
ISU GP 2014 Hilton HHonors Skate America Mirai NAGASU 3Lo+1T* -210 351
陰の機能で
SELECT p.name, MIN( play_date ) first_date, COUNT( * ) cnt
FROM `elesps` ep, scores s, players p, m_elements m
WHERE m.sname = '3A'
AND ep.m_element_id = m.id
AND ep.score_id = s.id
AND s.category_id =10
AND s.player_id = p.id
GROUP BY p.id
competition_name ttl 1 1st 2nd 3rd concat( 'http://figure2.me/slfs/competitions/viewrd/', r.competition_id, '/10')
Sochi Olympic 2014 660 Adelina SOTNIKOVA Yuna KIM Carolina KOSTNER http://figure2.me/slfs/competitions/viewrd/123/10
Vancouver Olympic 2010 637 Yuna KIM Mao ASADA Joannie ROCHETTE http://figure2.me/slfs/competitions/viewrd/26/10
ISU World Championships 2014 628 Mao ASADA Julia LIPNITSKAIA Carolina KOSTNER http://figure2.me/slfs/competitions/viewrd/137/10
ISU World Figure Skating Championships 2013 613 Yuna KIM Carolina KOSTNER Mao ASADA http://figure2.me/slfs/competitions/viewrd/110/10
ISU European Figure Skating Championships 2015 612 Elizaveta TUKTAMYSHEVA Elena RADIONOVA Anna POGORILAYA http://figure2.me/slfs/competitions/viewrd/174/10
ISU European Championships 2014 603 Julia LIPNITSKAIA Adelina SOTNIKOVA Carolina KOSTNER http://figure2.me/slfs/competitions/viewrd/119/10
ISU GP Rostelecom Cup 2015 603 Elena RADIONOVA Evgenia MEDVEDEVA Adelina SOTNIKOVA http://figure2.me/slfs/competitions/viewrd/233/10
ISU GP 2015 Progressive Skate America 597 Evgenia MEDVEDEVA Gracie GOLD Satoko MIYAHARA http://figure2.me/slfs/competitions/viewrd/177/10
ISU World Figure Skating Championships 2015 595 Elizaveta TUKTAMYSHEVA Satoko MIYAHARA Elena RADIONOVA http://figure2.me/slfs/competitions/viewrd/176/10
ISU Grand Prix of Figure Skating Final 2014 592 Elizaveta TUKTAMYSHEVA Elena RADIONOVA Ashley WAGNER http://figure2.me/slfs/competitions/viewrd/173/10
男子のベスト3はこちら
ISU World Championships 2014 841 Yuzuru HANYU Tatsuki MACHIDA Javier FERNANDEZ http://figure2.me/slfs/competitions/viewrd/137/10
ISU Grand Prix Final 2013-14 829 Yuzuru HANYU Patrick CHAN Nobunari ODA http://figure2.me/slfs/competitions/viewrd/118/10
ISU World Figure Skating Championships 2015 813 Javier FERNANDEZ Yuzuru HANYU Denis TEN http://figure2.me/slfs/competitions/viewrd/176/10