Skip to content

Instantly share code, notes, and snippets.

@KevinGreene
Last active January 3, 2016 17:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save KevinGreene/8493604 to your computer and use it in GitHub Desktop.
Save KevinGreene/8493604 to your computer and use it in GitHub Desktop.
NA LCS GraphGist
= League of Legends eSports Overview
:neo4j-version: 2.0.0
:author: Kevin Greene
:twitter: @SurrealAnalysis
In the game League of Legends, teams of five players compete against one another, with each person on a team having a unique position and champion each game.
Over the past two years, http://www.riotgames.com/[Riot Games] has created multiple leagues for competitive play, known as the League Championship Series, or LCS. As with most competitions, people are very interested in the various statistics, and below is a possible representation in Neo4j.
Unfortunately, because of the large amount of data, it exhausts the convenience of a GraphGist rather quickly, and is more suited to a full-fledged Neo4j database.
== Model
In my model of the LCS, there are a few different nodes that would get added regularly over time: Players, Teams, and Games.
Players are connected to Games via a node that models a hyperedge. This hyperedge (PlayerPerformance) also connects the players to the various constants they chose that specific game. In this example it is just Champions and Positions, but ultimately it could be extended to Items, Summoner Spells, Masteries, or any other variable from game-to-game.
The unlabeled edge between Team and Game would likely also be a hyperedge, containing information such as Win/Loss, Blue Side / Purple Side, and possibly early strategies (e.g. did they invade, did they swap lanes, etc.)
image::https://gist.github.com/KevinGreene/8493604/raw/217b14c8c128312bd816bd8be60d9918674f9260/LeagueOfLegends.png[]
== Setup
//hide
//setup
[source,cypher]
----
CREATE (aatrox:Champion { name: "Aatrox" })
CREATE (ahri:Champion { name: "Ahri" })
CREATE (akali:Champion { name: "Akali" })
CREATE (alistar:Champion { name: "Alistar" })
CREATE (amumu:Champion { name: "Amumu" })
CREATE (anivia:Champion { name: "Anivia" })
CREATE (annie:Champion { name: "Annie" })
CREATE (ashe:Champion { name: "Ashe" })
CREATE (blitzcrank:Champion { name: "Blitzcrank" })
CREATE (brand:Champion { name: "Brand" })
CREATE (caitlyn:Champion { name: "Caitlyn" })
CREATE (cassiopeia:Champion { name: "Cassiopeia" })
CREATE (chogath:Champion { name: "Cho'Gath" })
CREATE (corki:Champion { name: "Corki" })
CREATE (darius:Champion { name: "Darius" })
CREATE (diana:Champion { name: "Diana" })
CREATE (draven:Champion { name: "Draven" })
CREATE (drmundo:Champion { name: "Dr.Mundo" })
CREATE (elise:Champion { name: "Elise" })
CREATE (evelynn:Champion { name: "Evelynn" })
CREATE (ezreal:Champion { name: "Ezreal" })
CREATE (fiddlesticks:Champion { name: "Fiddlesticks" })
CREATE (fiora:Champion { name: "Fiora" })
CREATE (fizz:Champion { name: "Fizz" })
CREATE (galio:Champion { name: "Galio" })
CREATE (gangplank:Champion { name: "Gangplank" })
CREATE (garen:Champion { name: "Garen" })
CREATE (gragas:Champion { name: "Gragas" })
CREATE (graves:Champion { name: "Graves" })
CREATE (hecarim:Champion { name: "Hecarim" })
CREATE (heimerdinger:Champion { name: "Heimerdinger" })
CREATE (irelia:Champion { name: "Irelia" })
CREATE (janna:Champion { name: "Janna" })
CREATE (jarvaniv:Champion { name: "Jarvan IV" })
CREATE (jax:Champion { name: "Jax" })
CREATE (jayce:Champion { name: "Jayce" })
CREATE (jinx:Champion { name: "Jinx" })
CREATE (karma:Champion { name: "Karma" })
CREATE (karthus:Champion { name: "Karthus" })
CREATE (kassadin:Champion { name: "Kassadin" })
CREATE (katarina:Champion { name: "Katarina" })
CREATE (kayle:Champion { name: "Kayle" })
CREATE (kennen:Champion { name: "Kennen" })
CREATE (khazix:Champion { name: "Kha'Zix" })
CREATE (kogmaw:Champion { name: "Kog'Maw" })
CREATE (leblanc:Champion { name: "LeBlanc" })
CREATE (leesin:Champion { name: "Lee Sin" })
CREATE (leona:Champion { name: "Leona" })
CREATE (lissandra:Champion { name: "Lissandra" })
CREATE (lucian:Champion { name: "Lucian" })
CREATE (lulu:Champion { name: "Lulu" })
CREATE (lux:Champion { name: "Lux" })
CREATE (malphite:Champion { name: "Malphite" })
CREATE (malzahar:Champion { name: "Malzahar" })
CREATE (maokai:Champion { name: "Maokai" })
CREATE (masteryi:Champion { name: "Master Yi" })
CREATE (missfortune:Champion { name: "Miss Fortune" })
CREATE (mordekaiser:Champion { name: "Mordekaiser" })
CREATE (morgana:Champion { name: "Morgana" })
CREATE (nami:Champion { name: "Nami" })
CREATE (nasus:Champion { name: "Nasus" })
CREATE (nautilus:Champion { name: "Nautilus" })
CREATE (nidalee:Champion { name: "Nidalee" })
CREATE (nocturne:Champion { name: "Nocturne" })
CREATE (nunu:Champion { name: "Nunu" })
CREATE (olaf:Champion { name: "Olaf" })
CREATE (orianna:Champion { name: "Orianna" })
CREATE (pantheon:Champion { name: "Pantheon" })
CREATE (poppy:Champion { name: "Poppy" })
CREATE (quinn:Champion { name: "Quinn" })
CREATE (rammus:Champion { name: "Rammus" })
CREATE (renekton:Champion { name: "Renekton" })
CREATE (rengar:Champion { name: "Rengar" })
CREATE (riven:Champion { name: "Riven" })
CREATE (rumble:Champion { name: "Rumble" })
CREATE (ryze:Champion { name: "Ryze" })
CREATE (sejuani:Champion { name: "Sejuani" })
CREATE (shaco:Champion { name: "Shaco" })
CREATE (shen:Champion { name: "Shen" })
CREATE (shyvana:Champion { name: "Shyvana" })
CREATE (singed:Champion { name: "Singed" })
CREATE (sion:Champion { name: "Sion" })
CREATE (sivir:Champion { name: "Sivir" })
CREATE (skarner:Champion { name: "Skarner" })
CREATE (sona:Champion { name: "Sona" })
CREATE (soraka:Champion { name: "Soraka" })
CREATE (swain:Champion { name: "Swain" })
CREATE (syndra:Champion { name: "Syndra" })
CREATE (talon:Champion { name: "Talon" })
CREATE (taric:Champion { name: "Taric" })
CREATE (teemo:Champion { name: "Teemo" })
CREATE (thresh:Champion { name: "Thresh" })
CREATE (tristana:Champion { name: "Tristana" })
CREATE (trundle:Champion { name: "Trundle" })
CREATE (tryndamere:Champion { name: "Tryndamere" })
CREATE (twistedfate:Champion { name: "Twisted Fate" })
CREATE (twitch:Champion { name: "Twitch" })
CREATE (udyr:Champion { name: "Udyr" })
CREATE (urgot:Champion { name: "Urgot" })
CREATE (varus:Champion { name: "Varus" })
CREATE (vayne:Champion { name: "Vayne" })
CREATE (veigar:Champion { name: "Veigar" })
CREATE (vi:Champion { name: "Vi" })
CREATE (viktor:Champion { name: "Viktor" })
CREATE (vladimir:Champion { name: "Vladimir" })
CREATE (volibear:Champion { name: "Volibear" })
CREATE (warwick:Champion { name: "Warwick" })
CREATE (wukong:Champion { name: "Wukong" })
CREATE (xerath:Champion { name: "Xerath" })
CREATE (xinzhao:Champion { name: "Xin'Zhao" })
CREATE (yasuo:Champion { name: "Yasuo" })
CREATE (yorick:Champion { name: "Yorick" })
CREATE (zac:Champion { name: "Zac" })
CREATE (zed:Champion { name: "Zed" })
CREATE (ziggs:Champion { name: "Ziggs" })
CREATE (zilean:Champion { name: "Zilean" })
CREATE (zyra:Champion { name: "Zyra" })
CREATE (c9:Team {name: "Cloud 9 HyperX"})
CREATE (clg:Team {name: "Counter Logic Gaming"})
CREATE (curse:Team {name: "Curse"})
CREATE (eg:Team {name: "Evil Geniuses"})
CREATE (coast:Team {name: "Team Coast"})
CREATE (dig:Team {name: "Team Dignitas"})
CREATE (tsm:Team {name: "Team SoloMid"})
CREATE (xdg:Team {name: "XDG"})
CREATE (top:Position {name: "Top"})
CREATE (jun:Position {name: "Jungle"})
CREATE (mid:Position {name: "Mid"})
CREATE (adc:Position {name: "AD Carry"})
CREATE (sup:Position {name: "Support"})
CREATE (balls:Player { name: "Balls" })
CREATE (balls)-[:PLAYS_FOR]->(c9)
CREATE (meteos:Player { name: "Meteos" })
CREATE (meteos)-[:PLAYS_FOR]->(c9)
CREATE (hai:Player { name: "Hai" })
CREATE (hai)-[:PLAYS_FOR]->(c9)
CREATE (sneaky:Player { name: "Sneaky" })
CREATE (sneaky)-[:PLAYS_FOR]->(c9)
CREATE (lemonnation:Player { name: "LemonNation" })
CREATE (lemonnation)-[:PLAYS_FOR]->(c9)
CREATE (nien:Player { name: "Nien" })
CREATE (nien)-[:PLAYS_FOR]->(clg)
CREATE (link:Player { name: "Link" })
CREATE (link)-[:PLAYS_FOR]->(clg)
CREATE (hotshotgg:Player { name: "HotshotGG" })
CREATE (hotshotgg)-[:PLAYS_FOR]->(clg)
CREATE (doublelift:Player { name: "Doublelift" })
CREATE (doublelift)-[:PLAYS_FOR]->(clg)
CREATE (aphromoo:Player { name: "aphromoo" })
CREATE (aphromoo)-[:PLAYS_FOR]->(clg)
CREATE (quas:Player { name: "Quas" })
CREATE (quas)-[:PLAYS_FOR]->(curse)
CREATE (iwilldominate:Player { name: "IWillDominate" })
CREATE (iwilldominate)-[:PLAYS_FOR]->(curse)
CREATE (voyboy:Player { name: "Voyboy" })
CREATE (voyboy)-[:PLAYS_FOR]->(curse)
CREATE (cop:Player { name: "Cop" })
CREATE (cop)-[:PLAYS_FOR]->(curse)
CREATE (zekent:Player { name: "Zekent" })
CREATE (zekent)-[:PLAYS_FOR]->(curse)
CREATE (innox:Player { name: "InnoX" })
CREATE (innox)-[:PLAYS_FOR]->(eg)
CREATE (snoopeh:Player { name: "snoopeh" })
CREATE (snoopeh)-[:PLAYS_FOR]->(eg)
CREATE (pobelter:Player { name: "Pobelter" })
CREATE (pobelter)-[:PLAYS_FOR]->(eg)
CREATE (yellowpete:Player { name: "Yellowpete" })
CREATE (yellowpete)-[:PLAYS_FOR]->(eg)
CREATE (krepo:Player { name: "Krepo" })
CREATE (krepo)-[:PLAYS_FOR]->(eg)
CREATE (zionspartan:Player { name: "ZionSpartan" })
CREATE (zionspartan)-[:PLAYS_FOR]->(coast)
CREATE (nintendudex:Player { name: "NintendudeX" })
CREATE (nintendudex)-[:PLAYS_FOR]->(coast)
CREATE (shiptur:Player { name: "Shiptur" })
CREATE (shiptur)-[:PLAYS_FOR]->(coast)
CREATE (wizfujiin:Player { name: "WizFujiiN" })
CREATE (wizfujiin)-[:PLAYS_FOR]->(coast)
CREATE (daydreamin:Player { name: "Daydreamin" })
CREATE (daydreamin)-[:PLAYS_FOR]->(coast)
CREATE (cruzerbruzer:Player { name: "CruzerBruzer" })
CREATE (cruzerbruzer)-[:PLAYS_FOR]->(dig)
CREATE (crumbzz:Player { name: "Crumbzz" })
CREATE (crumbzz)-[:PLAYS_FOR]->(dig)
CREATE (scarra:Player { name: "scarra" })
CREATE (scarra)-[:PLAYS_FOR]->(dig)
CREATE (imaqtpie:Player { name: "Imaqtpie" })
CREATE (imaqtpie)-[:PLAYS_FOR]->(dig)
CREATE (kiwikid:Player { name: "KiWiKiD" })
CREATE (kiwikid)-[:PLAYS_FOR]->(dig)
CREATE (dyrus:Player { name: "Dyrus" })
CREATE (dyrus)-[:PLAYS_FOR]->(tsm)
CREATE (theoddone:Player { name: "TheOddOne" })
CREATE (theoddone)-[:PLAYS_FOR]->(tsm)
CREATE (bjergsen:Player { name: "Bjergsen" })
CREATE (bjergsen)-[:PLAYS_FOR]->(tsm)
CREATE (wildturtle:Player { name: "WildTurtle" })
CREATE (wildturtle)-[:PLAYS_FOR]->(tsm)
CREATE (xspecial:Player { name: "Xspecial" })
CREATE (xspecial)-[:PLAYS_FOR]->(tsm)
CREATE (benny:Player { name: "Benny" })
CREATE (benny)-[:PLAYS_FOR]->(xdg)
CREATE (zuna:Player { name: "Zuna" })
CREATE (zuna)-[:PLAYS_FOR]->(xdg)
CREATE (mancloud:Player { name: "mancloud" })
CREATE (mancloud)-[:PLAYS_FOR]->(xdg)
CREATE (xmithie:Player { name: "Xmithie" })
CREATE (xmithie)-[:PLAYS_FOR]->(xdg)
CREATE (bloodwater:Player { name: "BloodWater" })
CREATE (bloodwater)-[:PLAYS_FOR]->(xdg)
CREATE (win:Outcome { name: "Win" })
CREATE (loss:Outcome { name: "Loss" })
CREATE (W1D1G1:Game { name: "W1D1G1" })
CREATE (ballsW1D1G1:PlayerPerformance { name: "balls - W1D1G1" })
CREATE (balls)-[:PERFORMED]->(ballsW1D1G1)
CREATE (ballsW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (ballsW1D1G1)-[:WAS_CHAMPION]->(renekton)
CREATE (ballsW1D1G1)-[:IN_POSITION]->(top)
CREATE (ballsW1D1G1)-[:HAD_OUTCOME]->(win)
CREATE (meteosW1D1G1:PlayerPerformance { name: "meteos - W1D1G1" })
CREATE (meteos)-[:PERFORMED]->(meteosW1D1G1)
CREATE (meteosW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (meteosW1D1G1)-[:WAS_CHAMPION]->(vi)
CREATE (meteosW1D1G1)-[:IN_POSITION]->(jun)
CREATE (meteosW1D1G1)-[:HAD_OUTCOME]->(win)
CREATE (haiW1D1G1:PlayerPerformance { name: "hai - W1D1G1" })
CREATE (hai)-[:PERFORMED]->(haiW1D1G1)
CREATE (haiW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (haiW1D1G1)-[:WAS_CHAMPION]->(teemo)
CREATE (haiW1D1G1)-[:IN_POSITION]->(mid)
CREATE (haiW1D1G1)-[:HAD_OUTCOME]->(win)
CREATE (sneakyW1D1G1:PlayerPerformance { name: "sneaky - W1D1G1" })
CREATE (sneaky)-[:PERFORMED]->(sneakyW1D1G1)
CREATE (sneakyW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (sneakyW1D1G1)-[:WAS_CHAMPION]->(caitlyn)
CREATE (sneakyW1D1G1)-[:IN_POSITION]->(adc)
CREATE (sneakyW1D1G1)-[:HAD_OUTCOME]->(win)
CREATE (lemonnationW1D1G1:PlayerPerformance { name: "lemonnation - W1D1G1" })
CREATE (lemonnation)-[:PERFORMED]->(lemonnationW1D1G1)
CREATE (lemonnationW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (lemonnationW1D1G1)-[:WAS_CHAMPION]->(thresh)
CREATE (lemonnationW1D1G1)-[:IN_POSITION]->(sup)
CREATE (lemonnationW1D1G1)-[:HAD_OUTCOME]->(win)
CREATE (dyrusW1D1G1:PlayerPerformance { name: "dyrus - W1D1G1" })
CREATE (dyrus)-[:PERFORMED]->(dyrusW1D1G1)
CREATE (dyrusW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (dyrusW1D1G1)-[:WAS_CHAMPION]->(nasus)
CREATE (dyrusW1D1G1)-[:IN_POSITION]->(top)
CREATE (dyrusW1D1G1)-[:HAD_OUTCOME]->(loss)
CREATE (theoddoneW1D1G1:PlayerPerformance { name: "theoddone - W1D1G1" })
CREATE (theoddone)-[:PERFORMED]->(theoddoneW1D1G1)
CREATE (theoddoneW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (theoddoneW1D1G1)-[:WAS_CHAMPION]->(nunu)
CREATE (theoddoneW1D1G1)-[:IN_POSITION]->(jun)
CREATE (theoddoneW1D1G1)-[:HAD_OUTCOME]->(loss)
CREATE (bjergsenW1D1G1:PlayerPerformance { name: "bjergsen - W1D1G1" })
CREATE (bjergsen)-[:PERFORMED]->(bjergsenW1D1G1)
CREATE (bjergsenW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (bjergsenW1D1G1)-[:WAS_CHAMPION]->(gragas)
CREATE (bjergsenW1D1G1)-[:IN_POSITION]->(mid)
CREATE (bjergsenW1D1G1)-[:HAD_OUTCOME]->(loss)
CREATE (wildturtleW1D1G1:PlayerPerformance { name: "wildturtle - W1D1G1" })
CREATE (wildturtle)-[:PERFORMED]->(wildturtleW1D1G1)
CREATE (wildturtleW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (wildturtleW1D1G1)-[:WAS_CHAMPION]->(lucian)
CREATE (wildturtleW1D1G1)-[:IN_POSITION]->(adc)
CREATE (wildturtleW1D1G1)-[:HAD_OUTCOME]->(loss)
CREATE (xspecialW1D1G1:PlayerPerformance { name: "xspecial - W1D1G1" })
CREATE (xspecial)-[:PERFORMED]->(xspecialW1D1G1)
CREATE (xspecialW1D1G1)-[:PLAYED_IN]->(W1D1G1)
CREATE (xspecialW1D1G1)-[:WAS_CHAMPION]->(annie)
CREATE (xspecialW1D1G1)-[:IN_POSITION]->(sup)
CREATE (xspecialW1D1G1)-[:HAD_OUTCOME]->(loss)
CREATE (W1D1G2:Game { name: "W1D1G2" })
CREATE (innoxW1D1G2:PlayerPerformance { name: "innox - W1D1G2" })
CREATE (innox)-[:PERFORMED]->(innoxW1D1G2)
CREATE (innoxW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (innoxW1D1G2)-[:WAS_CHAMPION]->(yasuo)
CREATE (innoxW1D1G2)-[:IN_POSITION]->(top)
CREATE (innoxW1D1G2)-[:HAD_OUTCOME]->(loss)
CREATE (snoopehW1D1G2:PlayerPerformance { name: "snoopeh - W1D1G2" })
CREATE (snoopeh)-[:PERFORMED]->(snoopehW1D1G2)
CREATE (snoopehW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (snoopehW1D1G2)-[:WAS_CHAMPION]->(leesin)
CREATE (snoopehW1D1G2)-[:IN_POSITION]->(jun)
CREATE (snoopehW1D1G2)-[:HAD_OUTCOME]->(loss)
CREATE (pobelterW1D1G2:PlayerPerformance { name: "pobelter - W1D1G2" })
CREATE (pobelter)-[:PERFORMED]->(pobelterW1D1G2)
CREATE (pobelterW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (pobelterW1D1G2)-[:WAS_CHAMPION]->(kassadin)
CREATE (pobelterW1D1G2)-[:IN_POSITION]->(mid)
CREATE (pobelterW1D1G2)-[:HAD_OUTCOME]->(loss)
CREATE (yellowpeteW1D1G2:PlayerPerformance { name: "yellowpete - W1D1G2" })
CREATE (yellowpete)-[:PERFORMED]->(yellowpeteW1D1G2)
CREATE (yellowpeteW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (yellowpeteW1D1G2)-[:WAS_CHAMPION]->(lucian)
CREATE (yellowpeteW1D1G2)-[:IN_POSITION]->(adc)
CREATE (yellowpeteW1D1G2)-[:HAD_OUTCOME]->(loss)
CREATE (krepoW1D1G2:PlayerPerformance { name: "krepo - W1D1G2" })
CREATE (krepo)-[:PERFORMED]->(krepoW1D1G2)
CREATE (krepoW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (krepoW1D1G2)-[:WAS_CHAMPION]->(lulu)
CREATE (krepoW1D1G2)-[:IN_POSITION]->(sup)
CREATE (krepoW1D1G2)-[:HAD_OUTCOME]->(loss)
CREATE (bennyW1D1G2:PlayerPerformance { name: "benny - W1D1G2" })
CREATE (benny)-[:PERFORMED]->(bennyW1D1G2)
CREATE (bennyW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (bennyW1D1G2)-[:WAS_CHAMPION]->(renekton)
CREATE (bennyW1D1G2)-[:IN_POSITION]->(top)
CREATE (bennyW1D1G2)-[:HAD_OUTCOME]->(win)
CREATE (zunaW1D1G2:PlayerPerformance { name: "zuna - W1D1G2" })
CREATE (zuna)-[:PERFORMED]->(zunaW1D1G2)
CREATE (zunaW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (zunaW1D1G2)-[:WAS_CHAMPION]->(olaf)
CREATE (zunaW1D1G2)-[:IN_POSITION]->(jun)
CREATE (zunaW1D1G2)-[:HAD_OUTCOME]->(win)
CREATE (mancloudW1D1G2:PlayerPerformance { name: "mancloud - W1D1G2" })
CREATE (mancloud)-[:PERFORMED]->(mancloudW1D1G2)
CREATE (mancloudW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (mancloudW1D1G2)-[:WAS_CHAMPION]->(kayle)
CREATE (mancloudW1D1G2)-[:IN_POSITION]->(mid)
CREATE (mancloudW1D1G2)-[:HAD_OUTCOME]->(win)
CREATE (xmithieW1D1G2:PlayerPerformance { name: "xmithie - W1D1G2" })
CREATE (xmithie)-[:PERFORMED]->(xmithieW1D1G2)
CREATE (xmithieW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (xmithieW1D1G2)-[:WAS_CHAMPION]->(jinx)
CREATE (xmithieW1D1G2)-[:IN_POSITION]->(adc)
CREATE (xmithieW1D1G2)-[:HAD_OUTCOME]->(win)
CREATE (bloodwaterW1D1G2:PlayerPerformance { name: "bloodwater - W1D1G2" })
CREATE (bloodwater)-[:PERFORMED]->(bloodwaterW1D1G2)
CREATE (bloodwaterW1D1G2)-[:PLAYED_IN]->(W1D1G2)
CREATE (bloodwaterW1D1G2)-[:WAS_CHAMPION]->(thresh)
CREATE (bloodwaterW1D1G2)-[:IN_POSITION]->(sup)
CREATE (bloodwaterW1D1G2)-[:HAD_OUTCOME]->(win)
CREATE (W1D1G3:Game { name: "W1D1G3" })
CREATE (quasW1D1G3:PlayerPerformance { name: "quas - W1D1G3" })
CREATE (quas)-[:PERFORMED]->(quasW1D1G3)
CREATE (quasW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (quasW1D1G3)-[:WAS_CHAMPION]->(drmundo)
CREATE (quasW1D1G3)-[:IN_POSITION]->(top)
CREATE (quasW1D1G3)-[:HAD_OUTCOME]->(win)
CREATE (iwilldominateW1D1G3:PlayerPerformance { name: "iwilldominate - W1D1G3" })
CREATE (iwilldominate)-[:PERFORMED]->(iwilldominateW1D1G3)
CREATE (iwilldominateW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (iwilldominateW1D1G3)-[:WAS_CHAMPION]->(elise)
CREATE (iwilldominateW1D1G3)-[:IN_POSITION]->(jun)
CREATE (iwilldominateW1D1G3)-[:HAD_OUTCOME]->(win)
CREATE (voyboyW1D1G3:PlayerPerformance { name: "voyboy - W1D1G3" })
CREATE (voyboy)-[:PERFORMED]->(voyboyW1D1G3)
CREATE (voyboyW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (voyboyW1D1G3)-[:WAS_CHAMPION]->(yasuo)
CREATE (voyboyW1D1G3)-[:IN_POSITION]->(mid)
CREATE (voyboyW1D1G3)-[:HAD_OUTCOME]->(win)
CREATE (copW1D1G3:PlayerPerformance { name: "cop - W1D1G3" })
CREATE (cop)-[:PERFORMED]->(copW1D1G3)
CREATE (copW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (copW1D1G3)-[:WAS_CHAMPION]->(caitlyn)
CREATE (copW1D1G3)-[:IN_POSITION]->(adc)
CREATE (copW1D1G3)-[:HAD_OUTCOME]->(win)
CREATE (zekentW1D1G3:PlayerPerformance { name: "zekent - W1D1G3" })
CREATE (zekent)-[:PERFORMED]->(zekentW1D1G3)
CREATE (zekentW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (zekentW1D1G3)-[:WAS_CHAMPION]->(lulu)
CREATE (zekentW1D1G3)-[:IN_POSITION]->(sup)
CREATE (zekentW1D1G3)-[:HAD_OUTCOME]->(win)
CREATE (zionspartanW1D1G3:PlayerPerformance { name: "zionspartan - W1D1G3" })
CREATE (zionspartan)-[:PERFORMED]->(zionspartanW1D1G3)
CREATE (zionspartanW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (zionspartanW1D1G3)-[:WAS_CHAMPION]->(trundle)
CREATE (zionspartanW1D1G3)-[:IN_POSITION]->(top)
CREATE (zionspartanW1D1G3)-[:HAD_OUTCOME]->(loss)
CREATE (nintendudexW1D1G3:PlayerPerformance { name: "nintendudex - W1D1G3" })
CREATE (nintendudex)-[:PERFORMED]->(nintendudexW1D1G3)
CREATE (nintendudexW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (nintendudexW1D1G3)-[:WAS_CHAMPION]->(shyvana)
CREATE (nintendudexW1D1G3)-[:IN_POSITION]->(jun)
CREATE (nintendudexW1D1G3)-[:HAD_OUTCOME]->(loss)
CREATE (shiphturW1D1G3:PlayerPerformance { name: "shiphtur - W1D1G3" })
CREATE (shiphtur)-[:PERFORMED]->(shiphturW1D1G3)
CREATE (shiphturW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (shiphturW1D1G3)-[:WAS_CHAMPION]->(nidalee)
CREATE (shiphturW1D1G3)-[:IN_POSITION]->(mid)
CREATE (shiphturW1D1G3)-[:HAD_OUTCOME]->(loss)
CREATE (wizfujiinW1D1G3:PlayerPerformance { name: "wizfujiin - W1D1G3" })
CREATE (wizfujiin)-[:PERFORMED]->(wizfujiinW1D1G3)
CREATE (wizfujiinW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (wizfujiinW1D1G3)-[:WAS_CHAMPION]->(varus)
CREATE (wizfujiinW1D1G3)-[:IN_POSITION]->(adc)
CREATE (wizfujiinW1D1G3)-[:HAD_OUTCOME]->(loss)
CREATE (daydreaminW1D1G3:PlayerPerformance { name: "daydreamin - W1D1G3" })
CREATE (daydreamin)-[:PERFORMED]->(daydreaminW1D1G3)
CREATE (daydreaminW1D1G3)-[:PLAYED_IN]->(W1D1G3)
CREATE (daydreaminW1D1G3)-[:WAS_CHAMPION]->(annie)
CREATE (daydreaminW1D1G3)-[:IN_POSITION]->(sup)
CREATE (daydreaminW1D1G3)-[:HAD_OUTCOME]->(loss)
CREATE (W1D1G4:Game { name: "W1D1G4" })
CREATE (bennyW1D1G4:PlayerPerformance { name: "benny - W1D1G4" })
CREATE (benny)-[:PERFORMED]->(bennyW1D1G4)
CREATE (bennyW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (bennyW1D1G4)-[:WAS_CHAMPION]->(warwick)
CREATE (bennyW1D1G4)-[:IN_POSITION]->(top)
CREATE (bennyW1D1G4)-[:HAD_OUTCOME]->(loss)
CREATE (zunaW1D1G4:PlayerPerformance { name: "zuna - W1D1G4" })
CREATE (zuna)-[:PERFORMED]->(zunaW1D1G4)
CREATE (zunaW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (zunaW1D1G4)-[:WAS_CHAMPION]->(elise)
CREATE (zunaW1D1G4)-[:IN_POSITION]->(jun)
CREATE (zunaW1D1G4)-[:HAD_OUTCOME]->(loss)
CREATE (mancloudW1D1G4:PlayerPerformance { name: "mancloud - W1D1G4" })
CREATE (mancloud)-[:PERFORMED]->(mancloudW1D1G4)
CREATE (mancloudW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (mancloudW1D1G4)-[:WAS_CHAMPION]->(gragas)
CREATE (mancloudW1D1G4)-[:IN_POSITION]->(mid)
CREATE (mancloudW1D1G4)-[:HAD_OUTCOME]->(loss)
CREATE (xmithieW1D1G4:PlayerPerformance { name: "xmithie - W1D1G4" })
CREATE (xmithie)-[:PERFORMED]->(xmithieW1D1G4)
CREATE (xmithieW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (xmithieW1D1G4)-[:WAS_CHAMPION]->(lucian)
CREATE (xmithieW1D1G4)-[:IN_POSITION]->(adc)
CREATE (xmithieW1D1G4)-[:HAD_OUTCOME]->(loss)
CREATE (bloodwaterW1D1G4:PlayerPerformance { name: "bloodwater - W1D1G4" })
CREATE (bloodwater)-[:PERFORMED]->(bloodwaterW1D1G4)
CREATE (bloodwaterW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (bloodwaterW1D1G4)-[:WAS_CHAMPION]->(annie)
CREATE (bloodwaterW1D1G4)-[:IN_POSITION]->(sup)
CREATE (bloodwaterW1D1G4)-[:HAD_OUTCOME]->(loss)
CREATE (ballsW1D1G4:PlayerPerformance { name: "balls - W1D1G4" })
CREATE (balls)-[:PERFORMED]->(ballsW1D1G4)
CREATE (ballsW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (ballsW1D1G4)-[:WAS_CHAMPION]->(shyvana)
CREATE (ballsW1D1G4)-[:IN_POSITION]->(top)
CREATE (ballsW1D1G4)-[:HAD_OUTCOME]->(win)
CREATE (meteosW1D1G4:PlayerPerformance { name: "meteos - W1D1G4" })
CREATE (meteos)-[:PERFORMED]->(meteosW1D1G4)
CREATE (meteosW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (meteosW1D1G4)-[:WAS_CHAMPION]->(vi)
CREATE (meteosW1D1G4)-[:IN_POSITION]->(jun)
CREATE (meteosW1D1G4)-[:HAD_OUTCOME]->(win)
CREATE (haiW1D1G4:PlayerPerformance { name: "hai - W1D1G4" })
CREATE (hai)-[:PERFORMED]->(haiW1D1G4)
CREATE (haiW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (haiW1D1G4)-[:WAS_CHAMPION]->(yasuo)
CREATE (haiW1D1G4)-[:IN_POSITION]->(mid)
CREATE (haiW1D1G4)-[:HAD_OUTCOME]->(win)
CREATE (sneakyW1D1G4:PlayerPerformance { name: "sneaky - W1D1G4" })
CREATE (sneaky)-[:PERFORMED]->(sneakyW1D1G4)
CREATE (sneakyW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (sneakyW1D1G4)-[:WAS_CHAMPION]->(caitlyn)
CREATE (sneakyW1D1G4)-[:IN_POSITION]->(adc)
CREATE (sneakyW1D1G4)-[:HAD_OUTCOME]->(win)
CREATE (lemonnationW1D1G4:PlayerPerformance { name: "lemonnation - W1D1G4" })
CREATE (lemonnation)-[:PERFORMED]->(lemonnationW1D1G4)
CREATE (lemonnationW1D1G4)-[:PLAYED_IN]->(W1D1G4)
CREATE (lemonnationW1D1G4)-[:WAS_CHAMPION]->(thresh)
CREATE (lemonnationW1D1G4)-[:IN_POSITION]->(sup)
CREATE (lemonnationW1D1G4)-[:HAD_OUTCOME]->(win)
CREATE (W1D1G5:Game { name: "W1D1G5" })
CREATE (dyrusW1D1G5:PlayerPerformance { name: "dyrus - W1D1G5" })
CREATE (dyrus)-[:PERFORMED]->(dyrusW1D1G5)
CREATE (dyrusW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (dyrusW1D1G5)-[:WAS_CHAMPION]->(shyvana)
CREATE (dyrusW1D1G5)-[:IN_POSITION]->(top)
CREATE (dyrusW1D1G5)-[:HAD_OUTCOME]->(win)
CREATE (theoddoneW1D1G5:PlayerPerformance { name: "theoddone - W1D1G5" })
CREATE (theoddone)-[:PERFORMED]->(theoddoneW1D1G5)
CREATE (theoddoneW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (theoddoneW1D1G5)-[:WAS_CHAMPION]->(olaf)
CREATE (theoddoneW1D1G5)-[:IN_POSITION]->(jun)
CREATE (theoddoneW1D1G5)-[:HAD_OUTCOME]->(win)
CREATE (bjergsenW1D1G5:PlayerPerformance { name: "bjergsen - W1D1G5" })
CREATE (bjergsen)-[:PERFORMED]->(bjergsenW1D1G5)
CREATE (bjergsenW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (bjergsenW1D1G5)-[:WAS_CHAMPION]->(zed)
CREATE (bjergsenW1D1G5)-[:IN_POSITION]->(mid)
CREATE (bjergsenW1D1G5)-[:HAD_OUTCOME]->(win)
CREATE (wildturtleW1D1G5:PlayerPerformance { name: "wildturtle - W1D1G5" })
CREATE (wildturtle)-[:PERFORMED]->(wildturtleW1D1G5)
CREATE (wildturtleW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (wildturtleW1D1G5)-[:WAS_CHAMPION]->(sivir)
CREATE (wildturtleW1D1G5)-[:IN_POSITION]->(adc)
CREATE (wildturtleW1D1G5)-[:HAD_OUTCOME]->(win)
CREATE (xspecialW1D1G5:PlayerPerformance { name: "xspecial - W1D1G5" })
CREATE (xspecial)-[:PERFORMED]->(xspecialW1D1G5)
CREATE (xspecialW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (xspecialW1D1G5)-[:WAS_CHAMPION]->(leona)
CREATE (xspecialW1D1G5)-[:IN_POSITION]->(sup)
CREATE (xspecialW1D1G5)-[:HAD_OUTCOME]->(win)
CREATE (innoxW1D1G5:PlayerPerformance { name: "innox - W1D1G5" })
CREATE (innox)-[:PERFORMED]->(innoxW1D1G5)
CREATE (innoxW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (innoxW1D1G5)-[:WAS_CHAMPION]->(leesin)
CREATE (innoxW1D1G5)-[:IN_POSITION]->(top)
CREATE (innoxW1D1G5)-[:HAD_OUTCOME]->(loss)
CREATE (snoopehW1D1G5:PlayerPerformance { name: "snoopeh - W1D1G5" })
CREATE (snoopeh)-[:PERFORMED]->(snoopehW1D1G5)
CREATE (snoopehW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (snoopehW1D1G5)-[:WAS_CHAMPION]->(vi)
CREATE (snoopehW1D1G5)-[:IN_POSITION]->(jun)
CREATE (snoopehW1D1G5)-[:HAD_OUTCOME]->(loss)
CREATE (pobelterW1D1G5:PlayerPerformance { name: "pobelter - W1D1G5" })
CREATE (pobelter)-[:PERFORMED]->(pobelterW1D1G5)
CREATE (pobelterW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (pobelterW1D1G5)-[:WAS_CHAMPION]->(ziggs)
CREATE (pobelterW1D1G5)-[:IN_POSITION]->(mid)
CREATE (pobelterW1D1G5)-[:HAD_OUTCOME]->(loss)
CREATE (yellowpeteW1D1G5:PlayerPerformance { name: "yellowpete - W1D1G5" })
CREATE (yellowpete)-[:PERFORMED]->(yellowpeteW1D1G5)
CREATE (yellowpeteW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (yellowpeteW1D1G5)-[:WAS_CHAMPION]->(caitlyn)
CREATE (yellowpeteW1D1G5)-[:IN_POSITION]->(adc)
CREATE (yellowpeteW1D1G5)-[:HAD_OUTCOME]->(loss)
CREATE (krepoW1D1G5:PlayerPerformance { name: "krepo - W1D1G5" })
CREATE (krepo)-[:PERFORMED]->(krepoW1D1G5)
CREATE (krepoW1D1G5)-[:PLAYED_IN]->(W1D1G5)
CREATE (krepoW1D1G5)-[:WAS_CHAMPION]->(thresh)
CREATE (krepoW1D1G5)-[:IN_POSITION]->(sup)
CREATE (krepoW1D1G5)-[:HAD_OUTCOME]->(loss)
CREATE (W1D1G6:Game { name: "W1D1G6" })
CREATE (nienW1D1G6:PlayerPerformance { name: "nien - W1D1G6" })
CREATE (nien)-[:PERFORMED]->(nienW1D1G6)
CREATE (nienW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (nienW1D1G6)-[:WAS_CHAMPION]->(zac)
CREATE (nienW1D1G6)-[:IN_POSITION]->(top)
CREATE (nienW1D1G6)-[:HAD_OUTCOME]->(win)
CREATE (linkW1D1G6:PlayerPerformance { name: "link - W1D1G6" })
CREATE (link)-[:PERFORMED]->(linkW1D1G6)
CREATE (linkW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (linkW1D1G6)-[:WAS_CHAMPION]->(khazix)
CREATE (linkW1D1G6)-[:IN_POSITION]->(jun)
CREATE (linkW1D1G6)-[:HAD_OUTCOME]->(win)
CREATE (hotshotggW1D1G6:PlayerPerformance { name: "hotshotgg - W1D1G6" })
CREATE (hotshotgg)-[:PERFORMED]->(hotshotggW1D1G6)
CREATE (hotshotggW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (hotshotggW1D1G6)-[:WAS_CHAMPION]->(nidalee)
CREATE (hotshotggW1D1G6)-[:IN_POSITION]->(mid)
CREATE (hotshotggW1D1G6)-[:HAD_OUTCOME]->(win)
CREATE (doubleliftW1D1G6:PlayerPerformance { name: "doublelift - W1D1G6" })
CREATE (doublelift)-[:PERFORMED]->(doubleliftW1D1G6)
CREATE (doubleliftW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (doubleliftW1D1G6)-[:WAS_CHAMPION]->(jinx)
CREATE (doubleliftW1D1G6)-[:IN_POSITION]->(adc)
CREATE (doubleliftW1D1G6)-[:HAD_OUTCOME]->(win)
CREATE (aphromooW1D1G6:PlayerPerformance { name: "aphromoo - W1D1G6" })
CREATE (aphromoo)-[:PERFORMED]->(aphromooW1D1G6)
CREATE (aphromooW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (aphromooW1D1G6)-[:WAS_CHAMPION]->(annie)
CREATE (aphromooW1D1G6)-[:IN_POSITION]->(sup)
CREATE (aphromooW1D1G6)-[:HAD_OUTCOME]->(win)
CREATE (cruzerbruzerW1D1G6:PlayerPerformance { name: "cruzerbruzer - W1D1G6" })
CREATE (cruzerbruzer)-[:PERFORMED]->(cruzerbruzerW1D1G6)
CREATE (cruzerbruzerW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (cruzerbruzerW1D1G6)-[:WAS_CHAMPION]->(shyvana)
CREATE (cruzerbruzerW1D1G6)-[:IN_POSITION]->(top)
CREATE (cruzerbruzerW1D1G6)-[:HAD_OUTCOME]->(loss)
CREATE (crumbzzW1D1G6:PlayerPerformance { name: "crumbzz - W1D1G6" })
CREATE (crumbzz)-[:PERFORMED]->(crumbzzW1D1G6)
CREATE (crumbzzW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (crumbzzW1D1G6)-[:WAS_CHAMPION]->(elise)
CREATE (crumbzzW1D1G6)-[:IN_POSITION]->(jun)
CREATE (crumbzzW1D1G6)-[:HAD_OUTCOME]->(loss)
CREATE (scarraW1D1G6:PlayerPerformance { name: "scarra - W1D1G6" })
CREATE (scarra)-[:PERFORMED]->(scarraW1D1G6)
CREATE (scarraW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (scarraW1D1G6)-[:WAS_CHAMPION]->(katarina)
CREATE (scarraW1D1G6)-[:IN_POSITION]->(mid)
CREATE (scarraW1D1G6)-[:HAD_OUTCOME]->(loss)
CREATE (imaqtpieW1D1G6:PlayerPerformance { name: "imaqtpie - W1D1G6" })
CREATE (imaqtpie)-[:PERFORMED]->(imaqtpieW1D1G6)
CREATE (imaqtpieW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (imaqtpieW1D1G6)-[:WAS_CHAMPION]->(lucian)
CREATE (imaqtpieW1D1G6)-[:IN_POSITION]->(adc)
CREATE (imaqtpieW1D1G6)-[:HAD_OUTCOME]->(loss)
CREATE (kiwikidW1D1G6:PlayerPerformance { name: "kiwikid - W1D1G6" })
CREATE (kiwikid)-[:PERFORMED]->(kiwikidW1D1G6)
CREATE (kiwikidW1D1G6)-[:PLAYED_IN]->(W1D1G6)
CREATE (kiwikidW1D1G6)-[:WAS_CHAMPION]->(leona)
CREATE (kiwikidW1D1G6)-[:IN_POSITION]->(sup)
CREATE (kiwikidW1D1G6)-[:HAD_OUTCOME]->(loss);
----
//hide
//setup
[source,cypher]
----
MATCH (aatrox:Champion { name: "Aatrox" })
MATCH (ahri:Champion { name: "Ahri" })
MATCH (akali:Champion { name: "Akali" })
MATCH (alistar:Champion { name: "Alistar" })
MATCH (amumu:Champion { name: "Amumu" })
MATCH (anivia:Champion { name: "Anivia" })
MATCH (annie:Champion { name: "Annie" })
MATCH (ashe:Champion { name: "Ashe" })
MATCH (blitzcrank:Champion { name: "Blitzcrank" })
MATCH (brand:Champion { name: "Brand" })
MATCH (caitlyn:Champion { name: "Caitlyn" })
MATCH (cassiopeia:Champion { name: "Cassiopeia" })
MATCH (chogath:Champion { name: "Cho'Gath" })
MATCH (corki:Champion { name: "Corki" })
MATCH (darius:Champion { name: "Darius" })
MATCH (diana:Champion { name: "Diana" })
MATCH (draven:Champion { name: "Draven" })
MATCH (drmundo:Champion { name: "Dr.Mundo" })
MATCH (elise:Champion { name: "Elise" })
MATCH (evelynn:Champion { name: "Evelynn" })
MATCH (ezreal:Champion { name: "Ezreal" })
MATCH (fiddlesticks:Champion { name: "Fiddlesticks" })
MATCH (fiora:Champion { name: "Fiora" })
MATCH (fizz:Champion { name: "Fizz" })
MATCH (galio:Champion { name: "Galio" })
MATCH (gangplank:Champion { name: "Gangplank" })
MATCH (garen:Champion { name: "Garen" })
MATCH (gragas:Champion { name: "Gragas" })
MATCH (graves:Champion { name: "Graves" })
MATCH (hecarim:Champion { name: "Hecarim" })
MATCH (heimerdinger:Champion { name: "Heimerdinger" })
MATCH (irelia:Champion { name: "Irelia" })
MATCH (janna:Champion { name: "Janna" })
MATCH (jarvaniv:Champion { name: "Jarvan IV" })
MATCH (jax:Champion { name: "Jax" })
MATCH (jayce:Champion { name: "Jayce" })
MATCH (jinx:Champion { name: "Jinx" })
MATCH (karma:Champion { name: "Karma" })
MATCH (karthus:Champion { name: "Karthus" })
MATCH (kassadin:Champion { name: "Kassadin" })
MATCH (katarina:Champion { name: "Katarina" })
MATCH (kayle:Champion { name: "Kayle" })
MATCH (kennen:Champion { name: "Kennen" })
MATCH (khazix:Champion { name: "Kha'Zix" })
MATCH (kogmaw:Champion { name: "Kog'Maw" })
MATCH (leblanc:Champion { name: "LeBlanc" })
MATCH (leesin:Champion { name: "Lee Sin" })
MATCH (leona:Champion { name: "Leona" })
MATCH (lissandra:Champion { name: "Lissandra" })
MATCH (lucian:Champion { name: "Lucian" })
MATCH (lulu:Champion { name: "Lulu" })
MATCH (lux:Champion { name: "Lux" })
MATCH (malphite:Champion { name: "Malphite" })
MATCH (malzahar:Champion { name: "Malzahar" })
MATCH (maokai:Champion { name: "Maokai" })
MATCH (masteryi:Champion { name: "Master Yi" })
MATCH (missfortune:Champion { name: "Miss Fortune" })
MATCH (mordekaiser:Champion { name: "Mordekaiser" })
MATCH (morgana:Champion { name: "Morgana" })
MATCH (nami:Champion { name: "Nami" })
MATCH (nasus:Champion { name: "Nasus" })
MATCH (nautilus:Champion { name: "Nautilus" })
MATCH (nidalee:Champion { name: "Nidalee" })
MATCH (nocturne:Champion { name: "Nocturne" })
MATCH (nunu:Champion { name: "Nunu" })
MATCH (olaf:Champion { name: "Olaf" })
MATCH (orianna:Champion { name: "Orianna" })
MATCH (pantheon:Champion { name: "Pantheon" })
MATCH (poppy:Champion { name: "Poppy" })
MATCH (quinn:Champion { name: "Quinn" })
MATCH (rammus:Champion { name: "Rammus" })
MATCH (renekton:Champion { name: "Renekton" })
MATCH (rengar:Champion { name: "Rengar" })
MATCH (riven:Champion { name: "Riven" })
MATCH (rumble:Champion { name: "Rumble" })
MATCH (ryze:Champion { name: "Ryze" })
MATCH (sejuani:Champion { name: "Sejuani" })
MATCH (shaco:Champion { name: "Shaco" })
MATCH (shen:Champion { name: "Shen" })
MATCH (shyvana:Champion { name: "Shyvana" })
MATCH (singed:Champion { name: "Singed" })
MATCH (sion:Champion { name: "Sion" })
MATCH (sivir:Champion { name: "Sivir" })
MATCH (skarner:Champion { name: "Skarner" })
MATCH (sona:Champion { name: "Sona" })
MATCH (soraka:Champion { name: "Soraka" })
MATCH (swain:Champion { name: "Swain" })
MATCH (syndra:Champion { name: "Syndra" })
MATCH (talon:Champion { name: "Talon" })
MATCH (taric:Champion { name: "Taric" })
MATCH (teemo:Champion { name: "Teemo" })
MATCH (thresh:Champion { name: "Thresh" })
MATCH (tristana:Champion { name: "Tristana" })
MATCH (trundle:Champion { name: "Trundle" })
MATCH (tryndamere:Champion { name: "Tryndamere" })
MATCH (twistedfate:Champion { name: "Twisted Fate" })
MATCH (twitch:Champion { name: "Twitch" })
MATCH (udyr:Champion { name: "Udyr" })
MATCH (urgot:Champion { name: "Urgot" })
MATCH (varus:Champion { name: "Varus" })
MATCH (vayne:Champion { name: "Vayne" })
MATCH (veigar:Champion { name: "Veigar" })
MATCH (vi:Champion { name: "Vi" })
MATCH (viktor:Champion { name: "Viktor" })
MATCH (vladimir:Champion { name: "Vladimir" })
MATCH (volibear:Champion { name: "Volibear" })
MATCH (warwick:Champion { name: "Warwick" })
MATCH (wukong:Champion { name: "Wukong" })
MATCH (xerath:Champion { name: "Xerath" })
MATCH (xinzhao:Champion { name: "Xin'Zhao" })
MATCH (yasuo:Champion { name: "Yasuo" })
MATCH (yorick:Champion { name: "Yorick" })
MATCH (zac:Champion { name: "Zac" })
MATCH (zed:Champion { name: "Zed" })
MATCH (ziggs:Champion { name: "Ziggs" })
MATCH (zilean:Champion { name: "Zilean" })
MATCH (zyra:Champion { name: "Zyra" })
MATCH (c9:Team {name: "Cloud 9 HyperX"})
MATCH (clg:Team {name: "Counter Logic Gaming"})
MATCH (curse:Team {name: "Curse"})
MATCH (eg:Team {name: "Evil Geniuses"})
MATCH (coast:Team {name: "Team Coast"})
MATCH (dig:Team {name: "Team Dignitas"})
MATCH (tsm:Team {name: "Team SoloMid"})
MATCH (xdg:Team {name: "XDG"})
MATCH (top:Position {name: "Top"})
MATCH (jun:Position {name: "Jungle"})
MATCH (mid:Position {name: "Mid"})
MATCH (adc:Position {name: "AD Carry"})
MATCH (sup:Position {name: "Support"})
MATCH (balls:Player { name: "Balls" })
MATCH (balls)-[:PLAYS_FOR]->(c9)
MATCH (meteos:Player { name: "Meteos" })
MATCH (meteos)-[:PLAYS_FOR]->(c9)
MATCH (hai:Player { name: "Hai" })
MATCH (hai)-[:PLAYS_FOR]->(c9)
MATCH (sneaky:Player { name: "Sneaky" })
MATCH (sneaky)-[:PLAYS_FOR]->(c9)
MATCH (lemonnation:Player { name: "LemonNation" })
MATCH (lemonnation)-[:PLAYS_FOR]->(c9)
MATCH (nien:Player { name: "Nien" })
MATCH (nien)-[:PLAYS_FOR]->(clg)
MATCH (link:Player { name: "Link" })
MATCH (link)-[:PLAYS_FOR]->(clg)
MATCH (hotshotgg:Player { name: "HotshotGG" })
MATCH (hotshotgg)-[:PLAYS_FOR]->(clg)
MATCH (doublelift:Player { name: "Doublelift" })
MATCH (doublelift)-[:PLAYS_FOR]->(clg)
MATCH (aphromoo:Player { name: "aphromoo" })
MATCH (aphromoo)-[:PLAYS_FOR]->(clg)
MATCH (quas:Player { name: "Quas" })
MATCH (quas)-[:PLAYS_FOR]->(curse)
MATCH (iwilldominate:Player { name: "IWillDominate" })
MATCH (iwilldominate)-[:PLAYS_FOR]->(curse)
MATCH (voyboy:Player { name: "Voyboy" })
MATCH (voyboy)-[:PLAYS_FOR]->(curse)
MATCH (cop:Player { name: "Cop" })
MATCH (cop)-[:PLAYS_FOR]->(curse)
MATCH (zekent:Player { name: "Zekent" })
MATCH (zekent)-[:PLAYS_FOR]->(curse)
MATCH (innox:Player { name: "InnoX" })
MATCH (innox)-[:PLAYS_FOR]->(eg)
MATCH (snoopeh:Player { name: "snoopeh" })
MATCH (snoopeh)-[:PLAYS_FOR]->(eg)
MATCH (pobelter:Player { name: "Pobelter" })
MATCH (pobelter)-[:PLAYS_FOR]->(eg)
MATCH (yellowpete:Player { name: "Yellowpete" })
MATCH (yellowpete)-[:PLAYS_FOR]->(eg)
MATCH (krepo:Player { name: "Krepo" })
MATCH (krepo)-[:PLAYS_FOR]->(eg)
MATCH (zionspartan:Player { name: "ZionSpartan" })
MATCH (zionspartan)-[:PLAYS_FOR]->(coast)
MATCH (nintendudex:Player { name: "NintendudeX" })
MATCH (nintendudex)-[:PLAYS_FOR]->(coast)
MATCH (shiptur:Player { name: "Shiptur" })
MATCH (shiptur)-[:PLAYS_FOR]->(coast)
MATCH (wizfujiin:Player { name: "WizFujiiN" })
MATCH (wizfujiin)-[:PLAYS_FOR]->(coast)
MATCH (daydreamin:Player { name: "Daydreamin" })
MATCH (daydreamin)-[:PLAYS_FOR]->(coast)
MATCH (cruzerbruzer:Player { name: "CruzerBruzer" })
MATCH (cruzerbruzer)-[:PLAYS_FOR]->(dig)
MATCH (crumbzz:Player { name: "Crumbzz" })
MATCH (crumbzz)-[:PLAYS_FOR]->(dig)
MATCH (scarra:Player { name: "scarra" })
MATCH (scarra)-[:PLAYS_FOR]->(dig)
MATCH (imaqtpie:Player { name: "Imaqtpie" })
MATCH (imaqtpie)-[:PLAYS_FOR]->(dig)
MATCH (kiwikid:Player { name: "KiWiKiD" })
MATCH (kiwikid)-[:PLAYS_FOR]->(dig)
MATCH (dyrus:Player { name: "Dyrus" })
MATCH (dyrus)-[:PLAYS_FOR]->(tsm)
MATCH (theoddone:Player { name: "TheOddOne" })
MATCH (theoddone)-[:PLAYS_FOR]->(tsm)
MATCH (bjergsen:Player { name: "Bjergsen" })
MATCH (bjergsen)-[:PLAYS_FOR]->(tsm)
MATCH (wildturtle:Player { name: "WildTurtle" })
MATCH (wildturtle)-[:PLAYS_FOR]->(tsm)
MATCH (xspecial:Player { name: "Xspecial" })
MATCH (xspecial)-[:PLAYS_FOR]->(tsm)
MATCH (benny:Player { name: "Benny" })
MATCH (benny)-[:PLAYS_FOR]->(xdg)
MATCH (zuna:Player { name: "Zuna" })
MATCH (zuna)-[:PLAYS_FOR]->(xdg)
MATCH (mancloud:Player { name: "mancloud" })
MATCH (mancloud)-[:PLAYS_FOR]->(xdg)
MATCH (xmithie:Player { name: "Xmithie" })
MATCH (xmithie)-[:PLAYS_FOR]->(xdg)
MATCH (bloodwater:Player { name: "BloodWater" })
MATCH (bloodwater)-[:PLAYS_FOR]->(xdg)
MATCH (win:Outcome { name: "Win" })
MATCH (loss:Outcome { name: "Loss" })
CREATE (W1D2G1:Game { name: "W1D2G1" })
CREATE (quasW1D2G1:PlayerPerformance { name: "quas - W1D2G1" })
CREATE (quas)-[:PERFORMED]->(quasW1D2G1)
CREATE (quasW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (quasW1D2G1)-[:WAS_CHAMPION]->(karthus)
CREATE (quasW1D2G1)-[:IN_POSITION]->(top)
CREATE (quasW1D2G1)-[:HAD_OUTCOME]->(win)
CREATE (iwilldominateW1D2G1:PlayerPerformance { name: "iwilldominate - W1D2G1" })
CREATE (iwilldominate)-[:PERFORMED]->(iwilldominateW1D2G1)
CREATE (iwilldominateW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (iwilldominateW1D2G1)-[:WAS_CHAMPION]->(pantheon)
CREATE (iwilldominateW1D2G1)-[:IN_POSITION]->(jun)
CREATE (iwilldominateW1D2G1)-[:HAD_OUTCOME]->(win)
CREATE (voyboyW1D2G1:PlayerPerformance { name: "voyboy - W1D2G1" })
CREATE (voyboy)-[:PERFORMED]->(voyboyW1D2G1)
CREATE (voyboyW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (voyboyW1D2G1)-[:WAS_CHAMPION]->(akali)
CREATE (voyboyW1D2G1)-[:IN_POSITION]->(mid)
CREATE (voyboyW1D2G1)-[:HAD_OUTCOME]->(win)
CREATE (copW1D2G1:PlayerPerformance { name: "cop - W1D2G1" })
CREATE (cop)-[:PERFORMED]->(copW1D2G1)
CREATE (copW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (copW1D2G1)-[:WAS_CHAMPION]->(caitlyn)
CREATE (copW1D2G1)-[:IN_POSITION]->(adc)
CREATE (copW1D2G1)-[:HAD_OUTCOME]->(win)
CREATE (zekentW1D2G1:PlayerPerformance { name: "zekent - W1D2G1" })
CREATE (zekent)-[:PERFORMED]->(zekentW1D2G1)
CREATE (zekentW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (zekentW1D2G1)-[:WAS_CHAMPION]->(annie)
CREATE (zekentW1D2G1)-[:IN_POSITION]->(sup)
CREATE (zekentW1D2G1)-[:HAD_OUTCOME]->(win)
CREATE (bennyW1D2G1:PlayerPerformance { name: "benny - W1D2G1" })
CREATE (benny)-[:PERFORMED]->(bennyW1D2G1)
CREATE (bennyW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (bennyW1D2G1)-[:WAS_CHAMPION]->(shyvana)
CREATE (bennyW1D2G1)-[:IN_POSITION]->(top)
CREATE (bennyW1D2G1)-[:HAD_OUTCOME]->(loss)
CREATE (zunaW1D2G1:PlayerPerformance { name: "zuna - W1D2G1" })
CREATE (zuna)-[:PERFORMED]->(zunaW1D2G1)
CREATE (zunaW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (zunaW1D2G1)-[:WAS_CHAMPION]->(vi)
CREATE (zunaW1D2G1)-[:IN_POSITION]->(jun)
CREATE (zunaW1D2G1)-[:HAD_OUTCOME]->(loss)
CREATE (mancloudW1D2G1:PlayerPerformance { name: "mancloud - W1D2G1" })
CREATE (mancloud)-[:PERFORMED]->(mancloudW1D2G1)
CREATE (mancloudW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (mancloudW1D2G1)-[:WAS_CHAMPION]->(yasuo)
CREATE (mancloudW1D2G1)-[:IN_POSITION]->(mid)
CREATE (mancloudW1D2G1)-[:HAD_OUTCOME]->(loss)
CREATE (xmithieW1D2G1:PlayerPerformance { name: "xmithie - W1D2G1" })
CREATE (xmithie)-[:PERFORMED]->(xmithieW1D2G1)
CREATE (xmithieW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (xmithieW1D2G1)-[:WAS_CHAMPION]->(jinx)
CREATE (xmithieW1D2G1)-[:IN_POSITION]->(adc)
CREATE (xmithieW1D2G1)-[:HAD_OUTCOME]->(loss)
CREATE (bloodwaterW1D2G1:PlayerPerformance { name: "bloodwater - W1D2G1" })
CREATE (bloodwater)-[:PERFORMED]->(bloodwaterW1D2G1)
CREATE (bloodwaterW1D2G1)-[:PLAYED_IN]->(W1D2G1)
CREATE (bloodwaterW1D2G1)-[:WAS_CHAMPION]->(leona)
CREATE (bloodwaterW1D2G1)-[:IN_POSITION]->(sup)
CREATE (bloodwaterW1D2G1)-[:HAD_OUTCOME]->(loss)
CREATE (W1D2G2:Game { name: "W1D2G2" })
CREATE (ballsW1D2G2:PlayerPerformance { name: "balls - W1D2G2" })
CREATE (balls)-[:PERFORMED]->(ballsW1D2G2)
CREATE (ballsW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (ballsW1D2G2)-[:WAS_CHAMPION]->(drmundo)
CREATE (ballsW1D2G2)-[:IN_POSITION]->(top)
CREATE (ballsW1D2G2)-[:HAD_OUTCOME]->(win)
CREATE (meteosW1D2G2:PlayerPerformance { name: "meteos - W1D2G2" })
CREATE (meteos)-[:PERFORMED]->(meteosW1D2G2)
CREATE (meteosW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (meteosW1D2G2)-[:WAS_CHAMPION]->(elise)
CREATE (meteosW1D2G2)-[:IN_POSITION]->(jun)
CREATE (meteosW1D2G2)-[:HAD_OUTCOME]->(win)
CREATE (haiW1D2G2:PlayerPerformance { name: "hai - W1D2G2" })
CREATE (hai)-[:PERFORMED]->(haiW1D2G2)
CREATE (haiW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (haiW1D2G2)-[:WAS_CHAMPION]->(zed)
CREATE (haiW1D2G2)-[:IN_POSITION]->(mid)
CREATE (haiW1D2G2)-[:HAD_OUTCOME]->(win)
CREATE (sneakyW1D2G2:PlayerPerformance { name: "sneaky - W1D2G2" })
CREATE (sneaky)-[:PERFORMED]->(sneakyW1D2G2)
CREATE (sneakyW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (sneakyW1D2G2)-[:WAS_CHAMPION]->(lucian)
CREATE (sneakyW1D2G2)-[:IN_POSITION]->(adc)
CREATE (sneakyW1D2G2)-[:HAD_OUTCOME]->(win)
CREATE (lemonnationW1D2G2:PlayerPerformance { name: "lemonnation - W1D2G2" })
CREATE (lemonnation)-[:PERFORMED]->(lemonnationW1D2G2)
CREATE (lemonnationW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (lemonnationW1D2G2)-[:WAS_CHAMPION]->(thresh)
CREATE (lemonnationW1D2G2)-[:IN_POSITION]->(sup)
CREATE (lemonnationW1D2G2)-[:HAD_OUTCOME]->(win)
CREATE (nienW1D2G2:PlayerPerformance { name: "nien - W1D2G2" })
CREATE (nien)-[:PERFORMED]->(nienW1D2G2)
CREATE (nienW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (nienW1D2G2)-[:WAS_CHAMPION]->(shyvana)
CREATE (nienW1D2G2)-[:IN_POSITION]->(top)
CREATE (nienW1D2G2)-[:HAD_OUTCOME]->(loss)
CREATE (linkW1D2G2:PlayerPerformance { name: "link - W1D2G2" })
CREATE (link)-[:PERFORMED]->(linkW1D2G2)
CREATE (linkW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (linkW1D2G2)-[:WAS_CHAMPION]->(vi)
CREATE (linkW1D2G2)-[:IN_POSITION]->(jun)
CREATE (linkW1D2G2)-[:HAD_OUTCOME]->(loss)
CREATE (hotshotggW1D2G2:PlayerPerformance { name: "hotshotgg - W1D2G2" })
CREATE (hotshotgg)-[:PERFORMED]->(hotshotggW1D2G2)
CREATE (hotshotggW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (hotshotggW1D2G2)-[:WAS_CHAMPION]->(cassiopeia)
CREATE (hotshotggW1D2G2)-[:IN_POSITION]->(mid)
CREATE (hotshotggW1D2G2)-[:HAD_OUTCOME]->(loss)
CREATE (doubleliftW1D2G2:PlayerPerformance { name: "doublelift - W1D2G2" })
CREATE (doublelift)-[:PERFORMED]->(doubleliftW1D2G2)
CREATE (doubleliftW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (doubleliftW1D2G2)-[:WAS_CHAMPION]->(jinx)
CREATE (doubleliftW1D2G2)-[:IN_POSITION]->(adc)
CREATE (doubleliftW1D2G2)-[:HAD_OUTCOME]->(loss)
CREATE (aphromooW1D2G2:PlayerPerformance { name: "aphromoo - W1D2G2" })
CREATE (aphromoo)-[:PERFORMED]->(aphromooW1D2G2)
CREATE (aphromooW1D2G2)-[:PLAYED_IN]->(W1D2G2)
CREATE (aphromooW1D2G2)-[:WAS_CHAMPION]->(annie)
CREATE (aphromooW1D2G2)-[:IN_POSITION]->(sup)
CREATE (aphromooW1D2G2)-[:HAD_OUTCOME]->(loss)
CREATE (W1D2G3:Game { name: "W1D2G3" })
CREATE (cruzerbruzerW1D2G3:PlayerPerformance { name: "cruzerbruzer - W1D2G3" })
CREATE (cruzerbruzer)-[:PERFORMED]->(cruzerbruzerW1D2G3)
CREATE (cruzerbruzerW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (cruzerbruzerW1D2G3)-[:WAS_CHAMPION]->(trundle)
CREATE (cruzerbruzerW1D2G3)-[:IN_POSITION]->(top)
CREATE (cruzerbruzerW1D2G3)-[:HAD_OUTCOME]->(loss)
CREATE (crumbzzW1D2G3:PlayerPerformance { name: "crumbzz - W1D2G3" })
CREATE (crumbzz)-[:PERFORMED]->(crumbzzW1D2G3)
CREATE (crumbzzW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (crumbzzW1D2G3)-[:WAS_CHAMPION]->(leesin)
CREATE (crumbzzW1D2G3)-[:IN_POSITION]->(jun)
CREATE (crumbzzW1D2G3)-[:HAD_OUTCOME]->(loss)
CREATE (scarraW1D2G3:PlayerPerformance { name: "scarra - W1D2G3" })
CREATE (scarra)-[:PERFORMED]->(scarraW1D2G3)
CREATE (scarraW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (scarraW1D2G3)-[:WAS_CHAMPION]->(yasuo)
CREATE (scarraW1D2G3)-[:IN_POSITION]->(mid)
CREATE (scarraW1D2G3)-[:HAD_OUTCOME]->(loss)
CREATE (imaqtpieW1D2G3:PlayerPerformance { name: "imaqtpie - W1D2G3" })
CREATE (imaqtpie)-[:PERFORMED]->(imaqtpieW1D2G3)
CREATE (imaqtpieW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (imaqtpieW1D2G3)-[:WAS_CHAMPION]->(lucian)
CREATE (imaqtpieW1D2G3)-[:IN_POSITION]->(adc)
CREATE (imaqtpieW1D2G3)-[:HAD_OUTCOME]->(loss)
CREATE (kiwikidW1D2G3:PlayerPerformance { name: "kiwikid - W1D2G3" })
CREATE (kiwikid)-[:PERFORMED]->(kiwikidW1D2G3)
CREATE (kiwikidW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (kiwikidW1D2G3)-[:WAS_CHAMPION]->(annie)
CREATE (kiwikidW1D2G3)-[:IN_POSITION]->(sup)
CREATE (kiwikidW1D2G3)-[:HAD_OUTCOME]->(loss)
CREATE (dyrusW1D2G3:PlayerPerformance { name: "dyrus - W1D2G3" })
CREATE (dyrus)-[:PERFORMED]->(dyrusW1D2G3)
CREATE (dyrusW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (dyrusW1D2G3)-[:WAS_CHAMPION]->(warwick)
CREATE (dyrusW1D2G3)-[:IN_POSITION]->(top)
CREATE (dyrusW1D2G3)-[:HAD_OUTCOME]->(win)
CREATE (theoddoneW1D2G3:PlayerPerformance { name: "theoddone - W1D2G3" })
CREATE (theoddone)-[:PERFORMED]->(theoddoneW1D2G3)
CREATE (theoddoneW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (theoddoneW1D2G3)-[:WAS_CHAMPION]->(elise)
CREATE (theoddoneW1D2G3)-[:IN_POSITION]->(jun)
CREATE (theoddoneW1D2G3)-[:HAD_OUTCOME]->(win)
CREATE (bjergsenW1D2G3:PlayerPerformance { name: "bjergsen - W1D2G3" })
CREATE (bjergsen)-[:PERFORMED]->(bjergsenW1D2G3)
CREATE (bjergsenW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (bjergsenW1D2G3)-[:WAS_CHAMPION]->(leblanc)
CREATE (bjergsenW1D2G3)-[:IN_POSITION]->(mid)
CREATE (bjergsenW1D2G3)-[:HAD_OUTCOME]->(win)
CREATE (wildturtleW1D2G3:PlayerPerformance { name: "wildturtle - W1D2G3" })
CREATE (wildturtle)-[:PERFORMED]->(wildturtleW1D2G3)
CREATE (wildturtleW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (wildturtleW1D2G3)-[:WAS_CHAMPION]->(jinx)
CREATE (wildturtleW1D2G3)-[:IN_POSITION]->(adc)
CREATE (wildturtleW1D2G3)-[:HAD_OUTCOME]->(win)
CREATE (xspecialW1D2G3:PlayerPerformance { name: "xspecial - W1D2G3" })
CREATE (xspecial)-[:PERFORMED]->(xspecialW1D2G3)
CREATE (xspecialW1D2G3)-[:PLAYED_IN]->(W1D2G3)
CREATE (xspecialW1D2G3)-[:WAS_CHAMPION]->(thresh)
CREATE (xspecialW1D2G3)-[:IN_POSITION]->(sup)
CREATE (xspecialW1D2G3)-[:HAD_OUTCOME]->(win)
CREATE (W1D2G4:Game { name: "W1D2G4" })
CREATE (innoxW1D2G4:PlayerPerformance { name: "innox - W1D2G4" })
CREATE (innox)-[:PERFORMED]->(innoxW1D2G4)
CREATE (innoxW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (innoxW1D2G4)-[:WAS_CHAMPION]->(drmundo)
CREATE (innoxW1D2G4)-[:IN_POSITION]->(top)
CREATE (innoxW1D2G4)-[:HAD_OUTCOME]->(win)
CREATE (snoopehW1D2G4:PlayerPerformance { name: "snoopeh - W1D2G4" })
CREATE (snoopeh)-[:PERFORMED]->(snoopehW1D2G4)
CREATE (snoopehW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (snoopehW1D2G4)-[:WAS_CHAMPION]->(olaf)
CREATE (snoopehW1D2G4)-[:IN_POSITION]->(jun)
CREATE (snoopehW1D2G4)-[:HAD_OUTCOME]->(win)
CREATE (pobelterW1D2G4:PlayerPerformance { name: "pobelter - W1D2G4" })
CREATE (pobelter)-[:PERFORMED]->(pobelterW1D2G4)
CREATE (pobelterW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (pobelterW1D2G4)-[:WAS_CHAMPION]->(khazix)
CREATE (pobelterW1D2G4)-[:IN_POSITION]->(mid)
CREATE (pobelterW1D2G4)-[:HAD_OUTCOME]->(win)
CREATE (yellowpeteW1D2G4:PlayerPerformance { name: "yellowpete - W1D2G4" })
CREATE (yellowpete)-[:PERFORMED]->(yellowpeteW1D2G4)
CREATE (yellowpeteW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (yellowpeteW1D2G4)-[:WAS_CHAMPION]->(caitlyn)
CREATE (yellowpeteW1D2G4)-[:IN_POSITION]->(adc)
CREATE (yellowpeteW1D2G4)-[:HAD_OUTCOME]->(win)
CREATE (krepoW1D2G4:PlayerPerformance { name: "krepo - W1D2G4" })
CREATE (krepo)-[:PERFORMED]->(krepoW1D2G4)
CREATE (krepoW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (krepoW1D2G4)-[:WAS_CHAMPION]->(thresh)
CREATE (krepoW1D2G4)-[:IN_POSITION]->(sup)
CREATE (krepoW1D2G4)-[:HAD_OUTCOME]->(win)
CREATE (nienW1D2G4:PlayerPerformance { name: "nien - W1D2G4" })
CREATE (nien)-[:PERFORMED]->(nienW1D2G4)
CREATE (nienW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (nienW1D2G4)-[:WAS_CHAMPION]->(shyvana)
CREATE (nienW1D2G4)-[:IN_POSITION]->(top)
CREATE (nienW1D2G4)-[:HAD_OUTCOME]->(loss)
CREATE (linkW1D2G4:PlayerPerformance { name: "link - W1D2G4" })
CREATE (link)-[:PERFORMED]->(linkW1D2G4)
CREATE (linkW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (linkW1D2G4)-[:WAS_CHAMPION]->(elise)
CREATE (linkW1D2G4)-[:IN_POSITION]->(jun)
CREATE (linkW1D2G4)-[:HAD_OUTCOME]->(loss)
CREATE (hotshotggW1D2G4:PlayerPerformance { name: "hotshotgg - W1D2G4" })
CREATE (hotshotgg)-[:PERFORMED]->(hotshotggW1D2G4)
CREATE (hotshotggW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (hotshotggW1D2G4)-[:WAS_CHAMPION]->(nidalee)
CREATE (hotshotggW1D2G4)-[:IN_POSITION]->(mid)
CREATE (hotshotggW1D2G4)-[:HAD_OUTCOME]->(loss)
CREATE (doubleliftW1D2G4:PlayerPerformance { name: "doublelift - W1D2G4" })
CREATE (doublelift)-[:PERFORMED]->(doubleliftW1D2G4)
CREATE (doubleliftW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (doubleliftW1D2G4)-[:WAS_CHAMPION]->(ezreal)
CREATE (doubleliftW1D2G4)-[:IN_POSITION]->(adc)
CREATE (doubleliftW1D2G4)-[:HAD_OUTCOME]->(loss)
CREATE (aphromooW1D2G4:PlayerPerformance { name: "aphromoo - W1D2G4" })
CREATE (aphromoo)-[:PERFORMED]->(aphromooW1D2G4)
CREATE (aphromooW1D2G4)-[:PLAYED_IN]->(W1D2G4)
CREATE (aphromooW1D2G4)-[:WAS_CHAMPION]->(leona)
CREATE (aphromooW1D2G4)-[:IN_POSITION]->(sup)
CREATE (aphromooW1D2G4)-[:HAD_OUTCOME]->(loss)
CREATE (W1D2G5:Game { name: "W1D2G5" })
CREATE (zionspartanW1D2G5:PlayerPerformance { name: "zionspartan - W1D2G5" })
CREATE (zionspartan)-[:PERFORMED]->(zionspartanW1D2G5)
CREATE (zionspartanW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (zionspartanW1D2G5)-[:WAS_CHAMPION]->(yasuo)
CREATE (zionspartanW1D2G5)-[:IN_POSITION]->(top)
CREATE (zionspartanW1D2G5)-[:HAD_OUTCOME]->(loss)
CREATE (nintendudexW1D2G5:PlayerPerformance { name: "nintendudex - W1D2G5" })
CREATE (nintendudex)-[:PERFORMED]->(nintendudexW1D2G5)
CREATE (nintendudexW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (nintendudexW1D2G5)-[:WAS_CHAMPION]->(elise)
CREATE (nintendudexW1D2G5)-[:IN_POSITION]->(jun)
CREATE (nintendudexW1D2G5)-[:HAD_OUTCOME]->(loss)
CREATE (shiphturW1D2G5:PlayerPerformance { name: "shiphtur - W1D2G5" })
CREATE (shiphtur)-[:PERFORMED]->(shiphturW1D2G5)
CREATE (shiphturW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (shiphturW1D2G5)-[:WAS_CHAMPION]->(kayle)
CREATE (shiphturW1D2G5)-[:IN_POSITION]->(mid)
CREATE (shiphturW1D2G5)-[:HAD_OUTCOME]->(loss)
CREATE (wizfujiinW1D2G5:PlayerPerformance { name: "wizfujiin - W1D2G5" })
CREATE (wizfujiin)-[:PERFORMED]->(wizfujiinW1D2G5)
CREATE (wizfujiinW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (wizfujiinW1D2G5)-[:WAS_CHAMPION]->(varus)
CREATE (wizfujiinW1D2G5)-[:IN_POSITION]->(adc)
CREATE (wizfujiinW1D2G5)-[:HAD_OUTCOME]->(loss)
CREATE (daydreaminW1D2G5:PlayerPerformance { name: "daydreamin - W1D2G5" })
CREATE (daydreamin)-[:PERFORMED]->(daydreaminW1D2G5)
CREATE (daydreaminW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (daydreaminW1D2G5)-[:WAS_CHAMPION]->(thresh)
CREATE (daydreaminW1D2G5)-[:IN_POSITION]->(sup)
CREATE (daydreaminW1D2G5)-[:HAD_OUTCOME]->(loss)
CREATE (cruzerbruzerW1D2G5:PlayerPerformance { name: "cruzerbruzer - W1D2G5" })
CREATE (cruzerbruzer)-[:PERFORMED]->(cruzerbruzerW1D2G5)
CREATE (cruzerbruzerW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (cruzerbruzerW1D2G5)-[:WAS_CHAMPION]->(drmundo)
CREATE (cruzerbruzerW1D2G5)-[:IN_POSITION]->(top)
CREATE (cruzerbruzerW1D2G5)-[:HAD_OUTCOME]->(win)
CREATE (crumbzzW1D2G5:PlayerPerformance { name: "crumbzz - W1D2G5" })
CREATE (crumbzz)-[:PERFORMED]->(crumbzzW1D2G5)
CREATE (crumbzzW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (crumbzzW1D2G5)-[:WAS_CHAMPION]->(wukong)
CREATE (crumbzzW1D2G5)-[:IN_POSITION]->(jun)
CREATE (crumbzzW1D2G5)-[:HAD_OUTCOME]->(win)
CREATE (scarraW1D2G5:PlayerPerformance { name: "scarra - W1D2G5" })
CREATE (scarra)-[:PERFORMED]->(scarraW1D2G5)
CREATE (scarraW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (scarraW1D2G5)-[:WAS_CHAMPION]->(karthus)
CREATE (scarraW1D2G5)-[:IN_POSITION]->(mid)
CREATE (scarraW1D2G5)-[:HAD_OUTCOME]->(win)
CREATE (imaqtpieW1D2G5:PlayerPerformance { name: "imaqtpie - W1D2G5" })
CREATE (imaqtpie)-[:PERFORMED]->(imaqtpieW1D2G5)
CREATE (imaqtpieW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (imaqtpieW1D2G5)-[:WAS_CHAMPION]->(jinx)
CREATE (imaqtpieW1D2G5)-[:IN_POSITION]->(adc)
CREATE (imaqtpieW1D2G5)-[:HAD_OUTCOME]->(win)
CREATE (kiwikidW1D2G5:PlayerPerformance { name: "kiwikid - W1D2G5" })
CREATE (kiwikid)-[:PERFORMED]->(kiwikidW1D2G5)
CREATE (kiwikidW1D2G5)-[:PLAYED_IN]->(W1D2G5)
CREATE (kiwikidW1D2G5)-[:WAS_CHAMPION]->(annie)
CREATE (kiwikidW1D2G5)-[:IN_POSITION]->(sup)
CREATE (kiwikidW1D2G5)-[:HAD_OUTCOME]->(win);
----
//hide
//setup
[source,cypher]
----
MATCH (aatrox:Champion { name: "Aatrox" })
MATCH (ahri:Champion { name: "Ahri" })
MATCH (akali:Champion { name: "Akali" })
MATCH (alistar:Champion { name: "Alistar" })
MATCH (amumu:Champion { name: "Amumu" })
MATCH (anivia:Champion { name: "Anivia" })
MATCH (annie:Champion { name: "Annie" })
MATCH (ashe:Champion { name: "Ashe" })
MATCH (blitzcrank:Champion { name: "Blitzcrank" })
MATCH (brand:Champion { name: "Brand" })
MATCH (caitlyn:Champion { name: "Caitlyn" })
MATCH (cassiopeia:Champion { name: "Cassiopeia" })
MATCH (chogath:Champion { name: "Cho'Gath" })
MATCH (corki:Champion { name: "Corki" })
MATCH (darius:Champion { name: "Darius" })
MATCH (diana:Champion { name: "Diana" })
MATCH (draven:Champion { name: "Draven" })
MATCH (drmundo:Champion { name: "Dr.Mundo" })
MATCH (elise:Champion { name: "Elise" })
MATCH (evelynn:Champion { name: "Evelynn" })
MATCH (ezreal:Champion { name: "Ezreal" })
MATCH (fiddlesticks:Champion { name: "Fiddlesticks" })
MATCH (fiora:Champion { name: "Fiora" })
MATCH (fizz:Champion { name: "Fizz" })
MATCH (galio:Champion { name: "Galio" })
MATCH (gangplank:Champion { name: "Gangplank" })
MATCH (garen:Champion { name: "Garen" })
MATCH (gragas:Champion { name: "Gragas" })
MATCH (graves:Champion { name: "Graves" })
MATCH (hecarim:Champion { name: "Hecarim" })
MATCH (heimerdinger:Champion { name: "Heimerdinger" })
MATCH (irelia:Champion { name: "Irelia" })
MATCH (janna:Champion { name: "Janna" })
MATCH (jarvaniv:Champion { name: "Jarvan IV" })
MATCH (jax:Champion { name: "Jax" })
MATCH (jayce:Champion { name: "Jayce" })
MATCH (jinx:Champion { name: "Jinx" })
MATCH (karma:Champion { name: "Karma" })
MATCH (karthus:Champion { name: "Karthus" })
MATCH (kassadin:Champion { name: "Kassadin" })
MATCH (katarina:Champion { name: "Katarina" })
MATCH (kayle:Champion { name: "Kayle" })
MATCH (kennen:Champion { name: "Kennen" })
MATCH (khazix:Champion { name: "Kha'Zix" })
MATCH (kogmaw:Champion { name: "Kog'Maw" })
MATCH (leblanc:Champion { name: "LeBlanc" })
MATCH (leesin:Champion { name: "Lee Sin" })
MATCH (leona:Champion { name: "Leona" })
MATCH (lissandra:Champion { name: "Lissandra" })
MATCH (lucian:Champion { name: "Lucian" })
MATCH (lulu:Champion { name: "Lulu" })
MATCH (lux:Champion { name: "Lux" })
MATCH (malphite:Champion { name: "Malphite" })
MATCH (malzahar:Champion { name: "Malzahar" })
MATCH (maokai:Champion { name: "Maokai" })
MATCH (masteryi:Champion { name: "Master Yi" })
MATCH (missfortune:Champion { name: "Miss Fortune" })
MATCH (mordekaiser:Champion { name: "Mordekaiser" })
MATCH (morgana:Champion { name: "Morgana" })
MATCH (nami:Champion { name: "Nami" })
MATCH (nasus:Champion { name: "Nasus" })
MATCH (nautilus:Champion { name: "Nautilus" })
MATCH (nidalee:Champion { name: "Nidalee" })
MATCH (nocturne:Champion { name: "Nocturne" })
MATCH (nunu:Champion { name: "Nunu" })
MATCH (olaf:Champion { name: "Olaf" })
MATCH (orianna:Champion { name: "Orianna" })
MATCH (pantheon:Champion { name: "Pantheon" })
MATCH (poppy:Champion { name: "Poppy" })
MATCH (quinn:Champion { name: "Quinn" })
MATCH (rammus:Champion { name: "Rammus" })
MATCH (renekton:Champion { name: "Renekton" })
MATCH (rengar:Champion { name: "Rengar" })
MATCH (riven:Champion { name: "Riven" })
MATCH (rumble:Champion { name: "Rumble" })
MATCH (ryze:Champion { name: "Ryze" })
MATCH (sejuani:Champion { name: "Sejuani" })
MATCH (shaco:Champion { name: "Shaco" })
MATCH (shen:Champion { name: "Shen" })
MATCH (shyvana:Champion { name: "Shyvana" })
MATCH (singed:Champion { name: "Singed" })
MATCH (sion:Champion { name: "Sion" })
MATCH (sivir:Champion { name: "Sivir" })
MATCH (skarner:Champion { name: "Skarner" })
MATCH (sona:Champion { name: "Sona" })
MATCH (soraka:Champion { name: "Soraka" })
MATCH (swain:Champion { name: "Swain" })
MATCH (syndra:Champion { name: "Syndra" })
MATCH (talon:Champion { name: "Talon" })
MATCH (taric:Champion { name: "Taric" })
MATCH (teemo:Champion { name: "Teemo" })
MATCH (thresh:Champion { name: "Thresh" })
MATCH (tristana:Champion { name: "Tristana" })
MATCH (trundle:Champion { name: "Trundle" })
MATCH (tryndamere:Champion { name: "Tryndamere" })
MATCH (twistedfate:Champion { name: "Twisted Fate" })
MATCH (twitch:Champion { name: "Twitch" })
MATCH (udyr:Champion { name: "Udyr" })
MATCH (urgot:Champion { name: "Urgot" })
MATCH (varus:Champion { name: "Varus" })
MATCH (vayne:Champion { name: "Vayne" })
MATCH (veigar:Champion { name: "Veigar" })
MATCH (vi:Champion { name: "Vi" })
MATCH (viktor:Champion { name: "Viktor" })
MATCH (vladimir:Champion { name: "Vladimir" })
MATCH (volibear:Champion { name: "Volibear" })
MATCH (warwick:Champion { name: "Warwick" })
MATCH (wukong:Champion { name: "Wukong" })
MATCH (xerath:Champion { name: "Xerath" })
MATCH (xinzhao:Champion { name: "Xin'Zhao" })
MATCH (yasuo:Champion { name: "Yasuo" })
MATCH (yorick:Champion { name: "Yorick" })
MATCH (zac:Champion { name: "Zac" })
MATCH (zed:Champion { name: "Zed" })
MATCH (ziggs:Champion { name: "Ziggs" })
MATCH (zilean:Champion { name: "Zilean" })
MATCH (zyra:Champion { name: "Zyra" })
MATCH (c9:Team {name: "Cloud 9 HyperX"})
MATCH (clg:Team {name: "Counter Logic Gaming"})
MATCH (curse:Team {name: "Curse"})
MATCH (eg:Team {name: "Evil Geniuses"})
MATCH (coast:Team {name: "Team Coast"})
MATCH (dig:Team {name: "Team Dignitas"})
MATCH (tsm:Team {name: "Team SoloMid"})
MATCH (xdg:Team {name: "XDG"})
MATCH (top:Position {name: "Top"})
MATCH (jun:Position {name: "Jungle"})
MATCH (mid:Position {name: "Mid"})
MATCH (adc:Position {name: "AD Carry"})
MATCH (sup:Position {name: "Support"})
MATCH (balls:Player { name: "Balls" })
MATCH (balls)-[:PLAYS_FOR]->(c9)
MATCH (meteos:Player { name: "Meteos" })
MATCH (meteos)-[:PLAYS_FOR]->(c9)
MATCH (hai:Player { name: "Hai" })
MATCH (hai)-[:PLAYS_FOR]->(c9)
MATCH (sneaky:Player { name: "Sneaky" })
MATCH (sneaky)-[:PLAYS_FOR]->(c9)
MATCH (lemonnation:Player { name: "LemonNation" })
MATCH (lemonnation)-[:PLAYS_FOR]->(c9)
MATCH (nien:Player { name: "Nien" })
MATCH (nien)-[:PLAYS_FOR]->(clg)
MATCH (link:Player { name: "Link" })
MATCH (link)-[:PLAYS_FOR]->(clg)
MATCH (hotshotgg:Player { name: "HotshotGG" })
MATCH (hotshotgg)-[:PLAYS_FOR]->(clg)
MATCH (doublelift:Player { name: "Doublelift" })
MATCH (doublelift)-[:PLAYS_FOR]->(clg)
MATCH (aphromoo:Player { name: "aphromoo" })
MATCH (aphromoo)-[:PLAYS_FOR]->(clg)
MATCH (quas:Player { name: "Quas" })
MATCH (quas)-[:PLAYS_FOR]->(curse)
MATCH (iwilldominate:Player { name: "IWillDominate" })
MATCH (iwilldominate)-[:PLAYS_FOR]->(curse)
MATCH (voyboy:Player { name: "Voyboy" })
MATCH (voyboy)-[:PLAYS_FOR]->(curse)
MATCH (cop:Player { name: "Cop" })
MATCH (cop)-[:PLAYS_FOR]->(curse)
MATCH (zekent:Player { name: "Zekent" })
MATCH (zekent)-[:PLAYS_FOR]->(curse)
MATCH (innox:Player { name: "InnoX" })
MATCH (innox)-[:PLAYS_FOR]->(eg)
MATCH (snoopeh:Player { name: "snoopeh" })
MATCH (snoopeh)-[:PLAYS_FOR]->(eg)
MATCH (pobelter:Player { name: "Pobelter" })
MATCH (pobelter)-[:PLAYS_FOR]->(eg)
MATCH (yellowpete:Player { name: "Yellowpete" })
MATCH (yellowpete)-[:PLAYS_FOR]->(eg)
MATCH (krepo:Player { name: "Krepo" })
MATCH (krepo)-[:PLAYS_FOR]->(eg)
MATCH (zionspartan:Player { name: "ZionSpartan" })
MATCH (zionspartan)-[:PLAYS_FOR]->(coast)
MATCH (nintendudex:Player { name: "NintendudeX" })
MATCH (nintendudex)-[:PLAYS_FOR]->(coast)
MATCH (shiptur:Player { name: "Shiptur" })
MATCH (shiptur)-[:PLAYS_FOR]->(coast)
MATCH (wizfujiin:Player { name: "WizFujiiN" })
MATCH (wizfujiin)-[:PLAYS_FOR]->(coast)
MATCH (daydreamin:Player { name: "Daydreamin" })
MATCH (daydreamin)-[:PLAYS_FOR]->(coast)
MATCH (cruzerbruzer:Player { name: "CruzerBruzer" })
MATCH (cruzerbruzer)-[:PLAYS_FOR]->(dig)
MATCH (crumbzz:Player { name: "Crumbzz" })
MATCH (crumbzz)-[:PLAYS_FOR]->(dig)
MATCH (scarra:Player { name: "scarra" })
MATCH (scarra)-[:PLAYS_FOR]->(dig)
MATCH (imaqtpie:Player { name: "Imaqtpie" })
MATCH (imaqtpie)-[:PLAYS_FOR]->(dig)
MATCH (kiwikid:Player { name: "KiWiKiD" })
MATCH (kiwikid)-[:PLAYS_FOR]->(dig)
MATCH (dyrus:Player { name: "Dyrus" })
MATCH (dyrus)-[:PLAYS_FOR]->(tsm)
MATCH (theoddone:Player { name: "TheOddOne" })
MATCH (theoddone)-[:PLAYS_FOR]->(tsm)
MATCH (bjergsen:Player { name: "Bjergsen" })
MATCH (bjergsen)-[:PLAYS_FOR]->(tsm)
MATCH (wildturtle:Player { name: "WildTurtle" })
MATCH (wildturtle)-[:PLAYS_FOR]->(tsm)
MATCH (xspecial:Player { name: "Xspecial" })
MATCH (xspecial)-[:PLAYS_FOR]->(tsm)
MATCH (benny:Player { name: "Benny" })
MATCH (benny)-[:PLAYS_FOR]->(xdg)
MATCH (zuna:Player { name: "Zuna" })
MATCH (zuna)-[:PLAYS_FOR]->(xdg)
MATCH (mancloud:Player { name: "mancloud" })
MATCH (mancloud)-[:PLAYS_FOR]->(xdg)
MATCH (xmithie:Player { name: "Xmithie" })
MATCH (xmithie)-[:PLAYS_FOR]->(xdg)
MATCH (bloodwater:Player { name: "BloodWater" })
MATCH (bloodwater)-[:PLAYS_FOR]->(xdg)
MATCH (win:Outcome { name: "Win" })
MATCH (loss:Outcome { name: "Loss" })
CREATE (W1D3G1:Game { name: "W1D3G1" })
CREATE (nienW1D3G1:PlayerPerformance { name: "nien - W1D3G1" })
CREATE (nien)-[:PERFORMED]->(nienW1D3G1)
CREATE (nienW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (nienW1D3G1)-[:WAS_CHAMPION]->(drmundo)
CREATE (nienW1D3G1)-[:IN_POSITION]->(top)
CREATE (nienW1D3G1)-[:HAD_OUTCOME]->(win)
CREATE (linkW1D3G1:PlayerPerformance { name: "link - W1D3G1" })
CREATE (link)-[:PERFORMED]->(linkW1D3G1)
CREATE (linkW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (linkW1D3G1)-[:WAS_CHAMPION]->(elise)
CREATE (linkW1D3G1)-[:IN_POSITION]->(jun)
CREATE (linkW1D3G1)-[:HAD_OUTCOME]->(win)
CREATE (hotshotggW1D3G1:PlayerPerformance { name: "hotshotgg - W1D3G1" })
CREATE (hotshotgg)-[:PERFORMED]->(hotshotggW1D3G1)
CREATE (hotshotggW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (hotshotggW1D3G1)-[:WAS_CHAMPION]->(nidalee)
CREATE (hotshotggW1D3G1)-[:IN_POSITION]->(mid)
CREATE (hotshotggW1D3G1)-[:HAD_OUTCOME]->(win)
CREATE (doubleliftW1D3G1:PlayerPerformance { name: "doublelift - W1D3G1" })
CREATE (doublelift)-[:PERFORMED]->(doubleliftW1D3G1)
CREATE (doubleliftW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (doubleliftW1D3G1)-[:WAS_CHAMPION]->(vayne)
CREATE (doubleliftW1D3G1)-[:IN_POSITION]->(adc)
CREATE (doubleliftW1D3G1)-[:HAD_OUTCOME]->(win)
CREATE (aphromooW1D3G1:PlayerPerformance { name: "aphromoo - W1D3G1" })
CREATE (aphromoo)-[:PERFORMED]->(aphromooW1D3G1)
CREATE (aphromooW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (aphromooW1D3G1)-[:WAS_CHAMPION]->(thresh)
CREATE (aphromooW1D3G1)-[:IN_POSITION]->(sup)
CREATE (aphromooW1D3G1)-[:HAD_OUTCOME]->(win)
CREATE (quasW1D3G1:PlayerPerformance { name: "quas - W1D3G1" })
CREATE (quas)-[:PERFORMED]->(quasW1D3G1)
CREATE (quasW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (quasW1D3G1)-[:WAS_CHAMPION]->(shyvana)
CREATE (quasW1D3G1)-[:IN_POSITION]->(top)
CREATE (quasW1D3G1)-[:HAD_OUTCOME]->(loss)
CREATE (iwilldominateW1D3G1:PlayerPerformance { name: "iwilldominate - W1D3G1" })
CREATE (iwilldominate)-[:PERFORMED]->(iwilldominateW1D3G1)
CREATE (iwilldominateW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (iwilldominateW1D3G1)-[:WAS_CHAMPION]->(gragas)
CREATE (iwilldominateW1D3G1)-[:IN_POSITION]->(jun)
CREATE (iwilldominateW1D3G1)-[:HAD_OUTCOME]->(loss)
CREATE (voyboyW1D3G1:PlayerPerformance { name: "voyboy - W1D3G1" })
CREATE (voyboy)-[:PERFORMED]->(voyboyW1D3G1)
CREATE (voyboyW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (voyboyW1D3G1)-[:WAS_CHAMPION]->(khazix)
CREATE (voyboyW1D3G1)-[:IN_POSITION]->(mid)
CREATE (voyboyW1D3G1)-[:HAD_OUTCOME]->(loss)
CREATE (copW1D3G1:PlayerPerformance { name: "cop - W1D3G1" })
CREATE (cop)-[:PERFORMED]->(copW1D3G1)
CREATE (copW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (copW1D3G1)-[:WAS_CHAMPION]->(caitlyn)
CREATE (copW1D3G1)-[:IN_POSITION]->(adc)
CREATE (copW1D3G1)-[:HAD_OUTCOME]->(loss)
CREATE (zekentW1D3G1:PlayerPerformance { name: "zekent - W1D3G1" })
CREATE (zekent)-[:PERFORMED]->(zekentW1D3G1)
CREATE (zekentW1D3G1)-[:PLAYED_IN]->(W1D3G1)
CREATE (zekentW1D3G1)-[:WAS_CHAMPION]->(lulu)
CREATE (zekentW1D3G1)-[:IN_POSITION]->(sup)
CREATE (zekentW1D3G1)-[:HAD_OUTCOME]->(loss)
CREATE (W1D3G2:Game { name: "W1D3G2" })
CREATE (cruzerbruzerW1D3G2:PlayerPerformance { name: "cruzerbruzer - W1D3G2" })
CREATE (cruzerbruzer)-[:PERFORMED]->(cruzerbruzerW1D3G2)
CREATE (cruzerbruzerW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (cruzerbruzerW1D3G2)-[:WAS_CHAMPION]->(drmundo)
CREATE (cruzerbruzerW1D3G2)-[:IN_POSITION]->(top)
CREATE (cruzerbruzerW1D3G2)-[:HAD_OUTCOME]->(win)
CREATE (crumbzzW1D3G2:PlayerPerformance { name: "crumbzz - W1D3G2" })
CREATE (crumbzz)-[:PERFORMED]->(crumbzzW1D3G2)
CREATE (crumbzzW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (crumbzzW1D3G2)-[:WAS_CHAMPION]->(vi)
CREATE (crumbzzW1D3G2)-[:IN_POSITION]->(jun)
CREATE (crumbzzW1D3G2)-[:HAD_OUTCOME]->(win)
CREATE (scarraW1D3G2:PlayerPerformance { name: "scarra - W1D3G2" })
CREATE (scarra)-[:PERFORMED]->(scarraW1D3G2)
CREATE (scarraW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (scarraW1D3G2)-[:WAS_CHAMPION]->(gragas)
CREATE (scarraW1D3G2)-[:IN_POSITION]->(mid)
CREATE (scarraW1D3G2)-[:HAD_OUTCOME]->(win)
CREATE (imaqtpieW1D3G2:PlayerPerformance { name: "imaqtpie - W1D3G2" })
CREATE (imaqtpie)-[:PERFORMED]->(imaqtpieW1D3G2)
CREATE (imaqtpieW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (imaqtpieW1D3G2)-[:WAS_CHAMPION]->(jinx)
CREATE (imaqtpieW1D3G2)-[:IN_POSITION]->(adc)
CREATE (imaqtpieW1D3G2)-[:HAD_OUTCOME]->(win)
CREATE (kiwikidW1D3G2:PlayerPerformance { name: "kiwikid - W1D3G2" })
CREATE (kiwikid)-[:PERFORMED]->(kiwikidW1D3G2)
CREATE (kiwikidW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (kiwikidW1D3G2)-[:WAS_CHAMPION]->(thresh)
CREATE (kiwikidW1D3G2)-[:IN_POSITION]->(sup)
CREATE (kiwikidW1D3G2)-[:HAD_OUTCOME]->(win)
CREATE (ballsW1D3G2:PlayerPerformance { name: "balls - W1D3G2" })
CREATE (balls)-[:PERFORMED]->(ballsW1D3G2)
CREATE (ballsW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (ballsW1D3G2)-[:WAS_CHAMPION]->(shyvana)
CREATE (ballsW1D3G2)-[:IN_POSITION]->(top)
CREATE (ballsW1D3G2)-[:HAD_OUTCOME]->(loss)
CREATE (meteosW1D3G2:PlayerPerformance { name: "meteos - W1D3G2" })
CREATE (meteos)-[:PERFORMED]->(meteosW1D3G2)
CREATE (meteosW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (meteosW1D3G2)-[:WAS_CHAMPION]->(elise)
CREATE (meteosW1D3G2)-[:IN_POSITION]->(jun)
CREATE (meteosW1D3G2)-[:HAD_OUTCOME]->(loss)
CREATE (haiW1D3G2:PlayerPerformance { name: "hai - W1D3G2" })
CREATE (hai)-[:PERFORMED]->(haiW1D3G2)
CREATE (haiW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (haiW1D3G2)-[:WAS_CHAMPION]->(riven)
CREATE (haiW1D3G2)-[:IN_POSITION]->(mid)
CREATE (haiW1D3G2)-[:HAD_OUTCOME]->(loss)
CREATE (sneakyW1D3G2:PlayerPerformance { name: "sneaky - W1D3G2" })
CREATE (sneaky)-[:PERFORMED]->(sneakyW1D3G2)
CREATE (sneakyW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (sneakyW1D3G2)-[:WAS_CHAMPION]->(lucian)
CREATE (sneakyW1D3G2)-[:IN_POSITION]->(adc)
CREATE (sneakyW1D3G2)-[:HAD_OUTCOME]->(loss)
CREATE (lemonnationW1D3G2:PlayerPerformance { name: "lemonnation - W1D3G2" })
CREATE (lemonnation)-[:PERFORMED]->(lemonnationW1D3G2)
CREATE (lemonnationW1D3G2)-[:PLAYED_IN]->(W1D3G2)
CREATE (lemonnationW1D3G2)-[:WAS_CHAMPION]->(leona)
CREATE (lemonnationW1D3G2)-[:IN_POSITION]->(sup)
CREATE (lemonnationW1D3G2)-[:HAD_OUTCOME]->(loss)
CREATE (W1D3G3:Game { name: "W1D3G3" })
CREATE (zionspartanW1D3G3:PlayerPerformance { name: "zionspartan - W1D3G3" })
CREATE (zionspartan)-[:PERFORMED]->(zionspartanW1D3G3)
CREATE (zionspartanW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (zionspartanW1D3G3)-[:WAS_CHAMPION]->(nasus)
CREATE (zionspartanW1D3G3)-[:IN_POSITION]->(top)
CREATE (zionspartanW1D3G3)-[:HAD_OUTCOME]->(win)
CREATE (nintendudexW1D3G3:PlayerPerformance { name: "nintendudex - W1D3G3" })
CREATE (nintendudex)-[:PERFORMED]->(nintendudexW1D3G3)
CREATE (nintendudexW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (nintendudexW1D3G3)-[:WAS_CHAMPION]->(olaf)
CREATE (nintendudexW1D3G3)-[:IN_POSITION]->(jun)
CREATE (nintendudexW1D3G3)-[:HAD_OUTCOME]->(win)
CREATE (shiphturW1D3G3:PlayerPerformance { name: "shiphtur - W1D3G3" })
CREATE (shiphtur)-[:PERFORMED]->(shiphturW1D3G3)
CREATE (shiphturW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (shiphturW1D3G3)-[:WAS_CHAMPION]->(leblanc)
CREATE (shiphturW1D3G3)-[:IN_POSITION]->(mid)
CREATE (shiphturW1D3G3)-[:HAD_OUTCOME]->(win)
CREATE (wizfujiinW1D3G3:PlayerPerformance { name: "wizfujiin - W1D3G3" })
CREATE (wizfujiin)-[:PERFORMED]->(wizfujiinW1D3G3)
CREATE (wizfujiinW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (wizfujiinW1D3G3)-[:WAS_CHAMPION]->(varus)
CREATE (wizfujiinW1D3G3)-[:IN_POSITION]->(adc)
CREATE (wizfujiinW1D3G3)-[:HAD_OUTCOME]->(win)
CREATE (daydreaminW1D3G3:PlayerPerformance { name: "daydreamin - W1D3G3" })
CREATE (daydreamin)-[:PERFORMED]->(daydreaminW1D3G3)
CREATE (daydreaminW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (daydreaminW1D3G3)-[:WAS_CHAMPION]->(lulu)
CREATE (daydreaminW1D3G3)-[:IN_POSITION]->(sup)
CREATE (daydreaminW1D3G3)-[:HAD_OUTCOME]->(win)
CREATE (innoxW1D3G3:PlayerPerformance { name: "innox - W1D3G3" })
CREATE (innox)-[:PERFORMED]->(innoxW1D3G3)
CREATE (innoxW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (innoxW1D3G3)-[:WAS_CHAMPION]->(drmundo)
CREATE (innoxW1D3G3)-[:IN_POSITION]->(top)
CREATE (innoxW1D3G3)-[:HAD_OUTCOME]->(loss)
CREATE (snoopehW1D3G3:PlayerPerformance { name: "snoopeh - W1D3G3" })
CREATE (snoopeh)-[:PERFORMED]->(snoopehW1D3G3)
CREATE (snoopehW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (snoopehW1D3G3)-[:WAS_CHAMPION]->(gragas)
CREATE (snoopehW1D3G3)-[:IN_POSITION]->(jun)
CREATE (snoopehW1D3G3)-[:HAD_OUTCOME]->(loss)
CREATE (pobelterW1D3G3:PlayerPerformance { name: "pobelter - W1D3G3" })
CREATE (pobelter)-[:PERFORMED]->(pobelterW1D3G3)
CREATE (pobelterW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (pobelterW1D3G3)-[:WAS_CHAMPION]->(riven)
CREATE (pobelterW1D3G3)-[:IN_POSITION]->(mid)
CREATE (pobelterW1D3G3)-[:HAD_OUTCOME]->(loss)
CREATE (yellowpeteW1D3G3:PlayerPerformance { name: "yellowpete - W1D3G3" })
CREATE (yellowpete)-[:PERFORMED]->(yellowpeteW1D3G3)
CREATE (yellowpeteW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (yellowpeteW1D3G3)-[:WAS_CHAMPION]->(jinx)
CREATE (yellowpeteW1D3G3)-[:IN_POSITION]->(adc)
CREATE (yellowpeteW1D3G3)-[:HAD_OUTCOME]->(loss)
CREATE (krepoW1D3G3:PlayerPerformance { name: "krepo - W1D3G3" })
CREATE (krepo)-[:PERFORMED]->(krepoW1D3G3)
CREATE (krepoW1D3G3)-[:PLAYED_IN]->(W1D3G3)
CREATE (krepoW1D3G3)-[:WAS_CHAMPION]->(thresh)
CREATE (krepoW1D3G3)-[:IN_POSITION]->(sup)
CREATE (krepoW1D3G3)-[:HAD_OUTCOME]->(loss)
CREATE (W1D3G4:Game { name: "W1D3G4" })
CREATE (dyrusW1D3G4:PlayerPerformance { name: "dyrus - W1D3G4" })
CREATE (dyrus)-[:PERFORMED]->(dyrusW1D3G4)
CREATE (dyrusW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (dyrusW1D3G4)-[:WAS_CHAMPION]->(shyvana)
CREATE (dyrusW1D3G4)-[:IN_POSITION]->(top)
CREATE (dyrusW1D3G4)-[:HAD_OUTCOME]->(win)
CREATE (theoddoneW1D3G4:PlayerPerformance { name: "theoddone - W1D3G4" })
CREATE (theoddone)-[:PERFORMED]->(theoddoneW1D3G4)
CREATE (theoddoneW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (theoddoneW1D3G4)-[:WAS_CHAMPION]->(olaf)
CREATE (theoddoneW1D3G4)-[:IN_POSITION]->(jun)
CREATE (theoddoneW1D3G4)-[:HAD_OUTCOME]->(win)
CREATE (bjergsenW1D3G4:PlayerPerformance { name: "bjergsen - W1D3G4" })
CREATE (bjergsen)-[:PERFORMED]->(bjergsenW1D3G4)
CREATE (bjergsenW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (bjergsenW1D3G4)-[:WAS_CHAMPION]->(leblanc)
CREATE (bjergsenW1D3G4)-[:IN_POSITION]->(mid)
CREATE (bjergsenW1D3G4)-[:HAD_OUTCOME]->(win)
CREATE (wildturtleW1D3G4:PlayerPerformance { name: "wildturtle - W1D3G4" })
CREATE (wildturtle)-[:PERFORMED]->(wildturtleW1D3G4)
CREATE (wildturtleW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (wildturtleW1D3G4)-[:WAS_CHAMPION]->(sivir)
CREATE (wildturtleW1D3G4)-[:IN_POSITION]->(adc)
CREATE (wildturtleW1D3G4)-[:HAD_OUTCOME]->(win)
CREATE (xspecialW1D3G4:PlayerPerformance { name: "xspecial - W1D3G4" })
CREATE (xspecial)-[:PERFORMED]->(xspecialW1D3G4)
CREATE (xspecialW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (xspecialW1D3G4)-[:WAS_CHAMPION]->(leona)
CREATE (xspecialW1D3G4)-[:IN_POSITION]->(sup)
CREATE (xspecialW1D3G4)-[:HAD_OUTCOME]->(win)
CREATE (quasW1D3G4:PlayerPerformance { name: "quas - W1D3G4" })
CREATE (quas)-[:PERFORMED]->(quasW1D3G4)
CREATE (quasW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (quasW1D3G4)-[:WAS_CHAMPION]->(drmundo)
CREATE (quasW1D3G4)-[:IN_POSITION]->(top)
CREATE (quasW1D3G4)-[:HAD_OUTCOME]->(loss)
CREATE (iwilldominateW1D3G4:PlayerPerformance { name: "iwilldominate - W1D3G4" })
CREATE (iwilldominate)-[:PERFORMED]->(iwilldominateW1D3G4)
CREATE (iwilldominateW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (iwilldominateW1D3G4)-[:WAS_CHAMPION]->(wukong)
CREATE (iwilldominateW1D3G4)-[:IN_POSITION]->(jun)
CREATE (iwilldominateW1D3G4)-[:HAD_OUTCOME]->(loss)
CREATE (voyboyW1D3G4:PlayerPerformance { name: "voyboy - W1D3G4" })
CREATE (voyboy)-[:PERFORMED]->(voyboyW1D3G4)
CREATE (voyboyW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (voyboyW1D3G4)-[:WAS_CHAMPION]->(riven)
CREATE (voyboyW1D3G4)-[:IN_POSITION]->(mid)
CREATE (voyboyW1D3G4)-[:HAD_OUTCOME]->(loss)
CREATE (copW1D3G4:PlayerPerformance { name: "cop - W1D3G4" })
CREATE (cop)-[:PERFORMED]->(copW1D3G4)
CREATE (copW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (copW1D3G4)-[:WAS_CHAMPION]->(lucian)
CREATE (copW1D3G4)-[:IN_POSITION]->(adc)
CREATE (copW1D3G4)-[:HAD_OUTCOME]->(loss)
CREATE (zekentW1D3G4:PlayerPerformance { name: "zekent - W1D3G4" })
CREATE (zekent)-[:PERFORMED]->(zekentW1D3G4)
CREATE (zekentW1D3G4)-[:PLAYED_IN]->(W1D3G4)
CREATE (zekentW1D3G4)-[:WAS_CHAMPION]->(annie)
CREATE (zekentW1D3G4)-[:IN_POSITION]->(sup)
CREATE (zekentW1D3G4)-[:HAD_OUTCOME]->(loss)
CREATE (W1D3G5:Game { name: "W1D3G5" })
CREATE (bennyW1D3G5:PlayerPerformance { name: "benny - W1D3G5" })
CREATE (benny)-[:PERFORMED]->(bennyW1D3G5)
CREATE (bennyW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (bennyW1D3G5)-[:WAS_CHAMPION]->(drmundo)
CREATE (bennyW1D3G5)-[:IN_POSITION]->(top)
CREATE (bennyW1D3G5)-[:HAD_OUTCOME]->(loss)
CREATE (zunaW1D3G5:PlayerPerformance { name: "zuna - W1D3G5" })
CREATE (zuna)-[:PERFORMED]->(zunaW1D3G5)
CREATE (zunaW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (zunaW1D3G5)-[:WAS_CHAMPION]->(elise)
CREATE (zunaW1D3G5)-[:IN_POSITION]->(jun)
CREATE (zunaW1D3G5)-[:HAD_OUTCOME]->(loss)
CREATE (mancloudW1D3G5:PlayerPerformance { name: "mancloud - W1D3G5" })
CREATE (mancloud)-[:PERFORMED]->(mancloudW1D3G5)
CREATE (mancloudW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (mancloudW1D3G5)-[:WAS_CHAMPION]->(kayle)
CREATE (mancloudW1D3G5)-[:IN_POSITION]->(mid)
CREATE (mancloudW1D3G5)-[:HAD_OUTCOME]->(loss)
CREATE (xmithieW1D3G5:PlayerPerformance { name: "xmithie - W1D3G5" })
CREATE (xmithie)-[:PERFORMED]->(xmithieW1D3G5)
CREATE (xmithieW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (xmithieW1D3G5)-[:WAS_CHAMPION]->(lucian)
CREATE (xmithieW1D3G5)-[:IN_POSITION]->(adc)
CREATE (xmithieW1D3G5)-[:HAD_OUTCOME]->(loss)
CREATE (bloodwaterW1D3G5:PlayerPerformance { name: "bloodwater - W1D3G5" })
CREATE (bloodwater)-[:PERFORMED]->(bloodwaterW1D3G5)
CREATE (bloodwaterW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (bloodwaterW1D3G5)-[:WAS_CHAMPION]->(annie)
CREATE (bloodwaterW1D3G5)-[:IN_POSITION]->(sup)
CREATE (bloodwaterW1D3G5)-[:HAD_OUTCOME]->(loss)
CREATE (zionspartanW1D3G5:PlayerPerformance { name: "zionspartan - W1D3G5" })
CREATE (zionspartan)-[:PERFORMED]->(zionspartanW1D3G5)
CREATE (zionspartanW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (zionspartanW1D3G5)-[:WAS_CHAMPION]->(yasuo)
CREATE (zionspartanW1D3G5)-[:IN_POSITION]->(top)
CREATE (zionspartanW1D3G5)-[:HAD_OUTCOME]->(win)
CREATE (nintendudexW1D3G5:PlayerPerformance { name: "nintendudex - W1D3G5" })
CREATE (nintendudex)-[:PERFORMED]->(nintendudexW1D3G5)
CREATE (nintendudexW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (nintendudexW1D3G5)-[:WAS_CHAMPION]->(shyvana)
CREATE (nintendudexW1D3G5)-[:IN_POSITION]->(jun)
CREATE (nintendudexW1D3G5)-[:HAD_OUTCOME]->(win)
CREATE (shiphturW1D3G5:PlayerPerformance { name: "shiphtur - W1D3G5" })
CREATE (shiphtur)-[:PERFORMED]->(shiphturW1D3G5)
CREATE (shiphturW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (shiphturW1D3G5)-[:WAS_CHAMPION]->(nidalee)
CREATE (shiphturW1D3G5)-[:IN_POSITION]->(mid)
CREATE (shiphturW1D3G5)-[:HAD_OUTCOME]->(win)
CREATE (wizfujiinW1D3G5:PlayerPerformance { name: "wizfujiin - W1D3G5" })
CREATE (wizfujiin)-[:PERFORMED]->(wizfujiinW1D3G5)
CREATE (wizfujiinW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (wizfujiinW1D3G5)-[:WAS_CHAMPION]->(jinx)
CREATE (wizfujiinW1D3G5)-[:IN_POSITION]->(adc)
CREATE (wizfujiinW1D3G5)-[:HAD_OUTCOME]->(win)
CREATE (daydreaminW1D3G5:PlayerPerformance { name: "daydreamin - W1D3G5" })
CREATE (daydreamin)-[:PERFORMED]->(daydreaminW1D3G5)
CREATE (daydreaminW1D3G5)-[:PLAYED_IN]->(W1D3G5)
CREATE (daydreaminW1D3G5)-[:WAS_CHAMPION]->(thresh)
CREATE (daydreaminW1D3G5)-[:IN_POSITION]->(sup)
CREATE (daydreaminW1D3G5)-[:HAD_OUTCOME]->(win)
----
== Champion Occurrences
A possible question someone might have - What champions have been played so far in the LCS?
[source,cypher]
----
MATCH (n:PlayerPerformance)-[:WAS_CHAMPION]->(champion:Champion)
RETURN distinct champion.name AS Champion
----
//table
More specifically, someone might only want champions played in a specific position, e.g. Top.
[source,cypher]
----
MATCH (top:Position { name: "Top" })<-[:IN_POSITION]-(n:PlayerPerformance)-[:WAS_CHAMPION]->(champion)
RETURN distinct champion.name AS Champion
----
//table
You may also be interested in the frequency certain champions were selected for a specific position with a lot of repetition, e.g. AD Carry.
[source,cypher]
----
MATCH (adc:Position { name: "AD Carry" })<-[:IN_POSITION]-(n:PlayerPerformance)-[:WAS_CHAMPION]->(champion)
RETURN distinct champion.name AS Champion, count(champion) AS Count ORDER BY count(champion) DESC
----
//table
Some players may be notable for breaking the mold. Figure out who played them with the following query (Credit to Brian Gates for the idea)
[source,cypher]
----
MATCH (p:Player)-[:PERFORMED]-(n:PlayerPerformance)-[:WAS_CHAMPION]->(champion)
RETURN DISTINCT champion.name AS Champion, count(champion) AS Count, collect(p.name)
ORDER BY count(champion) ASC
----
//table
== Finding the matches you want
Many fans prefer particular players, teams, or champions. Due to the large amount of content produced by the LCS and other options (OGN, NA LCS, EU LCS, etc.) the amount of games available to watch could quickly exceed someone's free time. This model could easily be extended to also include the URL of the game in the Game node, and be extended to other regions. Below are some proofs of concept revolving around quickly finding the game or games to watch.
One person may absolutely love Meteos, and only want to see games involving him. While in the current state this means games involving Cloud 9, if he moves / plays with another team, that would change.
[source,cypher]
----
MATCH (p:Player {name: "Meteos"})-[:PERFORMED]-(n:PlayerPerformance)-[:PLAYED_IN]->(g:Game)
RETURN p.name AS Player, g.name as Game
----
//table
Another person may like Riven more than all the other champions, and choose only to watch those games.
[source,cypher]
----
MATCH (c:Champion {name: "Riven"})<-[:WAS_CHAMPION]-(n:PlayerPerformance)-[:PLAYED_IN]->(g:Game)
RETURN c.name AS Champion, g.name as Game
----
//table
Another person may really want to see Sneaky play some games, but hates it when he plays Caitlyn.
[source,cypher]
----
MATCH (c:Champion)<-[:WAS_CHAMPION]-(n:PlayerPerformance)-[:PLAYED_IN]->(g:Game)
MATCH (p:Player)-[:PERFORMED]-(n:PlayerPerformance)-[:PLAYED_IN]->(g:Game)
WHERE p.name = "Sneaky" AND NOT c.name = "Caitlyn"
RETURN c.name AS Champion, g.name as Game
----
//table
Others may particularly like a specific player, but get crushed when they lose.
[source,cypher]
----
MATCH (o:Outcome)<-[:HAD_OUTCOME]-(n:PlayerPerformance)-[:PLAYED_IN]->(g:Game)
MATCH (p:Player)-[:PERFORMED]->(n:PlayerPerformance)-[:PLAYED_IN]->(g:Game)
WHERE p.name = "Dyrus" AND NOT o.name = "Loss"
RETURN g.name as Game
----
//table
= Training
Another great benefit of League of Legends when it comes to data - There are significantly more games played than other sports. Though the number of professional games is often similar to traditional sports, practice for eSports is much more similar to the game itself. Because League of Legends doesn't have a mode to try specific scenarios over and over, like a basketball team might drill free-throws, most professionals train by playing full-length games, many of which are streamed.
It may be beneficial for players to try and find games specific to what they think might happen in the upcoming professionally sanctioned matched.
For example, some may want to find the people Meteos has never lost a game with, and ban that champion.
[source,cypher]
----
MATCH (pl:Player { name: "Meteos" })-[:PERFORMED]-(losses:PlayerPerformance)-[:HAD_OUTCOME]->(loss:Outcome { name: "Loss" })
MATCH (lossChampion:Champion)<-[:WAS_CHAMPION]-(losses)
WITH collect(distinct lossChampion) as losingChampions
MATCH (pw:Player { name: "Meteos" })-[:PERFORMED]-(wins:PlayerPerformance)-[:HAD_OUTCOME]->(win:Outcome { name: "Win" })
MATCH (winChampion:Champion)<-[:WAS_CHAMPION]-(wins)
WHERE NOT winChampion IN losingChampions
RETURN distinct winChampion.name as Undefeated
----
//table
== Conclusion
Overall, there are many, many applications of this for the LCS. As the data available continues to grow, Neo4j seems equipped to deal with it.
It could also be used on a more general scale for all players, but Neo4j does have it's limitations. When trying to find something related to a particular player, e.g. your games to review, or a professional player's to watch, then Neo4j excels. However, due to also wanting large amounts of aggregate statistics (e.g. average game length of games with a Nasus), I don't think that Neo4j could entirely replace the current data solution, just add a valuable source of querying for information.
I plan on updating this Gist periodically, and will hopefully extend this into a more full featured web app.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment