CHANNELS:
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.start_time >= '2017-03-30' and s.start_time <= '2017-03-30 23:59:59' group by s.id, s.start_time, s.end_time, s.in_conference, s.title, venue, type, status, pre_article, post_article, box_article 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
Thu, Mar. 30th
Boys Varsity Lacrosse
Loyola Malvern Prep (PA) TBA Malvern Prep
Boys Varsity Golf
Loyola Mount St. Joseph 2:45pm Rolling Road Golf Club
(Δ)
Boys Junior Varsity Golf
Loyola Mount St. Joseph 3:15pm Rolling Road Golf Club
(Δ)
Boys Varsity Golf
McDonogh Calvert Hall 3:15pm Country Club of Maryland
(Δ)
Boys Varsity Golf
Saints Peter & Paul St. Mary's 3:15pm Old South Country Club
(Δ)
Boys Varsity Baseball
Gilman Loyola 3:30pm Loyola Blakefield
(Δ)
Boys Varsity Baseball
Patterson Joppatowne 3:30pm Joppatowne
Girls Varsity Lacrosse
Joppatowne North East - Cecil 3:30pm North East
(Δ)
Girls Varsity Lacrosse
Aberdeen Bo Manor 3:30pm Bo Manor
(Δ)
Girls Varsity Softball
Patterson Joppatowne 3:30pm Joppatowne
Boys Junior Varsity Tennis
Severn Loyola 3:45pm Loyola Blakefield
(Δ)
Boys Junior Varsity Tennis
Boys' Latin Mount St. Joseph 3:45pm Mount St. Joe
(Δ)
Boys Junior Varsity Tennis
Calvert Hall St. Paul's 3:45pm St. Paul's
(Δ)
Girls Varsity Lacrosse
Digital Harbor City 3:45pm City College
(Δ)
Girls Varsity Lacrosse
Western Poly 3:45pm Poly
(Δ)
Girls Varsity Lacrosse
Patterson Dunbar 3:45pm Dunbar
(Δ)
Girls Varsity Lacrosse
Mervo Edmondson-West. 3:45pm Edmondson-West.
(Δ)
Girls Varsity Lacrosse
St. Mary's Arch. Spalding 4:00pm Archbishop Spalding
(Δ)
Boys Varsity Baseball
Beth Tfiloh Gerstell Academy 4:00pm Gerstell Academy
(Δ)
Boys Varsity Baseball
Mount St. Joseph Arch. Curley 4:00pm Archbishop Curley
(Δ)
Boys Junior Varsity Baseball
Arch. Curley Mount St. Joseph 4:00pm Mount St. Joe
(Δ)
Boys Freshmen Lacrosse
Manchester Valley Mount St. Joseph 4:00pm Mount St. Joe
Boys Varsity Baseball
Calvert Hall St. Paul's 4:00pm St. Paul's
(Δ)
Boys Junior Varsity Baseball
St. John's (DC) St. Mary's 4:00pm Bestgate Park
Boys Varsity Lacrosse
Chestnut Hill (PA) Arch. Curley 4:00pm Archbishop Curley
Boys Varsity Tennis
Saints Peter & Paul Key 4:00pm Mears Marina Swim & Tennis Club
(Δ)
Boys Junior Varsity Baseball
John Carroll Arch. Spalding 4:00pm Archbishop Spalding
(Δ)
Boys Varsity Tennis
Friends Arch. Spalding 4:00pm Crofton Swim & Tennis Club
Boys Varsity Tennis
St. John's Catholic Prep St. Vincent Pallotti 4:00pm McCullough Field
(Δ)
Boys Varsity Lacrosse
Beth Tfiloh Mount Carmel 4:00pm Mount Carmel
(Δ)
Boys Varsity Tennis
Beth Tfiloh Severn 4:00pm Sawmill Creek Park
(Δ)
Girls Varsity Lacrosse
McDonogh Bryn Mawr 4:00pm Bryn Mawr
(Δ)
Girls Varsity Lacrosse
Glenelg Country Garrison Forest 4:00pm Garrison Forest
(Δ)
Girls Varsity Lacrosse
Severn Maryvale Prep 4:00pm Maryvale Prep
(Δ)
Girls Varsity Lacrosse
Notre Dame Prep Mount de Sales 4:00pm Mount de Sales
(Δ)
Girls Varsity Lacrosse
St. Paul's SfG Roland Park Country 4:00pm Roland Park Country
(Δ)
Girls Varsity Lacrosse
Friends Mercy 4:00pm Mercy
(Δ)
Girls Varsity Lacrosse
Park Fellowship of Christian Athletes 4:00pm
Girls Varsity Lacrosse
St. Vincent Pallotti Beth Tfiloh 4:00pm Beth Tfiloh
(Δ)
Girls Varsity Lacrosse
Seton Keough Catholic High 4:00pm Herring Run Park
(Δ)
Girls Varsity Lacrosse
St. Tim's Chapelgate 4:00pm Chap. Christian
(Δ)
Girls Varsity Lacrosse
Oldfields Key 4:00pm Key School
(Δ)
Boys Varsity Lacrosse
Northwestern Bluford Drew Jemison 4:00pm
(Δ)
Boys Varsity Lacrosse
Carver Vo-Tech Douglass 4:00pm Douglass-BC
(Δ)
Boys Varsity Lacrosse
City Dunbar 4:00pm Dunbar
(Δ)
Boys Varsity Lacrosse
Digital Harbor National Academy 4:00pm National Academy Foundation
(Δ)
Boys Varsity Lacrosse
Reginald Lewis Patterson 4:00pm Patterson
(Δ)
Boys Varsity Lacrosse
Mervo Lake Clifton 4:00pm Lake Clifton
(Δ)
Boys Varsity Lacrosse
Poly Edmondson-West. 4:00pm Edmondson-West.
(Δ)
Girls Varsity Softball
Perry Hall Catonsville 4:00pm Catonsville
(Δ)
Girls Varsity Softball
Milford Mill Carver A&T 4:00pm Carver A&T
(Δ)
Girls Varsity Softball
Dulaney Patapsco 4:00pm Patapsco
(Δ)
Girls Varsity Softball
Eastern Tech Sparrows Point 4:00pm Sparrows Point
(Δ)
Girls Varsity Softball
Franklin Loch Raven 4:00pm Loch Raven
(Δ)
Girls Varsity Softball
Parkville Kenwood 4:00pm Kenwood
(Δ)
Girls Varsity Softball
Towson Western Tech 4:00pm Catonsville Middle School
(Δ)
Girls Varsity Softball
Chesapeake - BC Owings Mills 4:00pm Owings Mills
(Δ)
Girls Varsity Softball
Dundalk New Town 4:00pm New Town
(Δ)
Girls Varsity Softball
Overlea Woodlawn 4:00pm Woodlawn
(Δ)
Girls Varsity Softball
Randallstown Pikesville 4:00pm Pikesville
(Δ)
Girls Varsity Softball
Long Reach River Hill 4:00pm River Hill
(Δ)
Boys Varsity Baseball
Arch. Spalding John Carroll 4:15pm John Carroll
(Δ)
Boys Varsity Baseball
Glenelg Country Friends 4:15pm Medfield Heights Elem
(Δ)
Boys Varsity Baseball
Severn Park 4:15pm Park School Sugar Campus
(Δ)
Boys Varsity Baseball
Mount Carmel Boys' Latin 4:15pm Boys' Latin
(Δ)
Boys Varsity Lacrosse
Culver Academy (IN) St. Paul's 4:15pm St. Paul's
Boys Junior Varsity Lacrosse
Gonzaga St. Paul's 4:15pm St. Paul's
Boys Junior Varsity Lacrosse
Good Counsel Gilman 4:15pm Gilman
Boys Freshmen Lacrosse
Gilman McDonogh 4:15pm McDonogh
Boys Junior Varsity Tennis
Friends McDonogh 4:15pm McDonogh
(Δ)
Boys Junior Varsity Tennis
Gilman Beth Tfiloh 4:15pm Woodholme Country Club
Boys Varsity Baseball
St. Mary's McDonogh 4:30pm McDonogh
(Δ)
Boys Junior Varsity Baseball
Loyola Gilman 4:30pm Gilman
(Δ)
Boys Varsity Lacrosse
Manchester Valley High School Saint Maria Goretti Boys Varsity Lacrosse 4:30pm
Boys Varsity Baseball
South Carroll Winters Mill 4:30pm Winters Mill
(Δ)
Boys Varsity Lacrosse
Marriotts Ridge Atholton 5:30pm Atholton
(Δ)
Girls Varsity Lacrosse
Atholton Marriotts Ridge 5:30pm Marriotts Ridge
(Δ)
Girls Varsity Softball
Harford Tech North Harford 5:30pm North Harford
Boys Varsity Lacrosse
Liberty South Hagerstown Boys Varsity Lacrosse 6:00pm South Hagerstown
Girls Varsity Lacrosse
John Carroll Manchester Valley High School 6:15pm Manchester Valley
Girls Varsity Lacrosse
C. Milton Wright Winters Mill 6:15pm Winters Mill
Boys Varsity Lacrosse
North Hagerstown Boys Varsity Lacrosse South Carroll 6:45pm South Carroll
Girls Varsity Lacrosse
South Carroll North Hagerstown Girls Varsity Lacrosse 6:45pm North Hagerstown
Girls Varsity Lacrosse
C. Milton Wright Perryville 6:45pm Perryville
(Δ)
Girls Varsity Lacrosse
Fallston Patterson Mill 6:45pm Patterson Mill
(Δ)
Girls Varsity Lacrosse
North Harford Harford Tech 6:45pm Harford Tech
(Δ)
Girls Varsity Lacrosse
Elkton Havre de Grace 6:45pm Havre de Grace
(Δ)
Girls Varsity Lacrosse
Edgewood Rising Sun 7:00pm Rising Sun
(Δ)

Twitter

 

TERMS OF SERVICE   |   PRIVACY STATEMENT  | Copyright @ 2010 SportsCom Media LLC | Web site development by Tekfort LLC