World cup revenge

results.txt

In 2010, Mexico gained revenge over France for beating them in 1930 after a wait of 80 years
In 1986, Argentina gained revenge over Uruguay for beating them in 1930 after a wait of 56 years
In 2010, Mexico gained revenge over France for beating them in 1954 after a wait of 56 years
In 1986, Brazil gained revenge over Spain for beating them in 1934 after a wait of 52 years
In 1982, France gained revenge over Austria for beating them in 1934 after a wait of 48 years
In 1986, France gained revenge over Italy for beating them in 1938 after a wait of 48 years
In 2006, France gained revenge over Brazil for beating them in 1958 after a wait of 48 years
In 2010, Switzerland gained revenge over Spain for beating them in 1966 after a wait of 44 years
In 1978, Brazil gained revenge over Italy for beating them in 1938 after a wait of 40 years
In 1998, France gained revenge over Brazil for beating them in 1958 after a wait of 40 years
In 1970, Romania gained revenge over Czechoslovakia for beating them in 1934 after a wait of 36 years
In 1974, Poland gained revenge over Brazil for beating them in 1938 after a wait of 36 years
In 1990, Czechoslovakia gained revenge over Austria for beating them in 1954 after a wait of 36 years
In 1962, Yugoslavia gained revenge over Uruguay for beating them in 1930 after a wait of 32 years
In 1970, Brazil gained revenge over Italy for beating them in 1938 after a wait of 32 years
In 1994, Bulgaria gained revenge over Argentina for beating them in 1962 after a wait of 32 years
In 1962, Brazil gained revenge over Spain for beating them in 1934 after a wait of 28 years
In 1978, Spain gained revenge over Sweden for beating them in 1950 after a wait of 28 years
In 1986, Germany FR gained revenge over France for beating them in 1958 after a wait of 28 years
In 1986, Argentina gained revenge over Germany FR for beating them in 1958 after a wait of 28 years
In 1990, Germany FR gained revenge over Yugoslavia for beating them in 1962 after a wait of 28 years
In 1998, Romania gained revenge over England for beating them in 1970 after a wait of 28 years
In 1974, Sweden gained revenge over Uruguay for beating them in 1950 after a wait of 24 years
In 1978, Austria gained revenge over Germany FR for beating them in 1954 after a wait of 24 years
In 1986, Argentina gained revenge over England for beating them in 1962 after a wait of 24 years
In 1950, Brazil gained revenge over Yugoslavia for beating them in 1930 after a wait of 20 years
In 1958, Sweden gained revenge over Hungary for beating them in 1938 after a wait of 20 years
In 1970, Italy gained revenge over Sweden for beating them in 1950 after a wait of 20 years
In 1970, Brazil gained revenge over Uruguay for beating them in 1950 after a wait of 20 years
In 1970, Sweden gained revenge over Uruguay for beating them in 1950 after a wait of 20 years
In 1986, Argentina gained revenge over England for beating them in 1966 after a wait of 20 years
In 1986, Portugal gained revenge over England for beating them in 1966 after a wait of 20 years
In 1994, Brazil gained revenge over Netherlands for beating them in 1974 after a wait of 20 years
In 1998, Netherlands gained revenge over Argentina for beating them in 1978 after a wait of 20 years
In 1950, Brazil gained revenge over Spain for beating them in 1934 after a wait of 16 years
In 1974, Germany FR gained revenge over Sweden for beating them in 1958 after a wait of 16 years
In 1986, Belgium gained revenge over Soviet Union for beating them in 1970 after a wait of 16 years
In 1990, Argentina gained revenge over Brazil for beating them in 1974 after a wait of 16 years
In 2002, England gained revenge over Argentina for beating them in 1986 after a wait of 16 years
In 2002, Korea Republic gained revenge over Italy for beating them in 1986 after a wait of 16 years
In 2002, Portugal gained revenge over Poland for beating them in 1986 after a wait of 16 years
In 2010, Netherlands gained revenge over Brazil for beating them in 1994 after a wait of 16 years
In 2010, Greece gained revenge over Nigeria for beating them in 1994 after a wait of 16 years
In 2010, Switzerland gained revenge over Spain for beating them in 1994 after a wait of 16 years
In 1974, Germany FR gained revenge over Yugoslavia for beating them in 1962 after a wait of 12 years
In 1982, Italy gained revenge over Brazil for beating them in 1970 after a wait of 12 years
In 1986, Brazil gained revenge over Poland for beating them in 1974 after a wait of 12 years
In 2010, South Africa gained revenge over France for beating them in 1998 after a wait of 12 years
In 1962, Yugoslavia gained revenge over Germany FR for beating them in 1954 after a wait of 8 years
In 1962, Italy gained revenge over Switzerland for beating them in 1954 after a wait of 8 years
In 1962, Italy gained revenge over Switzerland for beating them in 1954 after a wait of 8 years
In 1970, Uruguay gained revenge over Soviet Union for beating them in 1962 after a wait of 8 years
In 1982, Italy gained revenge over Poland for beating them in 1974 after a wait of 8 years
In 1986, France gained revenge over Italy for beating them in 1978 after a wait of 8 years
In 1990, Argentina gained revenge over Brazil for beating them in 1982 after a wait of 8 years
In 1990, Yugoslavia gained revenge over Spain for beating them in 1982 after a wait of 8 years
In 1994, Bulgaria gained revenge over Argentina for beating them in 1986 after a wait of 8 years
In 1962, Yugoslavia gained revenge over Germany FR for beating them in 1958 after a wait of 4 years
In 1966, Italy gained revenge over Chile for beating them in 1962 after a wait of 4 years
In 1966, Soviet Union gained revenge over Chile for beating them in 1962 after a wait of 4 years
In 1970, Germany FR gained revenge over England for beating them in 1966 after a wait of 4 years
In 1978, Argentina gained revenge over Poland for beating them in 1974 after a wait of 4 years
In 1978, Brazil gained revenge over Poland for beating them in 1974 after a wait of 4 years
In 1978, Argentina gained revenge over Netherlands for beating them in 1974 after a wait of 4 years
In 1982, Germany FR gained revenge over Austria for beating them in 1978 after a wait of 4 years
In 1982, Italy gained revenge over Brazil for beating them in 1978 after a wait of 4 years
In 1986, Argentina gained revenge over Belgium for beating them in 1982 after a wait of 4 years
In 1986, Spain gained revenge over Northern Ireland for beating them in 1982 after a wait of 4 years
In 1986, Belgium gained revenge over Soviet Union for beating them in 1982 after a wait of 4 years
In 1990, Germany FR gained revenge over Argentina for beating them in 1986 after a wait of 4 years
In 1994, Republic of Ireland gained revenge over Italy for beating them in 1990 after a wait of 4 years
In 2002, Denmark gained revenge over France for beating them in 1998 after a wait of 4 years

revenge.cyp

MATCH (year1) <-[:IN_YEAR]- (cup:WorldCup) -[:NEXT*0..18]-> (nextcup:WorldCup) -[:IN_YEAR]-> (year2)
MATCH (country1:Country) -[:NAMED_SQUAD]-> (c1s1:Squad) -[:FOR_WORLD_CUP]-> (cup)
MATCH (country2:Country) -[:NAMED_SQUAD]-> (c2s1:Squad) -[:FOR_WORLD_CUP]-> (cup)
MATCH (country1) -[:NAMED_SQUAD]-> (c1s2:Squad) -[:FOR_WORLD_CUP]-> (nextcup)
MATCH (country2) -[:NAMED_SQUAD]-> (c2s2:Squad) -[:FOR_WORLD_CUP]-> (nextcup)
MATCH (c1s1) -[:BEAT]-> (c2s1)
MATCH (c2s2) -[:BEAT]-> (c1s2)
WITH year2.year - year1.year as wait, year1, year2, country1, country2
ORDER BY wait desc, year1.year, year2.year

RETURN "In " + year2.year + ", " + country2.name + " gained revenge over " + country1.name + " for beating them in " + year1.year + " after a wait of " + wait + " years" AS message