CHANNELS:
IAAM
Home  | Sport Calendar  | Photos  | Videos
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-04-28' and s.start_time <= '2017-05-12 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 having instr(conferences, '|3|') > 0 and instr(genders, '|G|') > 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
Fri, Apr. 28th
Girls Varsity Softball
MODEL School Friends 3:45pm Friends
Girls Varsity Lacrosse
St. Tim's Concordia 4:00pm Concordia Prep (Balt. Lutheran)
(Δ)
Girls Varsity Lacrosse
Chapelgate Key 4:00pm Key School
(Δ)
Girls Varsity Lacrosse
Oldfields Seton Keough 4:00pm Seton Keough
(Δ)
Girls Varsity Softball
Annapolis Area Christian Bryn Mawr 4:00pm Bryn Mawr
(Δ)
Girls Varsity Softball
St. Vincent Pallotti Chapelgate 4:00pm Chap. Christian
(Δ)
Girls Varsity Softball
Cristo Rey Mount Carmel 4:00pm Mount Carmel
Girls Varsity Softball
Arch. Spalding McDonogh 4:15pm McDonogh
(Δ)
Girls Varsity Lacrosse
Mercy Friends 5:00pm Friends
(Δ)
Girls Varsity Lacrosse
Rockbridge Academy St. Vincent Pallotti 6:00pm Fairland Regional Park
Sat, Apr. 29th
Girls Varsity Lacrosse
IND Annapolis Area Christian 10:00am Annap. Area Christian
(Δ)
Girls Varsity Lacrosse
Glenelg Country Notre Dame Prep 12:00pm Notre Dame Prep
(Δ)
Girls Varsity Lacrosse
Dulaney John Carroll 12:00pm John Carroll
Girls Varsity Lacrosse
Marriotts Ridge McDonogh 1:00pm McDonogh
(Δ)
Mon, May. 1st
Girls Varsity Lacrosse
Severn Garrison Forest 4:00pm Garrison Forest
(Δ)
Girls Varsity Lacrosse
Gerstell Academy Roland Park Country 4:00pm Roland Park Country
Girls Varsity Lacrosse
Catholic High IND 4:00pm Northwest Park
Girls Varsity Lacrosse
Concordia St. Tim's 4:00pm St. Tim's
(Δ)
Girls Varsity Softball
Seton Keough Catholic High 4:00pm Herring Run Park
(Δ)
Girls Varsity Softball
Mount de Sales Catonsville 4:00pm Catonsville
Girls Varsity Softball
St. John's Catholic Prep Bryn Mawr 4:00pm Bryn Mawr
(Δ)
Girls Varsity Softball
Mercy Chapelgate 4:00pm Chap. Christian
(Δ)
Girls Varsity Softball
Friends IND 4:00pm Druid Hill Park
(Δ)
Girls Varsity Softball
Beth Tfiloh Oldfields 4:00pm Oldfields
(Δ)
Girls Varsity Lacrosse
Maryvale Prep C. Milton Wright 5:30pm C.M. Wright
(Δ)
Tue, May. 2nd
Girls Varsity Lacrosse
IND Patterson Mill 3:45pm Patterson Mill
Girls Varsity Lacrosse
Arch. Spalding Mount de Sales 4:00pm Mount de Sales
(Δ)
Girls Varsity Lacrosse
St. Mary's Glenelg Country 4:00pm Glenelg Country
(Δ)
Girls Varsity Lacrosse
McDonogh John Carroll 4:00pm John Carroll
(Δ)
Girls Varsity Lacrosse
Roland Park Country Maryvale Prep 4:00pm Maryvale Prep
(Δ)
Girls Varsity Lacrosse
St. Paul's SfG Notre Dame Prep 4:00pm Notre Dame Prep
(Δ)
Girls Varsity Lacrosse
Mercy Indian Creek 4:00pm Indian Creek
(Δ)
Girls Varsity Lacrosse
Beth Tfiloh Chapelgate 4:00pm Chap. Christian
(Δ)
Girls Varsity Lacrosse
Catholic High Beth Tfiloh 4:00pm Beth Tfiloh
(Δ)
Girls Varsity Lacrosse
Concordia Oldfields 4:00pm Oldfields
(Δ)
Girls Varsity Lacrosse
Mount Carmel Chapelgate 4:00pm Chapelgate Christian
(Δ)
Girls Varsity Lacrosse
St. Tim's St. Vincent Pallotti 4:00pm Fairland Regional Park
(Δ)
Girls Varsity Softball
Century McDonogh 4:00pm McDonogh
Girls Varsity Softball
Spencerville Mount Carmel 4:00pm Mount Carmel
Girls Varsity Lacrosse
St. John's Catholic Prep Annapolis Area Christian 4:15pm Annap. Area Christian
(Δ)
Girls Varsity Lacrosse
Park Friends 4:15pm Friends
(Δ)
Girls Varsity Softball
IND Annapolis Area Christian 4:15pm Annap. Area Christian
Wed, May. 3rd
Girls Varsity Softball
Mount de Sales Arch. Spalding 4:00pm Archbishop Spalding
(Δ)
Girls Varsity Lacrosse
Bryn Mawr Garrison Forest 4:00pm Garrison Forest
(Δ)
Girls Varsity Lacrosse
Queen Anne's Severn 4:00pm Severn
Girls Varsity Lacrosse
Concordia Gerstell Academy 4:00pm Gerstell Academy
Girls Varsity Lacrosse
Chapelgate Oldfields 4:00pm Oldfields
(Δ)
Girls Varsity Softball
John Carroll Seton Keough 4:00pm Seton Keough
(Δ)
Girls Varsity Softball
Catholic High McDonogh 4:00pm McDonogh
(Δ)
Girls Varsity Softball
Bryn Mawr Chapelgate 4:00pm Chap. Christian
(Δ)
Girls Varsity Softball
St. Vincent Pallotti Maryvale Prep 4:00pm Maryvale Prep
(Δ)
Girls Varsity Softball
Roland Park Country Mercy 4:00pm Mercy
(Δ)
Girls Varsity Softball
St. Paul's SfG St. John's Catholic Prep 4:00pm St. John's Catholic Prep
(Δ)
Girls Varsity Softball
Cristo Rey Friends 4:00pm Friends
Thu, May. 4th
Girls Varsity Lacrosse
Park St. John's Catholic Prep 4:00pm St. John's Catholic Prep
(Δ)
Girls Varsity Lacrosse
IND Friends 4:00pm Friends
(Δ)
Girls Varsity Lacrosse
Brookewood St. Vincent Pallotti 4:00pm Fairland Regional Park
Girls Varsity Softball
Mercy Notre Dame Prep 4:00pm Notre Dame Prep
(Δ)
Girls Varsity Lacrosse
Mercy Annapolis Area Christian 4:15pm Annap. Area Christian
(Δ)
Girls Varsity Lacrosse
McDonogh Century 6:30pm Century
Fri, May. 5th
Girls Varsity Lacrosse
St. John's Catholic Prep Indian Creek 4:00pm Indian Creek
(Δ)
Girls Varsity Lacrosse
St. John's Catholic Prep Mercersburg (PA) 4:00pm Mercersburg (PA)
Girls Varsity Softball
Harford Tech John Carroll 4:00pm John Carroll
Girls Varsity Softball
Mount de Sales Lansdowne 4:00pm Lansdowne
Girls Varsity Softball
Roland Park Country Liberty 4:00pm Liberty
Girls Varsity Softball
Spalding JV Mount Carmel 4:00pm Mount Carmel
Girls Varsity Softball
St. Tim's Annapolis Area Christian 4:15pm Annap. Area Christian

IAAM SPORTS

    

75the_300x100
Twitter

 

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