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 = 2
AND slot_number = 5
Hillel49
Yavneh21
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 = 2
AND slot_number = 6
Ramaz46
He'Atid44
|
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 = 2
AND slot_number = 7
Hillel50
Ramaz42
|
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 = 2
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, 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 = 2
AND slot_number = 8
Hillel34
RYNJ36
|
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 = 2
AND slot_number = 9
RYNJ57
Noam33
|
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 = 2
AND slot_number = 10
RYNJW
MoriahL
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 = 2
AND slot_number = 11
Noam52
SAR46
|