Table: player_stats_59
Columns: name
total
league
canadian_championship
concacaf_champions_league

Question: What name has a CONCACAF Champions League of 2 (0) and also a Canadian Championship of 8 (0)?
SQL: SELECT "name" FROM player_stats_59 WHERE "concacaf_champions_league" = '2 (0)' AND "canadian_championship" = '8 (0)'

Question: When the league is 84 (4) what is the Canadian Championship?
SQL: SELECT "canadian_championship" FROM player_stats_59 WHERE "league" = '84 (4)'

Question: What Canadian Championship has 84 (4) as the league?
SQL: SELECT "canadian_championship" FROM player_stats_59 WHERE "league" = '84 (4)'

Question: What Canadian Championship has Ashtone Morgan Category:Articles with hcards as the name?
SQL: SELECT "canadian_championship" FROM player_stats_59 WHERE "name" = 'ashtone morgan category:articles with hcards'

Question: What is the total when the name is Carl Robinson Category:Articles with hcards?
SQL: SELECT "total" FROM player_stats_59 WHERE "name" = 'carl robinson category:articles with hcards'

Question: What CONCACAF Champions League has 57 (27) as the league?
SQL: SELECT "concacaf_champions_league" FROM player_stats_59 WHERE "league" = '57 (27)'