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-02-24' and s.start_time <= '2017-02-24 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
Fri, Feb. 24th
Boys Varsity Wrestling
National Preps Tournament
Arch. Curley
Arch. Spalding
Boys' Latin
Calvert Hall
Gilman
John Carroll
Loyola
McDonogh
Mount St. Joseph
Severn
St. Paul's
TBA Lehigh University
Boys Varsity Swimming
Eastern Swim & Dive Championships
Loyola
Mount St. Joseph
TBA
Boys Varsity Basketball
Boys Basketball 2A West Region Section II Quarterfinal
South Carroll Francis Scott Key TBA Francis Scott Key
Boys Varsity Basketball
Boys Basketball 2A West Region Section II Quarterfinal
Winters Mill Liberty TBA Liberty
Boys Varsity Basketball
Boys Basketball 2A South Region Section II Quarterfinal
Gwynn Park Southern TBA Southern
Boys Varsity Basketball
Boys Basketball 4A North Region Section II Quarterfinal
Digital Harbor Mervo TBA Mervo
Boys Varsity Basketball
Boys Basketball 4A North Region Section I Quarterfinal
Kenwood Catonsville TBA Catonsville
Boys Varsity Basketball
Boys Basketball 4A North Region Section I Quarterfinal
Bel Air Parkville TBA Parkville
Girls Varsity Basketball
Girls Basketball 1A North Region Section I Quarterfinal
Havre de Grace Joppatowne TBA Joppatowne
Girls Varsity Basketball
Girls Basketball 2A South Region Section II Quarterfinal
Southern Crossland TBA Crossland High School
Girls Varsity Basketball
Girls Basketball 2A North Region Section II Quarterfinal
Randallstown Hereford TBA Hereford
Girls Varsity Basketball
Girls Basketball 2A North Region Section II Quarterfinal
Western Tech New Town TBA New Town
Girls Varsity Lacrosse
Girls Basketball 2A North Region Section II Quarterfinal
Carver A&T Loch Raven TBA Loch Raven
Girls Varsity Basketball
Girls Basketball 2A North Region Section II Quarterfinal
Owings Mills Northwestern TBA Northwestern
Girls Varsity Basketball
Girls Basketball 2A North Region Section I Quarterfinal
Carver Vo-Tech Dunbar TBA Dunbar
Girls Varsity Basketball
Girls Basketball 2A North Region Section I Quarterfinal
Sparrows Point Eastern Tech TBA Eastern Tech
Girls Varsity Basketball
Girls Basketball 2A North Region Section I Quarterfinal
Patterson Lake Clifton TBA Lake Clifton
Girls Varsity Basketball
Girls Basketball 2A North Region Section I Quarterfinal
Overlea Chesapeake - BC TBA Chesapeake-BC
Girls Varsity Basketball
Girls Basketball 3A East Region Section II Quarterfinal
Northeast-AA Atholton TBA Atholton
Girls Varsity Basketball
Girls Basketball 3A East Region Section I Quarterfinal
Centennial Reservoir TBA Reservoir
Girls Varsity Basketball
Girls Basketball 4A North Region Section II Quarterfinal
Sherwood Mervo TBA Mervo
Girls Varsity Basketball
Girls Basketball 4A North Region Section I Quarterfinal
Kenwood Dulaney TBA Dulaney
Girls Varsity Basketball
Girls Basketball 4A East Region Section II Quarterfinal
Annapolis Leonardtown TBA Leonardtown HS
Girls Varsity Basketball
Girls Basketball 4A East Region Section II Quarterfinal
Broadneck South River TBA South River
Girls Varsity Basketball
Girls Basketball 4A East Region Section I Quarterfinal
Glen Burnie Arundel TBA Arundel
Boys Varsity Basketball
Boys Basketball 3A East Region Section II Quarterfinal
Atholton J.M Bennett 3:30pm James M. Bennett
Boys Varsity Basketball
Boys Basketball 1A South Region Section II Quarterfinal
Reginald Lewis FAET 3:45pm FAET
Boys Varsity Basketball
Boys Basketball 2A North Region Section I Quarterfinal
Eastern Tech Lake Clifton 4:00pm Lake Clifton
Girls Varsity Basketball
Girls Basketball 3A North Region Section I Quarterfinal
Douglass Poly 4:00pm Poly
Girls Varsity Basketball
Girls Basketball 3A North Region Section I Quarterfinal
Lansdowne City 4:00pm City College
Boys Varsity Basketball
Boys Basketball 1A South Region Section I Quarterfinal
Pikesville Ben Franklin 5:00pm BCCC
Boys Varsity Basketball
Boys Basketball 2A North Region Section II Quarterfinal
Northwestern Randallstown 5:00pm Randallstown
Boys Varsity Basketball
Boys Basketball 2A North Region Section I Quarterfinal
Chesapeake - BC Overlea 5:00pm Overlea
Boys Varsity Basketball
Boys Basketball 2A East Region Section I Quarterfinal
North East - Cecil Rising Sun 5:00pm Rising Sun
Boys Varsity Basketball
Boys Basketball 3A North Region Section I Quarterfinal
Douglass Franklin 5:00pm Franklin
Girls Varsity Basketball
Girls Basketball 1A South Region Section I Quarterfinal
National Academy Pikesville 5:00pm Pikesville
Girls Varsity Basketball
Girls Basketball 2A West Region Section I Quarterfinal
Liberty Oakland Mills 5:00pm Oakland Mills
Girls Varsity Basketball
Girls Basketball 3A North Region Section II Quarterfinal
North Harford C. Milton Wright 5:00pm C.M. Wright
Girls Varsity Basketball
Girls Basketball 3A North Region Section II Quarterfinal
Patapsco Edgewood 5:00pm Edgewood
Girls Varsity Basketball
Girls Basketball 3A North Region Section II Quarterfinal
Dundalk Towson 5:00pm Towson
Girls Varsity Basketball
Girls Basketball 3A East Region Section II Quarterfinal
Hammond J.M. Bennett 5:00pm James M. Bennett
Girls Varsity Basketball
Girls Basketball 3A East Region Section I Quarterfinal
Wilde Lake Glenelg 5:00pm Glenelg
Girls Varsity Basketball
Girls Basketball 3A East Region Section I Quarterfinal
River Hill Mount Hebron 5:00pm Mount Hebron
Boys Varsity Basketball
Boys Basketball 1A North Region Section I Quarterfinal
Patterson Mill Perryville 5:30pm Perryville
Boys Varsity Basketball
Boys Basketball 2A North Region Section I Quarterfinal
Carver Vo-Tech Dunbar 5:30pm Dunbar
Boys Varsity Basketball
Boys Basketball 2A North Region Section I Quarterfinal
Sparrows Point Patterson 5:30pm Patterson
Girls Varsity Basketball
Girls Basketball 2A West Region Section I Quarterfinal
Century Francis Scott Key 5:30pm Francis Scott Key
Girls Varsity Basketball
Girls Basketball 3A West Region Section I Quarterfinal
Westminster Oakdale 5:30pm Oakdale High School
Boys Varsity Basketball
Boys Basketball 1A South Region Section II Quarterfinal
KASA Bluford Drew Jemison 6:00pm Bluford Drew Jemison
Boys Varsity Basketball
Boys Basketball 2A North Region Section II Quarterfinal
Carver A&T Western Tech 6:00pm Western-Tech
Boys Varsity Basketball
Boys Basketball 3A North Region Section II Quarterfinal
Towson Aberdeen 6:00pm Aberdeen
Boys Varsity Basketball
Boys Basketball 4A East Region Section I Quarterfinal
Severna Park Glen Burnie 6:00pm Glen Burnie
Girls Varsity Basketball
Girls Basketball 2A West Region Section I Quarterfinal
South Carroll Winters Mill 6:00pm Winters Mill
Girls Varsity Basketball
Girls Basketball 4A North Region Section I Quarterfinal
Parkville Bel Air 6:00pm Bel Air
Girls Varsity Basketball
Girls Basketball 4A East Region Section I Quarterfinal
North County Meade 6:00pm Meade
Boys Varsity Basketball
Boys Basketball 2A North Region Section II Quarterfinal
Owings Mills Hereford 6:30pm Hereford
Boys Varsity Basketball
Boys Basketball 3A North Region Section II Quarterfinal
C. Milton Wright North Harford 6:30pm North Harford
Boys Varsity Basketball
Boys Basketball 4A East Region Section II Quarterfinal
South River Leonardtown 6:30pm Leonardtown HS
Girls Varsity Basketball
Girls Basketball 2A East Region Section I Quarterfinal
Fallston Rising Sun 6:30pm Rising Sun
Boys Varsity Basketball
Cesar Chavez St. Maria Goretti 7:00pm St. Maria Goretti
Boys Varsity Basketball
Boys Basketball 2A West Region Section II Quarterfinal
Marriotts Ridge Oakland Mills 7:00pm Oakland Mills
Boys Varsity Basketball
Boys Basketball 2A North Region Section II Quarterfinal
Loch Raven New Town 7:00pm New Town
Boys Varsity Basketball
Boys Basketball 3A West Region Section I Quarterfinal
Manchester Valley High School Westminster 7:00pm Westminster
Boys Varsity Basketball
Boys Basketball 3A North Region Section II Quarterfinal
Patapsco Edgewood 7:00pm Edgewood
Boys Varsity Basketball
Boys Basketball 3A East Region Section I Quarterfinal
Long Reach Reservoir 7:00pm Reservoir
Boys Varsity Basketball
Boys Basketball 3A East Region Section I Quarterfinal
Mount Hebron Centennial 7:00pm Centennial
Boys Varsity Basketball
Boys Basketball 3A East Region Section I Quarterfinal
Wilde Lake Glenelg 7:00pm Glenelg
Boys Varsity Basketball
Boys Basketball 4A East Region Section II Quarterfinal
Chopticon Broadneck 7:00pm Broadneck
Boys Varsity Basketball
Boys Basketball 4A East Region Section I Quarterfinal
North County Arundel 7:00pm Arundel
Boys Varsity Basketball
Boys Basketball 4A East Region Section I Quarterfinal
North County Arundel 7:00pm Arundel

Twitter

 

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