|
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 = 14
AND slot_number = 1
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 = 14
AND slot_number = 2
Ramaz34
SAR 736
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 = 14
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 = 14
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 = 14
AND slot_number = 5
He'Atid56
SAR 726
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 = 14
AND slot_number = 6
Moriah69
Noam41
|
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 = 14
AND slot_number = 7
He'Atid49
Moriah36
|
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 = 14
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 = 14
AND slot_number = 8
He'Atid
Hillel
3/08 2:00pm Game being played @ TABC
|
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 = 14
AND slot_number = 9
Hillel53
Yavneh32
|
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 = 14
AND slot_number = 10
Hillel61
SAR33
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 = 14
AND slot_number = 11
Yavneh47
Kushner25
|
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 = 14
AND slot_number = 12
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 = 14
AND slot_number = 13
SAR49
Moriah 747
Overtime
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 = 14
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 = 14
AND slot_number = 15
|