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
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 = 223
AND slot_number = 1
YDE19
FLATBUSH52
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
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 = 223
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
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 = 223
AND slot_number = 3
RAMAZ52
TABC55
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
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 = 223
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
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 = 223
AND slot_number = 5
FLATBUSH37
SAR56
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
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 = 223
AND slot_number = 6
TABC33
DRS51
|
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
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 = 223
AND slot_number = 7
SAR47
DRS38
|
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
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 = 223
AND slot_number = 16
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
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 = 223
AND slot_number = 8
SAR59
FRISCH47
|
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
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 = 223
AND slot_number = 9
HILLEL44
FRISCH64
|
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
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 = 223
AND slot_number = 10
HILLEL57
NORTH SHORE49
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
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 = 223
AND slot_number = 11
HAFTR31
FRISCH38
|
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
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 = 223
AND slot_number = 12
JEC60
HILLEL64
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
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 = 223
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
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 = 223
AND slot_number = 14
MAGEN DAVID43
HAFTR52
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
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 = 223
AND slot_number = 15
|