Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT m.ID, m.Name, g.MatchID, COUNT(*)
- FROM MEMBER m, PLAYER p, GOALS g
- WHERE m.ID = p.ID
- AND p.ID = g.PlayerID
- AND g.MatchID IN
- (SELECT DISTINCT n.ID
- FROM TEAM h, `MATCH` n
- WHERE (h.ID = n.HomeTeamID
- OR h.ID = n.AwayTeamID)
- AND n.ID IN (
- SELECT DISTINCT t.`ID`
- FROM PLAYER q, `MATCH` t
- WHERE t.`ID` IN(
- SELECT DISTINCT w.ID
- FROM `MATCH` w
- WHERE w.`HomeTeamID` IN (
- SELECT e.ID
- FROM TEAM e, COUNTRY c
- WHERE e.`Country` = c.`Name`
- AND e.Country = 'Iceland')
- OR w.AwayTeamID IN (
- SELECT e.ID
- FROM TEAM e, COUNTRY c
- WHERE e.`Country` = c.`Name`
- AND e.Country = 'Iceland'))))
- GROUP BY m.Name
- HAVING COUNT(*) = (
- (SELECT COUNT(DISTINCT(n.`ID`))
- FROM TEAM h, `MATCH` n
- WHERE (h.ID = n.HomeTeamID
- OR h.ID = n.AwayTeamID)
- AND n.ID IN (
- SELECT DISTINCT t.`ID`
- FROM PLAYER q, `MATCH` t
- WHERE t.`ID` IN(
- SELECT DISTINCT w.ID
- FROM `MATCH` w
- WHERE w.`HomeTeamID` IN (
- SELECT e.ID
- FROM TEAM e, COUNTRY c
- WHERE e.`Country` = c.`Name`
- AND e.Country = 'Iceland')
- OR w.AwayTeamID IN (
- SELECT e.ID
- FROM TEAM e, COUNTRY c
- WHERE e.`Country` = c.`Name`
- AND e.Country = 'Iceland')))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement