|
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 = 19
AND slot_number = 1
Kushner9
WDS0
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 = 19
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 = 19
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 = 19
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 = 19
AND slot_number = 5
SSBC12
Kushner4
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 = 19
AND slot_number = 6
Noam4
He'Atid9
|
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 = 19
AND slot_number = 7
SSBC
He'Atid
5/19 6:00pm @ SSBC
|
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 = 19
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 = 19
AND slot_number = 8
5/27 7:30pm 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 = 19
AND slot_number = 9
Kinneret
Yavneh
5/19 8:15pm @ Kinneret
|
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 = 19
AND slot_number = 10
SAR3
Yavneh9
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 = 19
AND slot_number = 11
Kinneret7
Ramaz5
|
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 = 19
AND slot_number = 12
Yavneh5
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 = 19
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 = 19
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 = 19
AND slot_number = 15
|