CHANNELS:
Severn
Team News  |  Schedule  |  Roster  |  Photos  |  Videos
BOYS VARSITY BASEBALL
schedules[execute query]
select group_concat(distinct concat(st.home_team,'|' , r.score) ) score, s.id, s.start_time, s.end_time, s.in_conference, s.title, s.game_notes,concat_ws('|', v.id, v.display_name, ifnull(v.notes, ''), a.address, ifnull(a.address_2, ''), a.city, a.state, a.zip, a.google_maps_url) as venue, concat_ws('|', type.id, type.name) as type, concat_ws('|', status.id, status.name) as status, concat_ws('|', c1.id, c1.title) as pre_article, concat_ws('|', c2.id, c2.title) as post_article, concat_ws('|', c3.id, c3.title) as box_article, concat('|', group_concat(distinct convert(sp.id, char) separator '|'), '|') as sports, concat('|', group_concat(distinct convert(l.id, char) separator '|'), '|') as levels, concat('|', group_concat(distinct t.gender separator '|'), '|') as genders, concat('|', group_concat(distinct convert(se.id, char) separator '|'), '|') as seasons, concat('|', group_concat(distinct convert(c.id, char) separator '|'), '|') as conferences, concat('|', group_concat(distinct convert(leag.id, char) separator '|'), '|') as leagues, concat('|', group_concat(distinct convert(sc.id, char) separator '|'), '|') as schools, concat('|', group_concat(distinct convert(t.id, char) separator '|'), '|') as team_ids, group_concat(distinct concat_ws('|', st.home_team, st.team_name, ts.id, t.id, sc.short_name, t.gender, l.name, sp.name, se.start_year, se.end_year, n.j_item_id) separator '||') as teams from #__vsn_schedules s inner join #__vsn_schedule_types type on s.schedule_type_id = type.id inner join #__vsn_schedule_statuses status on s.schedule_status_id = status.id inner join #__vsn_schedule_teams st on s.id = st.schedule_id left outer join #__vsn_team_seasons ts on st.team_season_id = ts.id left outer join #__vsn_teams t on ts.team_id = t.id left outer join #__vsn_sports sp on t.sport_id = sp.id left outer join #__vsn_team_levels l on ts.team_level_id = l.id left outer join #__vsn_seasons se on ts.season_id = se.id left outer join #__vsn_nodes n on t.id = n.type_id and n.type = 'team' left outer join #__vsn_node_hierarchy nh on n.id = nh.child left outer join #__vsn_nodes n5 on ts.id = n5.type_id and n5.type = 'team_season' left outer join #__vsn_node_hierarchy nh5 on nh5.child = n5.id left outer join #__vsn_nodes n2 on nh.parent = n2.id and n2.type = 'school' left outer join #__vsn_schools sc on n2.type_id = sc.id left outer join #__vsn_node_hierarchy nh2 on n2.id = nh2.child left outer join #__vsn_nodes n3 on nh2.parent = n3.id and n3.type = 'conference' left outer join #__vsn_conferences c on n3.type_id = c.id left outer join #__vsn_node_hierarchy nh3 on nh3.child = n.id left outer join #__vsn_nodes n4 on nh5.parent = n4.id and n4.type = 'league' left outer join #__vsn_leagues leag on n4.type_id = leag.id left outer join #__vsn_results r on st.id = r.schedule_team_id left outer join #__vsn_venues v on s.venue_id = v.id left outer join #__vsn_addresses a on v.address_id = a.id left outer join #__content c1 on s.pre_article_id = c1.id left outer join #__content c2 on s.post_article_id = c2.id left outer join #__content c3 on s.box_article_id = c3.id where (s.id = 10453 OR s.id = 11490 OR s.id = 11170 OR s.id = 11178 OR s.id = 11195 OR s.id = 11316 OR s.id = 11433 OR s.id = 11459 OR s.id = 11466 OR s.id = 11476 OR s.id = 11488 OR s.id = 11161 OR s.id = 11491 OR s.id = 11492 OR s.id = 11494 OR s.id = 11495 OR s.id = 11496 OR s.id = 11497 OR s.id = 11499 OR s.id = 11500 OR s.id = 11501 OR s.id = 14622 OR s.id = 14896 OR s.id = 15053 OR s.id = 24786 OR s.id = 24788 OR s.id = 24789 OR s.id = 24790 OR s.id = 24791 OR s.id = 24792 OR s.id = 24793 OR s.id = 24794 OR s.id = 24795 OR s.id = 24797 OR s.id = 24798 OR s.id = 24799 OR s.id = 24800 OR s.id = 24801 OR s.id = 24802 OR s.id = 24803 OR s.id = 24804 OR s.id = 24805 OR s.id = 24806 OR s.id = 24807 OR s.id = 24808 OR s.id = 24809 OR s.id = 25998 OR s.id = 28768 OR s.id = 29892 OR s.id = 30146 OR s.id = 40372 OR s.id = 40398 OR s.id = 41423 OR s.id = 41977 OR s.id = 41982 OR s.id = 41992 OR s.id = 42000 OR s.id = 43133 OR s.id = 43181 OR s.id = 43185 OR s.id = 43188 OR s.id = 43189 OR s.id = 43191 OR s.id = 43192 OR s.id = 43193 OR s.id = 43194 OR s.id = 43195 OR s.id = 43196 OR s.id = 43197 OR s.id = 43198 OR s.id = 43199 OR s.id = 45344 OR s.id = 45706 OR s.id = 45890 OR s.id = 57125 OR s.id = 57822 OR s.id = 57835 OR s.id = 58144 OR s.id = 58150 OR s.id = 58385 OR s.id = 58386 OR s.id = 58387 OR s.id = 58388 OR s.id = 58390 OR s.id = 58391 OR s.id = 58392 OR s.id = 58393 OR s.id = 58394 OR s.id = 58395 OR s.id = 58397 OR s.id = 58398 OR s.id = 58399 OR s.id = 58400 OR s.id = 58785 OR s.id = 61349 OR s.id = 61564 OR s.id = 62175 OR s.id = 62284 OR s.id = 62340 OR s.id = 73426 OR s.id = 74362 OR s.id = 74460 OR s.id = 74826 OR s.id = 74835 OR s.id = 74842 OR s.id = 74851 OR s.id = 75850 OR s.id = 75854 OR s.id = 76050 OR s.id = 76057 OR s.id = 76101 OR s.id = 76106 OR s.id = 76893 OR s.id = 76897 OR s.id = 76915 OR s.id = 76918 OR s.id = 76919 OR s.id = 76920 OR s.id = 76921 OR s.id = 76922 OR s.id = 76923 OR s.id = 76924 OR s.id = 78444 OR s.id = 78557 OR s.id = 78631 OR s.id = 78632 OR s.id = 78677 OR s.id = 90158 OR s.id = 90161 OR s.id = 90270 OR s.id = 90680 OR s.id = 91068 OR s.id = 91075 OR s.id = 91126 OR s.id = 91131 OR s.id = 91569 OR s.id = 91538 OR s.id = 91541 OR s.id = 91550 OR s.id = 91554 OR s.id = 91558 OR s.id = 91560 OR s.id = 91570 OR s.id = 91571 OR s.id = 91572 OR s.id = 91573 OR s.id = 91574 OR s.id = 91575 OR s.id = 91576 OR s.id = 91577 OR s.id = 92063 OR s.id = 94631 OR s.id = 94648 OR s.id = 94676 OR s.id = 94697 OR s.id = 105378 OR s.id = 105387 OR s.id = 105745 OR s.id = 105751 OR s.id = 106174 OR s.id = 106181 OR s.id = 106299 OR s.id = 106383 OR s.id = 106390 OR s.id = 107381 OR s.id = 107390 OR s.id = 107392 OR s.id = 107393 OR s.id = 107394 OR s.id = 107395 OR s.id = 107396 OR s.id = 107397 OR s.id = 107398 OR s.id = 110132 OR s.id = 110128 OR s.id = 110130 OR s.id = 110131 OR s.id = 110151 OR s.id = 110577 OR s.id = 110578 OR s.id = 110689 OR s.id = 110759 OR s.id = 110760 OR s.id = 110779) and (se.id is null OR se.id = 0) group by s.id, s.start_time, s.end_time, s.in_conference, s.title, venue, type, status, pre_article, post_article, box_article having instr(team_ids, '|1059|') > 0 order by s.start_time

Sports Calendar

Use the filter boxes to select your search criteria (Conference, Sport, League, etc.) and click on the Enter button to return your results.
(Δ)
= League Game
Visitor Home Time/Score Location
NO GAMES HAVE BEEN ENTERED YET FOR THIS SEASON. PLEASE USE THE DROP DOWN WINDOW ABOVE TO NAVIGATE TO A PREVIOUS SEASON.

Twitter

 

TERMS OF SERVICE   |   PRIVACY STATEMENT  | Copyright @ 2010 SportsCom Media LLC | .