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-01-18' and s.start_time <= '2017-01-18 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
Wed, Jan. 18th
Boys Freshmen Basketball
Boys' Latin Arch. Spalding 3:30pm Archbishop Spalding
Boys Varsity Wrestling
Poly Dunbar 3:45pm Dunbar
(Δ)
Boys Varsity Wrestling
Dulaney Poly 3:45pm Dunbar
Boys Varsity Wrestling
Dulaney Dunbar 3:45pm Dunbar
Boys Varsity Wrestling
National Academy Carver Vo-Tech 3:45pm Carver Vo-Tech
(Δ)
Boys Varsity Wrestling
City Digital Harbor 3:45pm Digital Harbor
(Δ)
Boys Varsity Wrestling
Northwestern Edmondson-West. 3:45pm Edmondson-West.
(Δ)
Boys Varsity Wrestling
Douglass Ben Franklin 3:45pm Ben Franklin High School
(Δ)
Boys Varsity Wrestling
Lake Clifton Patterson 3:45pm Patterson
(Δ)
Girls Varsity Basketball
Arch. Spalding St. Vincent Pallotti 4:00pm Pallotti
(Δ)
Boys Varsity Wrestling
Mount St. Joseph Gilman 4:00pm Gilman
(Δ)
Boys Varsity Wrestling
Arch. Curley Mount St. Joseph 4:00pm Gilman
(Δ)
Boys Varsity Wrestling
Arch. Curley Gilman 4:00pm Gilman
(Δ)
Boys Varsity Wrestling
McDonogh Loyola 4:00pm Loyola Blakefield
(Δ)
Boys Varsity Wrestling
Boys' Latin Loyola 4:00pm Loyola Blakefield
(Δ)
Boys Junior Varsity Basketball
St. Vincent Pallotti Wilson 4:00pm
Boys Varsity Basketball
New Town Milford Mill 4:00pm Milford Mill
(Δ)
Boys Junior Varsity Wrestling
Mount St. Joseph Gilman 4:00pm Gilman
(Δ)
Boys Junior Varsity Wrestling
Arch. Curley Gilman 4:00pm Gilman
(Δ)
Boys Varsity Wrestling
Arch. Spalding John Carroll 4:00pm John Carroll
(Δ)
Boys Junior Varsity Wrestling
Arch. Spalding John Carroll 4:00pm John Carroll
(Δ)
Boys Varsity Wrestling
St. Paul's John Carroll 4:00pm John Carroll
(Δ)
Boys Varsity Wrestling
Jemicy School Severn 4:00pm Severn
(Δ)
Girls Varsity Basketball
Concordia Park 4:00pm Park School
(Δ)
Boys Varsity Wrestling
Perry Hall Bel Air 4:00pm Bel Air
Boys Varsity Wrestling
Manchester Valley High School Perry Hall 4:00pm Bel Air
Boys Varsity Wrestling
Manchester Valley High School Bel Air 4:00pm Bel Air
Boys Varsity Wrestling
Manchester Valley High School Perry Hall 4:00pm Bel Air
Girls Varsity Basketball
Garrison Forest Bryn Mawr 4:00pm Bryn Mawr
(Δ)
Boys Varsity Wrestling
Havre de Grace John Carroll 4:00pm John Carroll
Boys Varsity Wrestling
Arch. Spalding Havre de Grace 4:00pm John Carroll
Boys Varsity Wrestling
St. Paul's Havre de Grace 4:00pm John Carroll
Boys Freshmen Basketball
Mount St. Joseph McDonogh 4:15pm McDonogh
(Δ)
Boys Junior Varsity Basketball
Mount St. Joseph McDonogh 4:15pm McDonogh
(Δ)
Boys Junior Varsity Basketball
St. Maria Goretti Mount Carmel 4:15pm John Carroll
(Δ)
Boys Varsity Wrestling
North Harford Westminster 4:15pm Westminster
Boys Varsity Wrestling
Oakdale Westminster 4:15pm Westminster
Boys Varsity Wrestling
North Harford Oakdale 4:15pm Westminster
Boys Varsity Ice Hockey
Glenelg Country Loyola 4:30pm Reisterstown Sportsplex
(Δ)
Boys Junior Varsity Wrestling
Mount St. Joseph Arch. Curley 4:30pm Gilman
(Δ)
Boys Varsity Basketball
Southwestern Joppatowne 5:00pm Joppatowne
Boys Varsity Basketball
Pikesville Owings Mills 5:00pm Owings Mills
(Δ)
Boys Junior Varsity Wrestling
McDonogh Loyola 5:00pm Loyola Blakefield
(Δ)
Boys Junior Varsity Basketball
Glenelg Country St. Frances 5:15pm St. Frances
(Δ)
Boys Junior Varsity Basketball
Boys' Latin Arch. Spalding 5:15pm Archbishop Spalding
(Δ)
Boys Varsity Basketball
Woodlawn Randallstown 5:15pm Randallstown
(Δ)
Boys Varsity Basketball
FAET Lake Clifton 5:15pm Lake Clifton
Boys Varsity Basketball
Bluford Drew Jemison Coppin Academy 5:15pm Coppin Academy
Boys Junior Varsity Squash
Boys' Latin Loyola 5:30pm Bare Hills Club
(Δ)
Boys Varsity Squash
Boys' Latin Loyola 5:30pm Bare Hills Club
(Δ)
Girls Varsity Basketball
St. Frances John Carroll 5:30pm John Carroll
(Δ)
Girls Varsity Basketball
McDonogh Roland Park Country 5:30pm Roland Park Country
(Δ)
Girls Varsity Basketball
North County Key 5:30pm Key School
Boys Varsity Basketball
Hammond Atholton 5:30pm Atholton
(Δ)
Boys Varsity Basketball
River Hill Centennial 5:30pm Centennial
(Δ)
Boys Varsity Basketball
Glenelg Reservoir 5:30pm Reservoir
(Δ)
Boys Varsity Basketball
Wilde Lake Howard 5:30pm Howard
(Δ)
Boys Varsity Basketball
Marriotts Ridge Long Reach 5:30pm Long Reach
(Δ)
Boys Varsity Basketball
Oakland Mills Mount Hebron 5:30pm Mount Hebron
(Δ)
Girls Varsity Basketball
Atholton Hammond 5:30pm Hammond
(Δ)
Girls Varsity Basketball
Centennial River Hill 5:30pm River Hill
(Δ)
Girls Varsity Basketball
Reservoir Glenelg 5:30pm Glenelg
(Δ)
Girls Varsity Basketball
Mount Hebron Oakland Mills 5:30pm Oakland Mills
(Δ)
Girls Varsity Basketball
Long Reach Marriotts Ridge 5:30pm Marriotts Ridge
(Δ)
Girls Varsity Basketball
Howard Wilde Lake 5:30pm Wilde Lake
(Δ)
Boys Varsity Basketball
Carver A&T Loch Raven 5:30pm Loch Raven
(Δ)
Boys Varsity Basketball
Dulaney Hereford 5:30pm Hereford
(Δ)
Boys Varsity Basketball
Dundalk Patapsco 5:30pm Patapsco
(Δ)
Boys Varsity Basketball
Sparrows Point Parkville 5:30pm Parkville
(Δ)
Boys Varsity Basketball
Chesapeake - BC Kenwood 5:30pm Kenwood
(Δ)
Boys Varsity Basketball
Catonsville Western Tech 5:30pm Western-Tech
(Δ)
Boys Varsity Basketball
Lansdowne Eastern Tech 5:30pm Eastern Tech
(Δ)
Boys Varsity Basketball
Overlea Franklin 5:30pm Franklin
(Δ)
Boys Varsity Basketball
Perry Hall Towson 5:30pm Towson
(Δ)
Boys Varsity Wrestling
Arch. Spalding St. Paul's 5:30pm John Carroll
(Δ)
Girls Varsity Basketball
Loch Raven Carver A&T 5:30pm Carver A&T
(Δ)
Girls Varsity Basketball
Hereford Dulaney 5:30pm Dulaney
(Δ)
Girls Varsity Basketball
Milford Mill New Town 5:30pm New Town
(Δ)
Girls Varsity Basketball
Maryvale Prep Glenelg Country 5:30pm Glenelg Country
(Δ)
Girls Varsity Basketball
St. Tim's St. John's Catholic Prep 5:30pm St. John's Catholic Prep
(Δ)
Girls Varsity Basketball
St. Mary's St. Paul's SfG 5:30pm St. Paul's SFG
(Δ)
Girls Varsity Basketball
Owings Mills Pikesville 5:30pm Pikesville
(Δ)
Girls Varsity Basketball
Parkville Sparrows Point 5:30pm Sparrows Point
(Δ)
Girls Varsity Basketball
Kenwood Chesapeake - BC 5:30pm Chesapeake-BC
(Δ)
Girls Varsity Basketball
Catholic High Oldfields 5:30pm Oldfields
(Δ)
Girls Varsity Basketball
Western Tech Catonsville 5:30pm Catonsville
(Δ)
Girls Varsity Basketball
Eastern Tech Lansdowne 5:30pm Lansdowne
(Δ)
Girls Varsity Basketball
Franklin Overlea 5:30pm Overlea
(Δ)
Girls Varsity Basketball
Towson Perry Hall 5:30pm Perry Hall
(Δ)
Boys Varsity Wrestling
Aberdeen Fallston 5:30pm Fallston
(Δ)
Boys Varsity Wrestling
Edgewood C. Milton Wright 5:30pm C.M. Wright
(Δ)
Boys Varsity Wrestling
Harford Tech North East - Cecil 5:30pm North East
(Δ)
Boys Varsity Wrestling
Patterson Mill Bo Manor 5:30pm Bo Manor
(Δ)
Boys Varsity Wrestling
Rising Sun Elkton 5:30pm Elkton
(Δ)
Boys Varsity Basketball
Mount St. Joseph McDonogh 6:00pm McDonogh
(Δ)
Boys Varsity Wrestling
Winters Mill Francis Scott Key 6:00pm Francis Scott Key
(Δ)
Boys Varsity Wrestling
South Carroll Middletown 6:00pm Middletown
Boys Varsity Basketball
St. Maria Goretti Mount Carmel 6:00pm Mount Carmel
(Δ)
Boys Varsity Wrestling
McDonogh Boys' Latin 6:30pm Loyola Blakefield
(Δ)
Boys Varsity Basketball
Bel Air North Harford 6:45pm North Harford
(Δ)
Boys Varsity Basketball
Boys' Latin Arch. Spalding 7:00pm Archbishop Spalding
(Δ)
Boys Varsity Basketball
Glenelg Country St. Frances 7:00pm St. Frances
(Δ)
Boys Varsity Basketball
Liberty Walkersville 7:00pm Walkersville
Girls Varsity Basketball
Walkersville Liberty 7:00pm Liberty
Boys Varsity Wrestling
North County Old Mill 7:00pm Old Mill
(Δ)

Twitter

 

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