Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*In the following table, every row is a Top 8 match.*/
- data Gaming.PlayoffMatches;
- length FirstName1 $ 20;
- length LastName1 $ 20;
- length FirstName2 $ 20;
- length LastName2 $ 20;
- length FirstNameWinner $ 20;
- length LastNameWinner $ 20;
- input TournamentID $ FirstName1 $ LastName1 $ FirstName2 $ LastName2 $ FirstNameWinner $ LastNameWinner $;
- datalines;
- Gua13 Ken Yukuhiro Emiliano Sanchez Ken Yukuhiro
- Gua13 Andres Martinez Monge Hernandez Andres Martinez
- Gua13 Gonzalez Delgado Willy Edel Willy Edel
- Gua13 Emmanuel Sanchez Juan Castillo Juan Castillo
- Gua13 Ken Yukuhiro Andres Martinez Andres Martinez
- Gua13 Willy Edel Juan Castillo Willy Edel
- Gua13 Andres Martinez Willy Edel Andres Martinez
- Got13 Thoralf Severin Mark Dictus Thoralf Severin
- Got13 Mats Törnros Michal Gajewski Mats Törnros
- Got13 Oscar Christensen Jan VanDerVegt Oscar Christensen
- Got13 Robin Steinborn Antti Varhimo Robin Steinborn
- Got13 Thoralf Severin Mats Törnros Mats Törnros
- Got13 Oscar Christensen Robin Steinborn Oscar Christensen
- Got13 Mats Törnros Oscar Christensen Oscar Christensen
- Mal12 Jasper Grimmer Soren Larsen Soren Larsen
- Mal12 Jon Westberg Oscar Almgren Oscar Almgren
- Mal12 Matteo Versari Samuele Estratti Matteo Versari
- Mal12 David Hylander Pere LlimosMuntal Pere LlimosMuntal
- Mal12 Soren Larsen Oscar Almgren Oscar Almgren
- Mal12 Matteo Versari Pere LlimosMuntal Matteo Versari
- Mal12 Oscar Almgren Matteo Versari Matteo Versari
- Min12 Rick Stout Jerret Schultz Rick Stout
- Min12 Christian Calcano Josh Utter-Leyton Christian Calcano
- Min12 Brad Nelson Ben Friedman Brad Nelson
- Min12 Taylor Laehn Stephen Bishop Stephen Bishop
- Min12 Rick Stout Christian Calcano Christian Calcano
- Min12 Brad Nelson Stephen Bishop Brad Nelson
- Min12 Christian Calcano Brad Nelson Christian Calcano
- Ana12 Paul Rietzl Jason Rosellini Paul Rietzl
- Ana12 Eric Froehlich Brian Kibler Eric Froehlich
- Ana12 Noah Koessel John Sittner Noah Koessel
- Ana12 Michael Hopkins Mark Lalague Mark Lalague
- Ana12 Paul Rietzl Eric Froehlich Paul Rietzl
- Ana12 Noah Koessel Mark Lalague Mark Lalague
- Ana12 Paul Rietzl Mark Lalague Mark Lalague
- Mla12 Yuuya Watanabe Jacklord Nerez Yuuya Watanabe
- Mla12 Martin Juza Richmond Tan Richmond Tan
- Mla12 Jonathan Luces Rick Lee Rick Lee
- Mla12 Hironobu Sugaya Weng Soh Hironobu Sugaya
- Mla12 Yuuya Watanabe Richmond Tan Yuuya Watanabe
- Mla12 Rick Lee Hironobu Sugaya Rick Lee
- Mla12 Yuuya Watanabe Rick Lee Yuuya Watanabe
- Van12 Marcin Sciesinski Sean Peterson Marcin Sciesinski
- Van12 Jeremey Schofield Brian Wong Jeremey Schofield
- Van12 Morgan Chang Steven Riecken Steven Riecken
- Van12 David Stroud Colin Miller David Stroud
- Van12 Marcin Sciesinski Jeremey Schofield Jeremey Schofield
- Van12 Steven Riecken David Stroud David Stroud
- Van12 David Stroud Jeremey Schofield David Stroud
- Col12 Shenhar Shahar Estrin Aaron Estrin Aaron
- Col12 Maynard Jacob Beasley Orrin Maynard Jacob
- Col12 Siow Lucas Estrada Caleb Siow Lucas
- Col12 Piland Chris Tietze Max Tietze Max
- Col12 Estrin Aaron Maynard Jacob Maynard Jacob
- Col12 Siow Lucas Tietze Max Siow Lucas
- Col12 Maynard Jacob Siow Lucas Maynard Jacob
- Gnt12 Schünemann Timo Tristan Polzl Schünemann Timo
- Gnt12 Klocker Elias Watsfeldt Elias Watsfeldt Elias
- Gnt12 Sjoblom Max Maurer Lukas Maurer Lukas
- Gnt12 Marcotti Emanuele Milillo Andrea Marcotti Emanuele
- Gnt12 Schünemann Timo Watsfeldt Elias Schünemann Timo
- Gnt12 Maurer Lukas Marcotti Emanuele Maurer Lukas
- Gnt12 Schünemann Timo Maurer Lukas Schünemann Timo
- SP12 Reinaldo daSilva Rafael Mendonca Reinaldo daSilva
- SP12 Jose Silva Luiz DeLima Jose Silva
- SP12 Rodrigo dosSant Daniel Fior Rodrigo dosSant
- SP12 Thiago Oliveira Guido Quintana Thiago Oliveira
- SP12 Reinaldo daSilva Jose Silva Reinaldo daSilva
- SP12 Rodrigo dosSant Thiago Oliveira Rodrigo dosSant
- SP12 Reinaldo daSilva Rodrigo dosSant Reinaldo daSilva
- Atl12 Ben Stark Fred Edelkamp Fred Edelkamp
- Atl12 Gaudenis Vidugiris Sawyer Lucy Gaudenis Vidugiris
- Atl12 Daryl Ayers Samuel Black Daryl Ayers
- Atl12 Michael Majors Gerardo Fedon Michael Majors
- Atl12 Fred Edelkamp Gaudenis Vidugiris Gaudenis Vidugiris
- Atl12 Daryl Ayers Michael Majors Michael Majors
- Atl12 Gaudenis Vidugiris Michael Majors Gaudenis Vidugiris
- Yok12 Satoshi Yamaguchi Masaki Ushijima Satoshi Yamaguchi
- Yok12 Hiroya Miyamoto Kei Umehara Kei Umehara
- Yok12 Jyun'ichi Miyajima Youichi Nagami Jyun'ichi Miyajima
- Yok12 Toshiyuki Kadooka Yuki Yotsumoto Toshiyuki Kadooka
- Yok12 Satoshi Yamaguchi Kei Umehara Kei Umehara
- Yok12 Jyun'ichi Miyajima Toshiyuki Kadooka Jyun'ichi Miyajima
- Yok12 Jyun'ichi Miyajima Kei Umehara Jyun'ichi Miyajima
- Sha12 Li Bo Nicholas Wong Li Bo
- Sha12 Song Xue Wu Nan Wu Nan
- Sha12 Wang Yang Satou Rei Satou Rei
- Sha12 Kanegawa Toshiya Gu Fengwen Gu Fengwen
- Sha12 Li Bo Wu Nan Li Bo
- Sha12 Satou Rei Gu Fengwen Gu Fengwen
- Sha12 Gu Fengwen Li Bo Li Bo
- Mos12 Chuhwichev Anatoly Kuznetsov Petr Kuznetsov Petr
- Mos12 Tolkatchov Dmitriy Krautmann Wenzel Krautmann Wenzel
- Mos12 Kerem Hannes Masaladzhiu Roman Masaladzhiu Roman
- Mos12 Yarosh Konstantin Casadei Luca Casadei Luca
- Mos12 Kuznetsov Petr Krautmann Wenzel Krautmann Wenzel
- Mos12 Masaladzhiu Roman Casadei Luca Casadei Luca
- Mos12 Krautmann Wenzel Casadei Luca Casadei Luca
- CR12 Shuuhei Nakamura A.J. Sacher Shuuhei Nakamura
- CR12 Willy Edel Pascal Maynard Willy Edel
- CR12 Josh Utter-Leyton Ben Stark Ben Stark
- CR12 David Sharfman David Ochoa David Sharfman
- CR12 Shuuhei Nakamura Willy Edel Shuuhei Nakamura
- CR12 Ben Stark David Sharfman David Sharfman
- CR12 Shuuhei Nakamura David Sharfman Shuuhei Nakamura
- Bos12 Cedric Phillips Shouta Yasooka Cedric Phillips
- Bos12 Robert Victory Jason Ford Robert Victory
- Bos12 Alex Lloyd Kevin Michael Alex Lloyd
- Bos12 Thomas Holzinger Brian Demars Brian Demars
- Bos12 Cedric Phillips Robert Victory Robert Victory
- Bos12 Alex Lloyd Brian Demars Brian Demars
- Bos12 Robert Victory Brian Demars Brian Demars
- Phi12 Jake Gans Martin Juza Martin Juza
- Phi12 Luis Scott-Vargas Shuhei Nakamura Shuhei Nakamura
- Phi12 Lukas Jaklovsky Harry Corvese Lukas Jaklovsky
- Phi12 Greg Smith Yuuya Watanabe Greg Smith
- Phi12 Martin Juza Shuhei Nakamura Shuhei Nakamura
- Phi12 Lukas Jaklovsky Greg Smith Lukas Jaklovsky
- Phi12 Lukas Jaklovsky Shuhei Nakamura Shuhei Nakamura
- Auc12 Yoshitoki Sakai Anthony Purdom Yoshitoki Sakai
- Auc12 Adam Witton Robert Liu Adam Witton
- Auc12 Justin Cheung Dylan Brown Dylan Brown
- Auc12 John Denz Walker MacMurdo Walker MacMurdo
- Auc12 Yoshitoki Sakai Adam Witton Adam Witton
- Auc12 Dylan Brown Walker MacMurdo Walker MacMurdo
- Auc12 Adam Witton Walker MacMurdo Walker MacMurdo
- Lyo12 Peter Dun Jeremy Dezani Jeremy Dezani
- Lyo12 Mathieu Hautot Clement Sarton Mathieu Hautot
- Lyo12 Olivier Ruel Davide Colla Davide Colla
- Lyo12 Emanuel Sutor Jonas Köstler Emanuel Sutor
- Lyo12 Jeremy Dezani Mathieu Hautot Jeremy Dezani
- Lyo12 Davide Colla Emanuel Sutor Emanuel Sutor
- Lyo12 Jeremy Dezani Emanuel Sutor Jeremy Dezani
- Chi12 Shane McDermott Josh Utter-Leyton Josh Utter-Leyton
- Chi12 Ryan Hovis Alex Majlaton Alex Majlaton
- Chi12 Jacob Wilson David Gleicher Jacob Wilson
- Chi12 Edgar Flores Michael Simon Edgar Flores
- Chi12 Josh Utter-Leyton Alex Majlaton Josh Utter-Leyton
- Chi12 Jacob Wilson Edgar Flores Jacob Wilson
- Chi12 Josh Utter-Leyton Jacob Wilson Jacob Wilson
- Boc12 Enrico Eijsden Kamil Napierski Kamil Napierski
- Boc12 Sascha Stein Martin Juza Martin Juza
- Boc12 Pierre Dagen Fabian Dickmann Fabian Dickmann
- Boc12 Lukas Tajak Tomas Vanek Tomas Vanek
- Boc12 Kamil Napierski Martin Juza Martin Juza
- Boc12 Fabian Dickmann Tomas Vanek Fabian Dickmann
- Boc12 Martin Juza Fabian Dickmann Martin Juza
- Tai12 Weng Soh Derek Tsang Weng Soh
- Tai12 Akimasa Yamamoto Toshiaki Murata Akimasa Yamamoto
- Tai12 Motoki Abe ShiTian Lee Motoki Abe
- Tai12 Yuuya Watanabe Makihito Mihara Makihito Mihara
- Tai12 Weng Soh Akimasa Yamamoto Akimasa Yamamoto
- Tai12 Motoki Abe Makihito Mihara Makihito Mihara
- Tai12 Akimasa Yamamoto Makihito Mihara Makihito Mihara
- San12 Tyler Lytle Matthew Thurber Tyler Lytle
- San12 Harry Corvese Reid Duke Reid Duke
- San12 Conley Woods Joel DeSantos Conley Woods
- San12 Matthew Pratser Ben Rasmussen Matthew Pratser
- San12 Tyler Lytle Reid Duke Tyler Lytle
- San12 Conley Woods Matthew Pratser Matthew Pratser
- San12 Tyler Lytle Matthew Pratser Tyler Lytle
- Cha12 Reid Duke Peter Kelly Peter Kelly
- Cha12 Patrick Cox Brian Eason Brian Eason
- Cha12 Matt Keene Gerry Thompson Matt Keene
- Cha12 Jon Bolding Morgan Chang Jon Bolding
- Cha12 Peter Kelly Brian Eason Brian Eason
- Cha12 Matt Keene Jon Bolding Jon Bolding
- Cha12 Brian Eason Jon Bolding Jon Bolding
- Lis12 Helder Coelho Sveinung Bjørnerud Sveinung Bjørnerud
- Lis12 Lasse Nørgaard Ivan Floch Ivan Floch
- Lis12 Elias Watsfeldt David Calas Elias Watsfeldt
- Lis12 Pedro Carvalho Johan Verhulst Johan Verhulst
- Lis12 Sveinung Bjørnerud Ivan Floch Ivan Floch
- Lis12 Elias Watsfeldt Johan Verhulst Elias Watsfeldt
- Lis12 Ivan Floch Elias Watsfeldt Ivan Floch
- Nag12 Kyouhei Kawaguchi Ryuzi Murae Ryuzi Murae
- Nag12 Kenji Tsumura Yuuji Okita Yuuji Okita
- Nag12 Rahman Aryabhima Kazuaki Shinohara Rahman Aryabhima
- Nag12 Mamoru Nagai Kazumasa Satou Mamoru Nagai
- Nag12 Ryuzi Murae Yuuji Okita Yuuji Okita
- Nag12 Rahman Aryabhima Mamoru Nagai Rahman Aryabhima
- Nag12 Yuuji Okita Rahman Aryabhima Yuuji Okita
- Tor12 Alon Chitiz Dan Jordan Alon Chitiz
- Tor12 Jon Stern Sam Pardee Sam Pardee
- Tor12 James Vance Willy Edel Willy Edel
- Tor12 Collin Morton Alex Majlaton Alex Majlaton
- Tor12 Alon Chitiz Sam Pardee Sam Pardee
- Tor12 Willy Edel Alex Majlaton Willy Edel
- Tor12 Sam Pardee Willy Edel Willy Edel
- Ind13 Ben Stark Tom Martell Ben Stark
- Ind13 Brian Demars Matthias Hunt Brian Demars
- Ind13 Chris Fennell Adam Yurchick Chris Fennell
- Ind13 Tyler Lytle Luis Scott-Vargas Luis Scott-Vargas
- Ind13 Ben Stark Brian Demars Ben Stark
- Ind13 Luis Scott-Vargas Chris Fennell Chris Fennell
- Ind13 Ben Stark Chris Fennell Ben Stark
- Den13 Vidianto Wijaya Donnie Peck Vidianto Wijaya
- Den13 Joshua Ravitz Daniel Signorini Joshua Ravitz
- Den13 Matthew Nass Patrick Cox Patrick Cox
- Den13 Ryan Pesch Andrew Ohlschwager Ryan Pesch
- Den13 Vidianto Wijaya Joshua Ravitz Vidianto Wijaya
- Den13 Patrick Cox Ryan Pesch Patrick Cox
- Den13 Vidianto Wijaya Patrick Cox Vidianto Wijaya
- Sin13 Lin Rui Xing Zhen Lin Rui
- Sin13 Huang Hao-Shan Chapman Sim Chapman Sim
- Sin13 Ken Yukuhiro Toshiya Kanegawa Ken Yukuhiro
- Sin13 Jun'ya Nakamura Andrew Cantillana Andrew Cantillana
- Sin13 Lin Rui Chapman Sim Chapman Sim
- Sin13 Ken Yukuhiro Andrew Cantillana Ken Yukuhiro
- Sin13 Chapman Sim Ken Yukuhiro Ken Yukuhiro
- Atl13 Brad Nelson Seneca Hobler Brad Nelson
- Atl13 Matt Costa Jon Stern Jon Stern
- Atl13 Ari Lax Lloyd Kurth Ari Lax
- Atl13 Josh Utter-Leyton Ryan Leverone Josh Utter-Leyton
- Atl13 Brad Nelson Jon Stern Jon Stern
- Atl13 Ari Lax Josh Utter-Leyton Josh Utter-Leyton
- Atl13 Josh Utter-Leyton Jon Stern Jon Stern
- Syd13 Adam Witton Justin Cheung Justin Cheung
- Syd13 Daniel Unwin Tomoharu Saito Tomoharu Saito
- Syd13 Stanislav Cifka Zen Takahashi Zen Takahashi
- Syd13 Allen Zhang Martin Juza Allen Zhang
- Syd13 Justin Cheung Tomoharu Saito Justin Cheung
- Syd13 Zen Takahashi Allen Zhang Allen Zhang
- Syd13 Allen Zhang Justin Cheung Allen Zhang
- Bil13 Lukas Jaklovsky Francisco Camacho Lukas Jaklovsky
- Bil13 Vasco Bonifacio Lorenzo Calzolari Vasco Bonifacio
- Bil13 Louis Deltour Mathieu Deloly Louis Deltour
- Bil13 Mitchell Manders Martin Scheinin Mitchell Manders
- Bil13 Lukas Jaklovsky Vasco Bonifacio Lukas Jaklovsky
- Bil13 Louis Deltour Mitchell Manders Mitchell Manders
- Bil13 Mitchell Manders Lukas Jaklovsky Mitchell Manders
- Lon13 Jamie Ross Manuel Hauck Manuel Hauck
- Lon13 Timothee Simonot Per Carlsson Timothee Simonot
- Lon13 Fabrizio Anteri Bartomie Tomiczek Bartomie Tomiczek
- Lon13 David Reitbauer Andreas Nordahl David Reitbauer
- Lon13 Manuel Hauck Timothee Simonot Timothee Simonot
- Lon13 Bartomie Tomiczek David Reitbauer Bartomie Tomiczek
- Lon13 Timothee Simonot Bartomie Tomiczek Timothee Simonot
- Que13 Felipe TapiaBecerra Wenzel Krautmann Felipe TapiaBecerra
- Que13 Thomas Holzinger TzuChing Kuo TzuChing Kuo
- Que13 Nico Christiansen Maxime Cantin Nico Christiansen
- Que13 Reid Duke Wilson Wong Reid Duke
- Que13 Felipe TapiaBecerra TzuChing Kuo TzuChing Kuo
- Que13 Reid Duke Nico Christiansen Nico Christiansen
- Que13 TzuChing Kuo Nico Christiansen Nico Christiansen
- Por13 Mattia Rizzi Joe Demestrio Joe Demestrio
- Por13 Zvi Mowshowitz Matt Nass Zvi Mowshowitz
- Por13 Sam Pardee Paul Rietzl Sam Pardee
- Por13 Guo Orie Dan MacDonald Dan MacDonald
- Por13 Joe Demestrio Zvi Mowshowitz Joe Demestrio
- Por13 Sam Pardee Dan MacDonald Sam Pardee
- Por13 Sam Pardee Joe Demestrio Sam Pardee
- Bei13 Bo Li Toshiya Kanegawa Toshiya Kanegawa
- Bei13 Quan Zhou Nandi Zhang Quan Zhou
- Bei13 Daniel Godfrey WeiQuan Wong WeiQuan Wong
- Bei13 Shuo Li Nonthakorn Kositaporn Nonthakorn Kositaporn
- Bei13 Toshiya Kanegawa Quan Zhou Quan Zhou
- Bei13 WeiQuan Wong Nonthakorn Kositaporn Nonthakorn Kositaporn
- Bei13 Quan Zhou Nonthakorn Kositaporn Quan Zhou
- Str13 Alexander Hayne Fabian Görzgen Alexander Hayne
- Str13 Alexey Romanchuk Jacob Wilson Jacob Wilson
- Str13 Thomas Enevoldsen Christopher Brunner Thomas Enevoldsen
- Str13 Michael Bonde Hove Thießen Michael Bonde
- Str13 Alexander Hayne Jacob Wilson Jacob Wilson
- Str13 Thomas Enevoldsen Michael Bonde Thomas Enevoldsen
- Str13 Jacob Wilson Thomas Enevoldsen Thomas Enevoldsen
- Pit13 Michael Derczo Brock Parker Brock Parker
- Pit13 Adam Carrasco Gabby Izsak Gabby Izsak
- Pit13 Chase Kovac Alec Nezin Alec Nezin
- Pit13 Matthew Falcioni Eric Froehlich Eric Froehlich
- Pit13 Brock Parker Gabby Izsak Brock Parker
- Pit13 Alec Nezin Eric Froehlich Alec Nezin
- Pit13 Brock Parker Alec Nezin Brock Parker
- SD13 Eric Froehlich Matt Ferrando Eric Froehlich
- SD13 Nathan Holiday Brian Kibler Nathan Holiday
- SD13 Bryan DeLaTorre Sammy Tukeman Sammy Tukeman
- SD13 David Sharfman Ken Yukuhiro David Sharfman
- SD13 Eric Froehlich Nathan Holiday Nathan Holiday
- SD13 Sammy Tukeman David Sharfman Sammy Tukeman
- SD13 Nathan Holiday Sammy Tukeman Nathan Holiday
- Rio13 Wellington Cordeiro Walter Filho Walter Filho
- Rio13 Artur Villela Jorge Siqueira Artur Villela
- Rio13 Martan Quiroga Jose Silva Jose Silva
- Rio13 Andres Monsalve Matias Arvigo Andres Monsalve
- Rio13 Walter Filho Artur Villela Artur Villela
- Rio13 Jose Silva Andres Monsalve Jose Silva
- Rio13 Artur Villela Jose Silva Jose Silva
- Ver13 Toni RamisPascual Samuele Estratti Samuele Estratti
- Ver13 Shahar Shenhar Mike Krasnitski Mike Krasnitski
- Ver13 Jeremy Dezani Max Schultze Jeremy Dezani
- Ver13 Andreas Nilsson Piotr Wald Andreas Nilsson
- Ver13 Samuele Estratti Mike Krasnitski Mike Krasnitski
- Ver13 Jeremy Dezani Andreas Nilsson Andreas Nilsson
- Ver13 Mike Krasnitski Andreas Nilsson Mike Krasnitski
- Yok13 Tomomi Shiraishi Masaya Kitayama Masaya Kitayama
- Yok13 Sam Black Yasutaka Hibino Sam Black
- Yok13 Shintarou Ishimura Makihito Mihara Makihito Mihara
- Yok13 Tomoya Motomura Tian Zhao Tian Zhao
- Yok13 Masaya Kitayama Sam Black Masaya Kitayama
- Yok13 Makihito Mihara Tian Zhao Tian Zhao
- Yok13 Masaya Kitayama Tian Zhao Masaya Kitayama
- Cha13 Antonino Baldasari Aaron Lewis Aaron Lewis
- Cha13 Frank Skarren Richard Nguyen Frank Skarren
- Cha13 Ben Stark Gerard Fabiano Gerard Fabiano
- Cha13 Patrick Sullivan Ben Isgur Patrick Sullivan
- Cha13 Aaron Lewis Frank Skarren Frank Skarren
- Cha13 Gerard Fabiano Patrick Sullivan Gerard Fabiano
- Cha13 Frank Skarren Gerard Fabiano Frank Skarren
- Veg13 Dustin Ochoa Jeff Psyhos Dustin Ochoa
- Veg13 Steve Cahill Neal Oliver Neal Oliver
- Veg13 Sean Collins Madison Jonas Madison Jonas
- Veg13 Lance Hartbarger Justin Nguyen Lance Hartbarger
- Veg13 Dustin Ochoa Neal Oliver Neal Oliver
- Veg13 Madison Jonas Lance Hartbarger Madison Jonas
- Veg13 Neal Oliver Madison Jonas Neal Oliver
- Ban13 Triphonratana Boonyar Patriawan Kurniadi Patriawan Kurniadi
- Ban13 HuangYu Chung Tan Raymond HuangYu Chung
- Ban13 Wong Nicholas Kamolto Chanaphon Wong Nicholas
- Ban13 Watanabe Yuuya Beaumer Michael Watanabe Yuuya
- Ban13 Patriawan Kurniadi HuangYu Chung Patriawan Kurniadi
- Ban13 Wong Nicholas Watanabe Yuuya Wong Nicholas
- Ban13 Patriawan Kurniadi Wong Nicholas Patriawan Kurniadi
- Hou13 Marc Lalague Darin Minard Marc Lalague
- Hou13 Tom Ross David Bruno Tom Ross
- Hou13 Shahar Shenhar Shuuhei Nakamura Shahar Shenhar
- Hou13 Mani Davoudi Phu Dao Phu Dao
- Hou13 Marc Lalague Tom Ross Tom Ross
- Hou13 Shahar Shenhar Phu Dao Shahar Shenhar
- Hou13 Shahar Shenhar Tom Ross Shahar Shenhar
- Pra13 Raphael Levy Balazs Varady Balazs Varady
- Pra13 Martin Juza Marco Cammilluzzi Marco Cammilluzzi
- Pra13 Amit Cohen Kai Mokrusch Kai Mokrusch
- Pra13 Anatoly Chuhwichov Eliott Boussaudi Anatoly Chuhwichov
- Pra13 Balazs Varady Marco Cammilluzzi Marco Cammilluzzi
- Pra13 Kai Mokrusch Anatoly Chuhwichov Anatoly Chuhwichov
- Pra13 Marco Cammilluzzi Anatoly Chuhwichov Anatoly Chuhwichov
- Oak13 Travis Woo Joshua Goldman Joshua Goldman
- Oak13 William Jensen Elliott Woo William Jensen
- Oak13 Ben Lundquist Carlos Ale Ben Lundquist
- Oak13 Patrick Griffin Neal Oliver Neal Oliver
- Oak13 Joshua Goldman William Jensen William Jensen
- Oak13 Ben Lundquist Neal Oliver Neal Oliver
- Oak13 William Jensen Neal Oliver William Jensen
- War13 Jeremy Dezani Przemek Oberbek Jeremy Dezani
- War13 Yann Robin Felipe TapiaBecerra Felipe TapiaBecerra
- War13 Michal Kolacinski Denniz Rachid Michal Kolacinski
- War13 Wenzel Krautmann Niklas Ramquist Wenzel Krautmann
- War13 Jeremy Dezani Felipe TapiaBecerra Felipe TapiaBecerra
- War13 Wenzel Krautmann Michal Kolacinski Felipe TapiaBecerra
- War13 Wenzel Krautmann Felipe TapiaBecerra Wenzel Krautmann
- Cal13 Brady Boychuk Trent Douglas Brady Boychuk
- Cal13 Adam Laforest Stephane Gerard Stephane Gerard
- Cal13 Ryan Zawalsky Gavin Bennett Ryan Zawalsky
- Cal13 Jacob Wilson Alexander Hayne Alexander Hayne
- Cal13 Brady Boychuk Stephane Gerard Stephane Gerard
- Cal13 Ryan Zawalsky Alexander Hayne Alexander Hayne
- Cal13 Alexander Hayne Stephane Gerard Alexander Hayne
- Rim13 Emanuele Giusti Pierre Sommen Emanuele Giusti
- Rim13 Tamas Nagy Christoph Aukenthaler Christoph Aukenthaler
- Rim13 Federico DelBasso Stjepan Sucic Federico DelBasso
- Rim13 Ben Stark Rasmus Björklund Rasmus Björklund
- Rim13 Emanuele Giusti Christoph Aukenthaler Christoph Aukenthaler
- Rim13 Federico DelBasso Rasmus Björklund Rasmus Björklund
- Rim13 Christoph Aukenthaler Rasmus Björklund Christoph Aukenthaler
- KC13 Robert Berni Greg Ogreenc Robert Berni
- KC13 Seth Manfield Brandon Nelson Seth Manfield
- KC13 Scott Hoppe Casey Swanson Scott Hoppe
- KC13 Joe Hemmann Ari Lax Joe Hemmann
- KC13 Robert Berni Seth Manfield Seth Manfield
- KC13 Scott Hoppe Joe Hemmann Joe Hemmann
- KC13 Seth Manfield Joe Hemmann Seth Manfield
- Mia13 Brad Nelson Matthew Costa Brad Nelson
- Mia13 Samuel Tharmaratnam Reid Duke Reid Duke
- Mia13 Josh McClain Christoffer Larsen Josh McClain
- Mia13 Valentin Mackl Peter Ingram Valentin Mackl
- Mia13 Brad Nelson Reid Duke Reid Duke
- Mia13 Josh McClain Valentin Mackl Josh McClain
- Mia13 Reid Duke Josh McClain Reid Duke
- Shi13 Shota Takao Jun'ya Iyanaga Shota Takao
- Shi13 Kazuaki Fujimura Shota Yasooka Shota Yasooka
- Shi13 Hajime Nakashima Tadaki Tsukagoshi Hajime Nakashima
- Shi13 Ryo Nakada Keisuke Sato Ryo Nakada
- Shi13 Shota Takao Shota Yasooka Shota Takao
- Shi13 Hajime Nakashima Ryo Nakada Ryo Nakada
- Shi13 Shota Takao Ryo Nakada Ryo Nakada
- Dfw13 Haibing Hu Carlos Reyes Carlos Reyes
- Dfw13 Darin Minard William Jensen William Jensen
- Dfw13 Eric Centauri Ben Stark Ben Stark
- Dfw13 Seth Manfield Marlon Gutierrez Marlon Gutierrez
- Dfw13 Carlos Reyes William Jensen William Jensen
- Dfw13 Ben Stark Marlon Gutierrez Marlon Gutierrez
- Dfw13 William Jensen Marlon Gutierrez Marlon Gutierrez
- Vie13 Robin Dolar Oliver Polak-Rottmann Robin Dolar
- Vie13 Jeremy Dezani Stanislav Cifka Jeremy Dezani
- Vie13 Marcin Staciwa Johan Prinzell Marcin Staciwa
- Vie13 Niklas Kaltenböck Manuel Cecilia Niklas Kaltenböck
- Vie13 Robin Dolar Jeremy Dezani Robin Dolar
- Vie13 Niklas Kaltenböck Marcin Staciwa Marcin Staciwa
- Vie13 Robin Dolar Marcin Staciwa Marcin Staciwa
- Tor13 Ari Lax Ben Moir Ari Lax
- Tor13 William Jensen Edgar Magalhaes William Jensen
- Tor13 Richard Kraupa Seth Manfield Richard Kraupa
- Tor13 Greg Ogreenc Robert Smith Greg Ogreenc
- Tor13 Ari Lax William Jensen Ari Lax
- Tor13 Richard Kraupa Greg Ogreenc Greg Ogreenc
- Tor13 Ari Lax Greg Ogreenc Ari Lax
- Abq13 Samuel Pardee Paul Rietzl Samuel Pardee
- Abq13 Andrew Hanson Todd Anderson Todd Anderson
- Abq13 Sam Black Valentin Mackl Valentin Mackl
- Abq13 Joseph Nix Owen Turtenwald Owen Turtenwald
- Abq13 Samuel Pardee Todd Anderson Samuel Pardee
- Abq13 Valentin Mackl Owen Turtenwald Owen Turtenwald
- Abq13 Samuel Pardee Owen Turtenwald Owen Turtenwald
- Was13 Craig Wescoe Sam Black Sam Black
- Was13 Andrew Cuneo Owen Turtenwald Owen Turtenwald
- Was13 Jared Boettcher Deshaun Baylock Jared Boettcher
- Was13 Drew Tunison Ted McCluskie Drew Tunison
- Was13 Sam Black Owen Turtenwald Owen Turtenwald
- Was13 Jared Boettcher Drew Tunison Jared Boettcher
- Was13 Owen Turtenwald Jared Boettcher Owen Turtenwald
- Val13 Butakov Dmitriy Mackl Valentin Mackl Valentin
- Val13 Marti Samuel Laizans Aleksejs Marti Samuel
- Val13 Gusiev Andrii Lombardi Piero Gusiev Andrii
- Val13 Maestro Roberto Chalecki Ed Chalecki Ed
- Val13 Mackl Valentin Marti Samuel Marti Samuel
- Val13 Gusiev Andrii Chalecki Ed Gusiev Andrii
- Val13 Marti Samuel Gusiev Andrii Marti Samuel
- Snt13 Cristian Valdivia Destri Barbosa Cristian Valdivia
- Snt13 Luis Navas Carlos Montenegro Luis Navas
- Snt13 Matias Soler Jonathan Melamed Matias Soler
- Snt13 Luis Salvatto Nicolas DeNicola Nicolas DeNicola
- Snt13 Cristian Valdivia Luis Navas Luis Navas
- Snt13 Matias Soler Nicolas DeNicola Matias Soler
- Snt13 Luis Navas Matias Soler Luis Navas
- Ant13 Anteri Fabrizio Bonneau Alexandre Anteri Fabrizio
- Ant13 Sotiriadi Nazar Rúnarsson Herman Sotiriadi Nazar
- Ant13 Björklund Rasmus Fior Daniel Björklund Rasmus
- Ant13 Hendriks Thomas Dickmann Patrick Dickmann Patrick
- Ant13 Anteri Fabrizio Sotiriadi Nazar Anteri Fabrizio
- Ant13 Björklund Rasmus Dickmann Patrick Dickmann Patrick
- Ant13 Anteri Fabrizio Dickmann Patrick Dickmann Patrick
- Lou13 Sam Black Alex Sittner Alex Sittner
- Lou13 Brad Nelson Brian Braun-Duin Brian Braun-Duin
- Lou13 Jon Stern William Jensen Jon Stern
- Lou13 Andrew Baeckstrom Todd Anderson Andrew Baeckstrom
- Lou13 Alex Sittner Brian Braun-Duin Brian Braun-Duin
- Lou13 Jon Stern Andrew Baeckstrom Jon Stern
- Lou13 Brian Braun-Duin Jon Stern Brian Braun-Duin
- HK13 Yuuta Takahashi SoonLye Ng Yuuta Takahashi
- HK13 Lei YuSheng Shuhei Nakamura Shuhei Nakamura
- HK13 Ken Yukuhiro Denny Dunsford Ken Yukuhiro
- HK13 Martin Juza Xiaoshi Lu Martin Juza
- HK13 Yuuta Takahashi Shuhei Nakamura Shuhei Nakamura
- HK13 Ken Yukuhiro Martin Juza Martin Juza
- HK13 Shuhei Nakamura Martin Juza Shuhei Nakamura
- Okc13 Pierre-Christophe Mondo James Fulgium Pierre-Christophe Mondo
- Okc13 Ty Thomason Zach Dorsett Ty Thomason
- Okc13 Ty Brandstetter Rick Stout Ty Brandstetter
- Okc13 William Lowry John Penick John Penick
- Okc13 Pierre-Christophe Mondo Ty Thomason Pierre-Christophe Mondo
- Okc13 Ty Brandstetter John Penick John Penick
- Okc13 Pierre-Christophe Mondo John Penick Pierre-Christophe Mondo
- Bri13 Justin Cheung WeeYuen Khor Justin Cheung
- Bri13 Cameron Harris Justin Robb Justin Robb
- Bri13 Garry Wong Daniel Unwin Daniel Unwin
- Bri13 Wilfy Horig Ben Tudman Ben Tudman
- Bri13 Justin Cheung Justin Robb Justin Robb
- Bri13 Daniel Unwin Ben Tudman Daniel Unwin
- Bri13 Justin Robb Daniel Unwin Justin Robb
- Det13 Adam Jansen Ben Moir Ben Moir
- Det13 Reid Duke Marcelino Freeman Reid Duke
- Det13 Alex Majlaton Josh McClain Josh McClain
- Det13 Ben Stark Willy Edel Ben Stark
- Det13 Ben Moir Reid Duke Reid Duke
- Det13 Josh McClain Ben Stark Josh McClain
- Det13 Josh McClain Reid Duke Josh McClain
- Pra14 Bernhard Wurmitzer Marcel Kachapow Marcel Kachapow
- Pra14 Carlos Moral Jeremy Dezani Carlos Moral
- Pra14 Vjeran Horvat Robin Dolar Vjeran Horvat
- Pra14 Andrej Rutar Emanuele Giusti Emanuele Giusti
- Pra14 Marcel Kachapow Carlos Moral Marcel Kachapow
- Pra14 Vjeran Horvat Emanuele Giusti Vjeran Horvat
- Pra14 Vjeran Horvat Marcel Kachapow Vjeran Horvat
- Sac14 Nathannael Maliszewski Philip Yam Philip Yam
- Sac14 Aaron Lewis Andy Voellmer Aaron Lewis
- Sac14 Tom Martell Ryan Miller Tom Martell
- Sac14 Eric Pei Adam Mancuso Eric Pei
- Sac14 Philip Yam Aaron Lewis Philip Yam
- Sac14 Tom Martell Eric Pei Tom Martell
- Sac14 Tom Martell Philip Yam Tom Martell
- Van14 Sperling Matt Stern Jon Stern Jon
- Van14 Hwang Eugene Hayne Alexander Hayne Alexander
- Van14 Ruprecht Adam Gillespie Robert Gillespie Robert
- Van14 Sundholm Peter Vasovski Mike Sundholm Peter
- Van14 Stern Jon Hayne Alexander Hayne Alexander
- Van14 Gillespie Robert Sundholm Peter Sundholm Peter
- Van14 Hayne Alexander Sundholm Peter Hayne Alexander
- KL14 Shouta Yasooka Shamsul Zainuddin Shamsul Zainuddin
- KL14 Ryan Young Jack Teo Ryan Young
- KL14 Shamsul Zainuddin Mohd Khairul Shamsul Zainuddin
- KL14 Fabien Li Krissapas Kuptimitr Fabien Li
- KL14 Shamsul Zainuddin Ryan Young Ryan Young
- KL14 Shamsul Zainuddin Fabien Li Fabien Li
- KL14 Ryan Young Fabien Li Fabien Li
- Par14 Loïc LeBriand PV DDR Loïc LeBriand
- Par14 Jóse Castelló Javier Dominguez Javier Dominguez
- Par14 Maxime Gilles Stefan Böttcher Maxime Gilles
- Par14 Jean-Mary Accart Philipp Schönegger Philipp Schönegger
- Par14 Loïc LeBriand Javier Dominguez Javier Dominguez
- Par14 Maxime Gilles Philipp Schönegger Maxime Gilles
- Par14 Javier Dominguez Maxime Gilles Javier Dominguez
- Mex14 Marc Lalague Derek Woloshyn Marc Lalague
- Mex14 Emiliano Sanchez Ignacio Ibarra Ignacio Ibarra
- Mex14 Miguel Ange Hugo Daniel Hugo Daniel
- Mex14 Marcelino Freeman Mario Flores Marcelino Freeman
- Mex14 Marc Lalague Ignacio Ibarra Marc Lalague
- Mex14 Hugo Daniel Marcelino Freeman Marcelino Freeman
- Mex14 Marcelino Freeman Marc Lalague Marc Lalague
- run;
- /*In the following table, every row is a Top 8 competitor.*/
- data Gaming.RankingAfterSwiss;
- length FirstName $ 20;
- length LastName $ 20;
- input TournamentID $ RankAfterSwiss LastName $ FirstName $;
- datalines;
- Gua13 1 Yukuhiro Ken
- Gua13 2 Delgado Gonzalez
- Gua13 3 Sanchez Emmanuel
- Gua13 4 Martinez Andres
- Gua13 5 Hernandez Monge
- Gua13 6 Castillo Juan
- Gua13 7 Edel Willy
- Gua13 8 Sanchez Emiliano
- Got13 1 VanDerVegt Jan
- Got13 2 Dictus Mark
- Got13 3 Steinborn Robin
- Got13 4 Varhimo Antti
- Got13 5 Törnros Mats
- Got13 6 Gajewski Michal
- Got13 7 Severin Thoralf
- Got13 8 Christensen Oscar
- Mal12 1 Grimmer Jasper
- Mal12 2 Almgren Oscar
- Mal12 3 Westberg Jon
- Mal12 4 Larsen Soren
- Mal12 5 Versari Matteo
- Mal12 6 Estratti Samuele
- Mal12 7 LlimosMuntal Pere
- Mal12 8 Hylander David
- Min12 1 Stout Rick
- Min12 2 Nelson Brad
- Min12 3 Laehn Taylor
- Min12 4 Calcano Christian
- Min12 5 Utter-Leyton Josh
- Min12 6 Bishop Stephen
- Min12 7 Friedman Ben
- Min12 8 Schultz Jerret
- Ana12 1 Rietzl Paul
- Ana12 2 Koessel Noah
- Ana12 3 Hopkins Michael
- Ana12 4 Froehlich Eric
- Ana12 5 Kibler Brian
- Ana12 6 Lalague Mark
- Ana12 7 Sittner John
- Ana12 8 Rosellini Jason
- Mla12 1 Watanabe Yuuya
- Mla12 2 Luces Jonathan
- Mla12 3 Sugaya Hironobu
- Mla12 4 Juza Martin
- Mla12 5 Tan Richmond
- Mla12 6 Soh Weng
- Mla12 7 Lee Rick
- Mla12 8 Nerez Jacklord
- Van12 1 Schofield Jeremey
- Van12 2 Miller Colin
- Van12 3 Riecken Steven
- Van12 4 Wong Brian
- Van12 5 Sciesinski Marcin
- Van12 6 Stroud David
- Van12 7 Peterson Sean
- Van12 8 Chang Morgan
- Col12 1 Shahar Shenhar
- Col12 2 Lucas Siow
- Col12 3 Chris Piland
- Col12 4 Jacob Maynard
- Col12 5 Orrin Beasley
- Col12 6 Max Tietze
- Col12 7 Caleb Estrada
- Col12 8 Aaron Estrin
- Gnt12 1 Timo Schünemann
- Gnt12 2 Max Sjoblom
- Gnt12 3 Emanuele Marcotti
- Gnt12 4 Elias Klocker
- Gnt12 5 Elias Watsfeldt
- Gnt12 6 Andrea Milillo
- Gnt12 7 Lukas Maurer
- Gnt12 8 Polzl Tristan
- SP12 1 DeLima Luiz
- SP12 2 Quintana Guido
- SP12 3 Mendonca Rafael
- SP12 4 Oliveira Thiago
- SP12 5 daSilva Reinaldo
- SP12 6 Fior Daniel
- SP12 7 Silva Jose
- SP12 8 dosSant Rodrigo
- Atl12 1 Stark Ben
- Atl12 2 Ayers Daryl
- Atl12 3 Majors Michael
- Atl12 4 Vidugiris Gaudenis
- Atl12 5 Lucy Sawyer
- Atl12 6 Fedon Gerardo
- Atl12 7 Black Samuel
- Atl12 8 Edelkamp Fred
- Yok12 1 Yamaguchi Satoshi
- Yok12 2 Miyajima Jyun'ichi
- Yok12 3 Kadooka Toshiyuki
- Yok12 4 Miyamoto Hiroya
- Yok12 5 Umehara Kei
- Yok12 6 Yotsumoto Yuki
- Yok12 7 Nagami Youichi
- Yok12 8 Ushijima Masaki
- Sha12 1 Nan Wu
- Sha12 2 Fengwen Gu
- Sha12 3 Yang Wang
- Sha12 4 Wong Nicholas
- Sha12 5 Bo Li
- Sha12 6 Rei Satou
- Sha12 7 Xue Song
- Sha12 8 Toshiya Kanegawa
- Mos12 1 Anatoly Chuhwichev
- Mos12 2 Hannes Kerem
- Mos12 3 Konstantin Yarosh
- Mos12 4 Luca Casadei
- Mos12 5 Wenzel Krautmann
- Mos12 6 Petr Kuznetsov
- Mos12 7 Roman Masaladzhiu
- Mos12 8 Dmitriy Tolkatchov
- CR12 1 Nakamura Shuuhei
- CR12 2 Stark Ben
- CR12 3 Utter-Leyton Josh
- CR12 4 Ochoa David
- CR12 5 Edel Willy
- CR12 6 Sharfman David
- CR12 7 Sacher A.J.
- CR12 8 Maynard Pascal
- Bos12 1 Lloyd Alex
- Bos12 2 Phillips Cedric
- Bos12 3 Demars Brian
- Bos12 4 Michael Kevin
- Bos12 5 Victory Robert
- Bos12 6 Ford Jason
- Bos12 7 Holzinger Thomas
- Bos12 8 Yasooka Shouta
- Phi12 1 Juza Martin
- Phi12 2 Gans Jake
- Phi12 3 Nakamura Shuhei
- Phi12 4 Corvese Harry
- Phi12 5 Scott-Vargas Luis
- Phi12 6 Jaklovsky Lukas
- Phi12 7 Smith Greg
- Phi12 8 Watanabe Yuuya
- Auc12 1 Sakai Yoshitoki
- Auc12 2 Cheung Justin
- Auc12 3 Denz John
- Auc12 4 Witton Adam
- Auc12 5 Liu Robert
- Auc12 6 MacMurdo Walker
- Auc12 7 Brown Dylan
- Auc12 8 Purdom Anthony
- Lyo12 1 Dun Peter
- Lyo12 2 Ruel Olivier
- Lyo12 3 Sutor Emanuel
- Lyo12 4 Hautot Mathieu
- Lyo12 5 Sarton Clement
- Lyo12 6 Köstler Jonas
- Lyo12 7 Colla Davide
- Lyo12 8 Dezani Jeremy
- Chi12 1 McDermott Shane
- Chi12 2 Wilson Jacob
- Chi12 3 Flores Edgar
- Chi12 4 Hovis Ryan
- Chi12 5 Majlaton Alex
- Chi12 6 Simon Michael
- Chi12 7 Gleicher David
- Chi12 8 Utter-Leyton Josh
- Boc12 1 Eijsden Enrico
- Boc12 2 Dagen Pierre
- Boc12 3 Tajak Lukas
- Boc12 4 Stein Sascha
- Boc12 5 Juza Martin
- Boc12 6 Vanek Tomas
- Boc12 7 Dickmann Fabian
- Boc12 8 Napierski Kamil
- Tai12 1 Mihara Makihito
- Tai12 2 Yamamoto Akimasa
- Tai12 3 Tsang Derek
- Tai12 4 Soh Weng
- Tai12 5 Abe Motoki
- Tai12 6 Watanabe Yuuya
- Tai12 7 Murata Toshiaki
- Tai12 8 Lee ShiTian
- San12 1 Lytle Tyler
- San12 2 Woods Conley
- San12 3 Pratser Matthew
- San12 4 Corvese Harry
- San12 5 Duke Reid
- San12 6 Rasmussen Ben
- San12 7 DeSantos Joel
- San12 8 Thurber Matthew
- Cha12 1 Duke Reid
- Cha12 2 Keene Matt
- Cha12 3 Bolding Jon
- Cha12 4 Cox Patrick
- Cha12 5 Eason Brian
- Cha12 6 Chang Morgan
- Cha12 7 Thompson Gerry
- Cha12 8 Kelly Peter
- Lis12 1 Nørgaard Lasse
- Lis12 2 Watsfeldt Elias
- Lis12 3 Bjørnerud Sveinung
- Lis12 4 Calas David
- Lis12 5 Verhulst Johan
- Lis12 6 Floch Ivan
- Lis12 7 Coelho Helder
- Lis12 8 Carvalho Pedro
- Nag12 1 Kawaguchi Kyouhei
- Nag12 2 Aryabhima Rahman
- Nag12 3 Nagai Mamoru
- Nag12 4 Tsumura Kenji
- Nag12 5 Okita Yuuji
- Nag12 6 Satou Kazumasa
- Nag12 7 Shinohara Kazuaki
- Nag12 8 Murae Ryuzi
- Tor12 1 Chitiz Alon
- Tor12 2 Vance James
- Tor12 3 Morton Collin
- Tor12 4 Stern Jon
- Tor12 5 Pardee Sam
- Tor12 6 Majlaton Alex
- Tor12 7 Edel Willy
- Tor12 8 Jordan Dan
- Ind13 1 Fennell Chris
- Ind13 2 Scott-Vargas Luis
- Ind13 3 Hunt Matthias
- Ind13 4 Stark Ben
- Ind13 5 Yurchick Adam
- Ind13 6 Martell Tom
- Ind13 7 Lytle Tyler
- Ind13 8 Demars Brian
- Den13 1 Wijaya Vidianto
- Den13 2 Nass Matthew
- Den13 3 Pesch Ryan
- Den13 4 Ravitz Joshua
- Den13 5 Signorini Daniel
- Den13 6 Ohlschwager Andrew
- Den13 7 Cox Patrick
- Den13 8 Peck Donnie
- Sin13 1 Cantillana Andrew
- Sin13 2 Nakamura Jun''ya
- Dfw13 1 Hu Haibing
- Dfw13 2 Centauri Eric
- Dfw13 3 Manfield Seth
- Dfw13 4 Minard Darin
- Dfw13 5 Jensen William
- Dfw13 6 Gutierrez Marlon
- Dfw13 7 Stark Ben
- Dfw13 8 Reyes Carlos
- Vie13 1 Dolar Robin
- Vie13 2 Staciwa Marcin
- Vie13 3 Kaltenböck Niklas
- Vie13 4 Dezani Jeremy
- Vie13 5 Cifka Stanislav
- Vie13 6 Cecilia Manuel
- Vie13 7 Prinzell Johan
- Vie13 8 Polak-Rottmann Oliver
- Tor13 1 Manfield Seth
- Tor13 2 Jensen William
- Tor13 3 Ogreenc Greg
- Tor13 4 Kraupa Richard
- Tor13 5 Moir Ben
- Tor13 6 Lax Ari
- Tor13 7 Smith Robert
- Tor13 8 Magalhaes Edgar
- Abq13 1 Pardee Samuel
- Abq13 2 Black Sam
- Abq13 3 Nix Joseph
- Abq13 4 Hanson Andrew
- Abq13 5 Anderson Todd
- Abq13 6 Turtenwald Owen
- Abq13 7 Mackl Valentin
- Abq13 8 Rietzl Paul
- Was13 1 Wescoe Craig
- Was13 2 Boettcher Jared
- Was13 3 Tunison Drew
- Was13 4 Cuneo Andrew
- Was13 5 Turtenwald Owen
- Was13 6 McCluskie Ted
- Was13 7 Baylock Deshaun
- Was13 8 Black Sam
- Val13 1 Samuel Marti
- Val13 2 Aleksejs Laizans
- Val13 3 Ed Chalecki
- Val13 4 Dmitriy Butakov
- Val13 5 Andrii Gusiev
- Val13 6 Piero Lombardi
- Val13 7 Valentin Mackl
- Val13 8 Roberto Maestro
- Snt13 1 Valdivia Cristian
- Snt13 2 Soler Matias
- Snt13 3 Salvatto Luis
- Snt13 4 Navas Luis
- Snt13 5 Montenegro Carlos
- Snt13 6 DeNicola Nicolas
- Snt13 7 Melamed Jonathan
- Snt13 8 Barbosa Destri
- Ant13 1 Fabrizio Anteri
- Ant13 2 Daniel Fior
- Ant13 3 Thomas Hendriks
- Ant13 4 Nazar Sotiriadi
- Ant13 5 Herman Rúnarsson
- Ant13 6 Patrick Dickmann
- Ant13 7 Rasmus Björklund
- Ant13 8 Alexandre Bonneau
- Lou13 1 Black Sam
- Lou13 2 Stern Jon
- Lou13 3 Baeckstrom Andrew
- Lou13 4 Nelson Brad
- Lou13 5 Braun-Duin Brian
- Lou13 6 Anderson Todd
- Lou13 7 Jensen William
- Lou13 8 Sittner Alex
- HK13 1 Lu Xiaoshi
- HK13 2 YuSheng Lei
- HK13 3 Dunsford Denny
- HK13 4 Juza Martin
- HK13 5 Nakamura Shuhei
- HK13 6 Yukuhiro Ken
- HK13 7 Takahashi Yuuta
- HK13 8 Ng SoonLye
- Okc13 1 Lowry William
- Okc13 2 Dorsett Zach
- Okc13 3 Thomason Ty
- Okc13 4 Stout Rick
- Okc13 5 Mondo Pierre-Christophe
- Okc13 6 Penick John
- Okc13 7 Fulgium James
- Okc13 8 Brandstetter Ty
- Bri13 1 Cheung Justin
- Bri13 2 Wong Garry
- Bri13 3 Horig Wilfy
- Bri13 4 Harris Cameron
- Bri13 5 Robb Justin
- Bri13 6 Tudman Ben
- Bri13 7 Unwin Daniel
- Bri13 8 Khor WeeYuen
- Det13 1 Jansen Adam
- Det13 2 Majlaton Alex
- Det13 3 Stark Ben
- Det13 4 Duke Reid
- Det13 5 Freeman Marcelino
- Det13 6 Edel Willy
- Det13 7 McClain Josh
- Det13 8 Moir Ben
- Pra14 1 Wurmitzer Bernhard
- Pra14 2 Horvat Vjeran
- Pra14 3 Rutar Andrej
- Pra14 4 Moral Carlos
- Pra14 5 Dezani Jeremy
- Pra14 6 Giusti Emanuele
- Pra14 7 Dolar Robin
- Pra14 8 Kachapow Marcel
- Sac14 1 Mancuso Adam
- Sac14 2 Maliszewski Nathannael
- Sac14 3 Yam Philip
- Sac14 4 Pei Eric
- Sac14 5 Miller Ryan
- Sac14 6 Martell Tom
- Sac14 7 Lewis Aaron
- Sac14 8 Voellmer Andy
- Van14 1 Matt Sperling
- Van14 2 Adam Ruprecht
- Van14 3 Peter Sundholm
- Van14 4 Eugene Hwang
- Van14 5 Alexander Hayne
- Van14 6 Mike Vasovski
- Van14 7 Robert Gillespie
- Van14 8 Jon Stern
- KL14 1 Park Jun
- KL14 2 Young Ryan
- KL14 3 Kuptimitr Krissapas
- KL14 4 Yasooka Shouta
- KL14 5 Teo Jack
- KL14 6 Zainuddin Shamsul
- KL14 7 Li Fabien
- KL14 8 Khairul Mohd
- Par14 1 LeBriand Loïc
- Par14 2 Gilles Maxime
- Par14 3 Accart Jean-Mary
- Par14 4 Castelló Jóse
- Par14 5 Dominguez Javier
- Par14 6 Schönegger Philipp
- Par14 7 Böttcher Stefan
- Par14 8 DDR PV
- Mex14 1 Flores Mario
- Mex14 2 Daniel Hugo
- Mex14 3 Sanchez Emiliano
- Mex14 4 Freeman Marcelino
- Mex14 5 Ibarra Ignacio
- Mex14 6 Lalague Marc
- Mex14 7 Ange Miguel
- Mex14 8 Woloshyn Derek
- run;
- /*In the following table, every row is a GP.*/
- data Gaming.TournamentType;
- input TournamentID $ TournamentType $15.;
- datalines;
- Mal12 Limited
- Min12 Constructed
- Ana12 Constructed
- Mla12 Constructed
- Van12 Limited
- Col12 Constructed
- Gnt12 Constructed
- SP12 Limited
- Atl12 Constructed
- Yok12 Constructed
- Sha12 Limited
- Mos12 Limited
- CR12 Limited
- Bos12 Limited
- Phi12 Limited
- Auc12 Constructed
- Lyo12 Constructed
- Chi12 Constructed
- Boc12 Constructed
- Tai12 Limited
- San12 Constructed
- Cha12 Constructed
- Lis12 Limited
- Nag12 Constructed
- Tor12 Constructed
- Ind13 Limited
- Den13 Constructed
- Sin13 Limited
- Atl13 Constructed
- Syd13 Limited
- Bil13 Constructed
- Lon13 Limited
- Que13 Constructed
- Por13 Constructed
- Bei13 Limited
- Str13 Constructed
- Pit13 Limited
- SD13 Constructed
- Rio13 Constructed
- Ver13 Constructed
- Yok13 Limited
- Cha13 Limited
- Veg13 Limited
- Ban13 Limited
- Hou13 Limited
- Pra13 Limited
- Oak13 Limited
- Gua13 Constructed
- Got13 Limited
- War13 Constructed
- Cal13 Constructed
- Rim13 Limited
- KC13 Constructed
- Mia13 Constructed
- Shi13 Constructed
- Dfw13 Constructed
- Vie13 Constructed
- Tor13 Limited
- Abq13 Constructed
- Was13 Constructed
- Val13 Limited
- Snt13 Constructed
- Ant13 Constructed
- Lou13 Constructed
- HK13 Limited
- Okc13 Limited
- Bri13 Constructed
- Det13 Constructed
- Pra14 Constructed
- Sac14 Limited
- Van14 Constructed
- KL14 Limited
- Par14 Constructed
- Mex14 Limited
- run;
- /* The following procs alert me to data problems and inconsistencies of names, spellings, etc.*/
- proc sql;
- SELECT *
- FROM Gaming.playoffmatches AS G
- WHERE
- NOT EXISTS
- (select *
- from Gaming.RankingAfterSwiss AS R
- where G.FirstName1=R.FirstName AND G.LastName1=R.LastName AND G.TournamentID=R.TournamentID);
- quit;
- proc sql;
- SELECT *
- FROM Gaming.playoffmatches AS G
- WHERE
- NOT EXISTS
- (select *
- from Gaming.RankingAfterSwiss AS R
- where G.FirstName2=R.FirstName AND G.LastName2=R.LastName AND G.TournamentID=R.TournamentID);
- quit;
- proc sql;
- SELECT *
- FROM Gaming.playoffmatches AS G
- WHERE
- NOT EXISTS
- (select *
- from Gaming.RankingAfterSwiss AS R
- where G.FirstNameWinner=R.FirstName AND G.LastNameWinner=R.LastName AND G.TournamentID=R.TournamentID);
- quit;
- /*In the table created with the following proc, every row is a Top 8 match (but now with the player's rankings added in.*/
- proc sql;
- create table Gaming.MatchesAndRankings as
- SELECT G.*, R1.RankAfterSwiss AS RankOfPlayer1, R2.RankAfterSwiss AS RankOfPlayer2, R3.RankAfterSwiss AS RankOfWinner, TournamentType
- FROM Gaming.playoffmatches AS G, Gaming.rankingafterswiss AS R1, Gaming.rankingafterswiss AS R2, Gaming.rankingafterswiss AS R3, Gaming.tournamenttype AS T
- WHERE (G.FirstName1=R1.FirstName AND G.LastName1 = R1.LastName AND G.TournamentID=R1.TournamentID)
- AND (G.FirstName2=R2.FirstName AND G.LastName2=R2.LastName AND G.TournamentID=R2.TournamentID)
- AND (G.FirstNameWinner=R3.FirstName AND G.LastNameWinner=R3.LastName AND G.TournamentID=R3.TournamentID)
- AND (G.TournamentID=T.TournamentID);
- quit;
- proc sql;
- SELECT TournamentType, count(*) AS DrawFirstWon label='Total Matches Where The Player On The Draw Won'
- FROM Gaming.MatchesAndRankings
- WHERE RankOfWinner=max(RankOfPlayer1,RankOfPlayer2)
- group by TournamentType;
- quit;
- proc sql;
- SELECT TournamentType, count(*) AS PlayFirstWon label='Total Matches Where The Player On The Play Won'
- FROM Gaming.MatchesAndRankings
- WHERE RankOfWinner=min(RankOfPlayer1,RankOfPlayer2)
- group by TournamentType;
- quit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement