|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 1
Kushner3
Noam2
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 2
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 3
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 4
|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 5
He'Atid
Kushner
5/18 6:00pm @ He'Atid
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 6
Moriah10
Ramaz3
|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 7
He'Atid
Moriah
5/26 4:30pm @ He'Atid
|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 16
WINNER
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 8
5/27 6:00pm Game being played @ Frisch
|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 9
SAR
SSBC
5/26 5:30pm @ SAR
|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 10
SAR3
Kinneret2
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 11
SSBC4
Yavneh0
|
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 12
Kinneret11
BPY2
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 13
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 14
SELECT B.*,
SH.school_name as TopSchool , SA.school_name as BotSchool,
Top.logo as tlogo , Bot.logo as blogo,
SH.logo as topschoollogo, SA.logo as bottomschoollogo,
uses_text_score, G.gym_id_fk, Gyms.*,
G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score
FROM PlayoffBrackets B
Left Join Games G on B.game_id_fk = G.GameID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
Left Join Teams Top on Top.TeamID = top_team_id_fk
Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk
Left Join Schools SH on SH.school_id = Top.school_id_fk
Left Join Schools SA on SA.school_id = Bot.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk
WHERE B.league_id_fk = 20
AND slot_number = 15
|