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 >= '2016-04-28' and s.start_time <= '2016-04-28 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, Apr. 28th
Girls Varsity Softball
Mervo FAET 4:45am FAET
Girls Varsity Softball
KASA Western 2:30pm Western
Girls Varsity Softball
ACCE New Era 2:30pm New Era Academy
Girls Varsity Softball
Maritime City 2:30pm City College
Girls Varsity Softball
Dunbar Northwestern 2:30pm Northwestern
Girls Varsity Softball
Mervo FAET 2:30pm FAET
Girls Varsity Softball
Carver Vo-Tech Patterson 2:30pm Patterson
Girls Varsity Softball
Edmondson-West. Southwestern 2:30pm Southwestern
Girls Varsity Softball
Forest Park Lake Clifton 2:30pm Lake Clifton
Boys Varsity Golf
Calvert Hall Gilman 3:15pm Elkridge Club
(Δ)
Boys Varsity Golf
Chapelgate St. Vincent Pallotti 3:15pm Gunpowder Falls Golf Club
(Δ)
Boys Varsity Golf
Severn Boys' Latin 3:15pm Suburban Country Club
(Δ)
Boys Varsity Golf
Severn Georgetown Prep 3:15pm
Boys Varsity Baseball
Boys' Latin Friends 3:30pm Medfield Heights Elem
(Δ)
Boys Varsity Baseball
Milford Mill Carver A&T 3:30pm Milford Mill
(Δ)
Boys Varsity Baseball
Gerstell Academy Concordia 3:30pm Concordia Prep (Balt. Lutheran)
(Δ)
Boys Varsity Baseball
Severn Annapolis Area Christian 3:30pm Annap. Area Christian
(Δ)
Girls Varsity Lacrosse
Joppatowne Rising Sun 3:30pm Rising Sun
(Δ)
Boys Varsity Golf
Arch. Curley Glenelg Country 3:30pm Glen Dale
(Δ)
Boys Varsity Tennis
Arch. Curley Arch. Spalding 3:30pm Crofton Country Club
(Δ)
Girls Varsity Softball
Ben Franklin Reginald Lewis 3:30pm Reginald Lewis
Boys Varsity Tennis
St. Paul's Loyola 3:45pm Loyola Blakefield
(Δ)
Boys Varsity Lacrosse
Randallstown New Town 3:45pm New Town
Boys Varsity Baseball
Franklin Catonsville 3:45pm Catonsville
(Δ)
Boys Varsity Baseball
Dundalk Parkville 3:45pm Parkville
(Δ)
Boys Varsity Baseball
Chesapeake - BC Woodlawn 3:45pm Woodlawn
(Δ)
Boys Varsity Tennis
Calvert Hall Gilman 3:45pm Gilman
(Δ)
Boys Junior Varsity Golf
Gilman Calvert Hall 3:45pm Calvert Hall
(Δ)
Boys Varsity Baseball
Eastern Tech Dulaney 3:45pm
Postponed
Game suspended in the 4th inning...
Dulaney
(Δ)
Boys Varsity Baseball
Dulaney Eastern Tech 3:45pm Eastern Tech
(Δ)
Boys Varsity Baseball
Hereford Towson 3:45pm Towson
(Δ)
Boys Varsity Baseball
Perry Hall Loch Raven 3:45pm Loch Raven
(Δ)
Boys Varsity Baseball
Kenwood Sparrows Point 3:45pm Sparrows Point
(Δ)
Boys Varsity Baseball
Owings Mills Lansdowne 3:45pm Lansdowne
(Δ)
Boys Varsity Baseball
Patapsco Pikesville 3:45pm Pikesville
(Δ)
Boys Varsity Baseball
Western Tech New Town 3:45pm New Town
(Δ)
Boys Varsity Baseball
Randallstown Overlea 3:45pm Overlea
(Δ)
Boys Varsity Tennis
McDonogh Mount St. Joseph 3:45pm Andover Rec Center
(Δ)
Girls Varsity Softball
St. John's Catholic Prep Friends 3:45pm Friends
(Δ)
Girls Varsity Lacrosse
Patapsco Sparrows Point 3:45pm Sparrows Point
Girls Varsity Lacrosse
City Western 3:45pm Western
(Δ)
Boys Varsity Lacrosse
Mervo Edmondson-West. 3:45pm Edmondson-West.
(Δ)
Girls Varsity Lacrosse
Mervo Edmondson-West. 3:45pm Edmondson-West.
(Δ)
Girls Varsity Softball
Ben Franklin Reginald Lewis 3:45pm Reginald Lewis
Girls Varsity Lacrosse
Digital Harbor Poly 3:45pm Poly
(Δ)
Boys Junior Varsity Lacrosse
Mount St. Joseph Arch. Spalding 4:00pm Archbishop Spalding
(Δ)
Boys Junior Varsity Baseball
Arch. Spalding McDonogh 4:00pm McDonogh
(Δ)
Boys Junior Varsity Lacrosse
Loyola Boys' Latin 4:00pm Boys' Latin
(Δ)
Boys Junior Varsity Lacrosse
St. John's Catholic Prep John Carroll 4:00pm John Carroll
(Δ)
Girls Varsity Lacrosse
Catholic High Gerstell Academy 4:00pm Gerstell Academy
Boys JV B Baseball
Boys' Latin Arch. Curley 4:00pm Archbishop Curley
(Δ)
Boys Junior Varsity Lacrosse
Gilman St. Paul's 4:00pm St. Paul's
(Δ)
Boys Junior Varsity Lacrosse
Calvert Hall Severn 4:00pm Severn
(Δ)
Girls Varsity Softball
Catholic High Arch. Spalding 4:00pm Archbishop Spalding
(Δ)
Girls Varsity Softball
John Carroll Mount de Sales 4:00pm Mount de Sales
(Δ)
Girls Varsity Softball
McDonogh Notre Dame Prep 4:00pm Notre Dame Prep
(Δ)
Girls Varsity Softball
Mercy Seton Keough 4:00pm Seton Keough
(Δ)
Boys Varsity Tennis
Glenelg Country Severn 4:00pm Sawmill Creek Park
(Δ)
Boys Junior Varsity Tennis
Boys' Latin St. Paul's 4:00pm St. Paul's
(Δ)
Boys Junior Varsity Lacrosse
Annapolis Area Christian Friends 4:00pm Friends
Boys Varsity Baseball
Chapelgate St. Frances 4:00pm
Postponed
Chapelgate Christian
(Δ)
Boys Varsity Baseball
Joppatowne West Nottingham 4:00pm West Nottingham Academy
Girls Varsity Softball
Chapelgate Annapolis Area Christian 4:00pm Annap. Area Christian
(Δ)
Girls Varsity Softball
Bryn Mawr St. Paul's SfG 4:00pm St. Paul's SFG
(Δ)
Girls Varsity Softball
Maryvale Prep Concordia 4:00pm Concordia Prep (Balt. Lutheran)
(Δ)
Girls Varsity Softball
Garrison Forest IND 4:00pm Druid Hill Park
(Δ)
Girls Varsity Softball
St. Tim's Park 4:00pm Park School
(Δ)
Girls Varsity Lacrosse
Loch Raven Kenwood 4:00pm Kenwood
Girls Varsity Softball
Parkville Towson 4:00pm Towson
(Δ)
Girls Varsity Softball
Mercy Concordia 4:00pm Concord High School
(Δ)
Boys Junior Varsity Lacrosse
St. Mary's McDonogh 4:15pm McDonogh
(Δ)
Boys Junior Varsity Baseball
Friends St. Paul's 4:15pm St. Paul's
(Δ)
Boys Varsity Tennis
Friends Boys' Latin 4:15pm Boys' Latin
(Δ)
Boys Varsity Tennis
St. John's Catholic Prep Annapolis Area Christian 4:15pm Annap. Area Christian
(Δ)
Boys Varsity Baseball
Glenelg Hammond 4:15pm Hammond
(Δ)
Boys JV B Baseball
Calvert Hall St. John's (DC) 4:30pm St. John's (DC)
Girls Varsity Softball
National Academy Digital Harbor 4:45pm Swann Park
Girls Varsity Softball
KASA Western 4:45pm Western
Girls Varsity Softball
ACCE New Era 4:45pm New Era Academy
Girls Varsity Softball
Maritime City 4:45pm City College
Girls Varsity Softball
Dunbar Northwestern 4:45pm Northwestern
Girls Varsity Softball
National Academy Digital Harbor 4:45pm Digital Harbor
Girls Varsity Softball
Carver Vo-Tech Patterson 4:45pm Patterson
Girls Varsity Softball
Poly Douglass 4:45pm Douglass-BC
Girls Varsity Softball
Edmondson-West. Southwestern 4:45pm Southwestern
Girls Varsity Softball
Forest Park Lake Clifton 4:45pm Lake Clifton
Boys Varsity Baseball
Carver A&T Milford Mill 5:00pm Milford Mill
(Δ)
Boys Varsity Lacrosse
Pikesville Catonsville 5:15pm Catonsville
Boys Varsity Lacrosse
Centennial Mount Hebron 5:30pm Mount Hebron
(Δ)
Girls Varsity Lacrosse
Mount Hebron Centennial 5:30pm Centennial
(Δ)
Boys Varsity Baseball
Friends Boys' Latin 5:30pm Friends
(Δ)
Boys Varsity Tennis
Key Indian Creek 5:45pm USNA
(Δ)
Boys Varsity Lacrosse
Loch Raven Kenwood 6:00pm Kenwood
Girls Varsity Lacrosse
Manchester Valley High School South Carroll 6:15pm South Carroll
(Δ)
Girls Varsity Lacrosse
Century North Carroll 6:30pm North Carroll
(Δ)
Boys Varsity Lacrosse
Francis Scott Key Westminster 6:30pm Westminster
(Δ)
Girls Varsity Lacrosse
Westminster Francis Scott Key 6:30pm Francis Scott Key
(Δ)
Girls Varsity Lacrosse
Winters Mill Liberty 6:30pm Liberty
(Δ)
Boys Varsity Lacrosse
North Carroll Century 6:45pm Century
(Δ)
Boys Varsity Lacrosse
Liberty Winters Mill 6:45pm Winters Mill
(Δ)
Boys Varsity Lacrosse
South Carroll Manchester Valley High School 6:45pm Manchester Valley
(Δ)
Boys Varsity Lacrosse
Rising Sun Joppatowne 6:45pm Joppatowne
(Δ)

Twitter

 

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