CREATE TABLE table_2781227_4 (college_junior_club_team VARCHAR, player VARCHAR)

For player is adam wiesel mention all the college/junior/club team
SELECT college_junior_club_team FROM table_2781227_4 WHERE player = "Adam Wiesel"
SELECT "college_junior_club_team" FROM "table_2781227_4" WHERE "Adam Wiesel" = "player"