Last active
January 3, 2016 17:09
-
-
Save KevinGreene/8493604 to your computer and use it in GitHub Desktop.
NA LCS GraphGist
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
= 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