CHANNELS:
Calvert_Hall
Team News  |  Schedule  |  Roster  |  Photos  |  Videos
BOYS VARSITY BASEBALL
schedules[execute query]
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.id = 10588 OR s.id = 10701 OR s.id = 10712 OR s.id = 10714 OR s.id = 10715 OR s.id = 14303 OR s.id = 10717 OR s.id = 10718 OR s.id = 10719 OR s.id = 10836 OR s.id = 10837 OR s.id = 10838 OR s.id = 10839 OR s.id = 10840 OR s.id = 10841 OR s.id = 10842 OR s.id = 10843 OR s.id = 10844 OR s.id = 10845 OR s.id = 10846 OR s.id = 10847 OR s.id = 10848 OR s.id = 10849 OR s.id = 10850 OR s.id = 10851 OR s.id = 10852 OR s.id = 10853 OR s.id = 10855 OR s.id = 10856 OR s.id = 10858 OR s.id = 10860 OR s.id = 14304 OR s.id = 14305 OR s.id = 14306 OR s.id = 14648 OR s.id = 14889 OR s.id = 15013 OR s.id = 15045 OR s.id = 15044 OR s.id = 15067 OR s.id = 25473 OR s.id = 25474 OR s.id = 25475 OR s.id = 25476 OR s.id = 25477 OR s.id = 25479 OR s.id = 25480 OR s.id = 25481 OR s.id = 25482 OR s.id = 25483 OR s.id = 25484 OR s.id = 25486 OR s.id = 25487 OR s.id = 25488 OR s.id = 25489 OR s.id = 25490 OR s.id = 25491 OR s.id = 25492 OR s.id = 25493 OR s.id = 25494 OR s.id = 25495 OR s.id = 25496 OR s.id = 25497 OR s.id = 25498 OR s.id = 25499 OR s.id = 25500 OR s.id = 25502 OR s.id = 25503 OR s.id = 25504 OR s.id = 26375 OR s.id = 25485 OR s.id = 30196 OR s.id = 29889 OR s.id = 30210 OR s.id = 30209 OR s.id = 30285 OR s.id = 40543 OR s.id = 40558 OR s.id = 40718 OR s.id = 40728 OR s.id = 41117 OR s.id = 41123 OR s.id = 41685 OR s.id = 41692 OR s.id = 41792 OR s.id = 41798 OR s.id = 41809 OR s.id = 41817 OR s.id = 41823 OR s.id = 41828 OR s.id = 41833 OR s.id = 41834 OR s.id = 41836 OR s.id = 41837 OR s.id = 41838 OR s.id = 41839 OR s.id = 41840 OR s.id = 41841 OR s.id = 41842 OR s.id = 42474 OR s.id = 45366 OR s.id = 45383 OR s.id = 45384 OR s.id = 45703 OR s.id = 45878 OR s.id = 45995 OR s.id = 45994 OR s.id = 46036 OR s.id = 57504 OR s.id = 57516 OR s.id = 57586 OR s.id = 57600 OR s.id = 58064 OR s.id = 58074 OR s.id = 58112 OR s.id = 58119 OR s.id = 58131 OR s.id = 58137 OR s.id = 58177 OR s.id = 58178 OR s.id = 58369 OR s.id = 58436 OR s.id = 58471 OR s.id = 58473 OR s.id = 58512 OR s.id = 58513 OR s.id = 58514 OR s.id = 58515 OR s.id = 58516 OR s.id = 58517 OR s.id = 58518 OR s.id = 58519 OR s.id = 58520 OR s.id = 58525 OR s.id = 62093 OR s.id = 62096 OR s.id = 62251 OR s.id = 62310 OR s.id = 62311 OR s.id = 73285 OR s.id = 73294 OR s.id = 73541 OR s.id = 73556 OR s.id = 73839 OR s.id = 73849 OR s.id = 73861 OR s.id = 73869 OR s.id = 78108 OR s.id = 74869 OR s.id = 74870 OR s.id = 75196 OR s.id = 75207 OR s.id = 78021 OR s.id = 75799 OR s.id = 75801 OR s.id = 75802 OR s.id = 75803 OR s.id = 75804 OR s.id = 75806 OR s.id = 75807 OR s.id = 75808 OR s.id = 75809 OR s.id = 78256 OR s.id = 78680 OR s.id = 78018 OR s.id = 78085 OR s.id = 78086 OR s.id = 78100 OR s.id = 78421 OR s.id = 78585 OR s.id = 78679 OR s.id = 89102 OR s.id = 89111 OR s.id = 89637 OR s.id = 89647 OR s.id = 94101 OR s.id = 90675 OR s.id = 90681 OR s.id = 90716 OR s.id = 90728 OR s.id = 91096 OR s.id = 91104 OR s.id = 91144 OR s.id = 91145 OR s.id = 91146 OR s.id = 91147 OR s.id = 91148 OR s.id = 91149 OR s.id = 91150 OR s.id = 91151 OR s.id = 91152 OR s.id = 91153 OR s.id = 91154 OR s.id = 91155 OR s.id = 91801 OR s.id = 92056 OR s.id = 92354 OR s.id = 94516 OR s.id = 94633 OR s.id = 94643 OR s.id = 105186 OR s.id = 105197 OR s.id = 105216 OR s.id = 105223 OR s.id = 105440 OR s.id = 105454 OR s.id = 105697 OR s.id = 105704 OR s.id = 105860 OR s.id = 105871 OR s.id = 105877 OR s.id = 105878 OR s.id = 105879 OR s.id = 105880 OR s.id = 105881 OR s.id = 105882 OR s.id = 105884 OR s.id = 105885 OR s.id = 105886 OR s.id = 105887 OR s.id = 105888 OR s.id = 105889 OR s.id = 105890 OR s.id = 105891 OR s.id = 105893 OR s.id = 105894 OR s.id = 110142 OR s.id = 110552 OR s.id = 110653 OR s.id = 110682 OR s.id = 110724 OR s.id = 110725 OR s.id = 110780) and (se.id is null OR se.id = 12) 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(team_ids, '|903|') > 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, Mar. 10th
Boys Varsity Baseball
Boys' Latin Calvert Hall 4 - 7 Calvert Hall
Sun, Mar. 12th
Boys Varsity Baseball
Xavier (NY) Calvert Hall 12:00pm
Canceled
Calvert Hall
Sat, Mar. 18th
Boys Varsity Baseball
St. John's (DC) Calvert Hall 0 - 6 Calvert Hall
Mon, Mar. 20th
Boys Varsity Baseball
Gilman Calvert Hall 4 - 2 Calvert Hall
(Δ)
Tue, Mar. 21st
Boys Varsity Baseball
Bel Air Calvert Hall 1 - 5 Calvert Hall
Wed, Mar. 22nd
Boys Varsity Baseball
Calvert Hall Mount St. Joseph 6 - 4 Mount St. Joe
(Δ)
Fri, Mar. 24th
Boys Varsity Baseball
Calvert Hall Arch. Curley 7 - 1 Archbishop Curley
(Δ)
Sat, Mar. 25th
Boys Varsity Baseball
Ballston Spa (NY) Calvert Hall 3 - 9 Calvert Hall
Boys Varsity Baseball
Albany (NY) Calvert Hall 1 - 12 Calvert Hall
Tue, Mar. 28th
Boys Varsity Baseball
John Carroll Calvert Hall 0 - 4 Calvert Hall
(Δ)
Thu, Mar. 30th
Boys Varsity Baseball
Calvert Hall St. Paul's 13 - 3 St. Paul's
(Δ)
Sat, Apr. 1st
Boys Varsity Baseball
Calvert Hall Georgetown Prep 4 - 2 Georgetown Prep
Mon, Apr. 3rd
Boys Varsity Baseball
Loyola Calvert Hall 3 - 4 Calvert Hall
(Δ)
Wed, Apr. 5th
Boys Varsity Baseball
McDonogh Calvert Hall 6 - 16 Calvert Hall
(Δ)
Fri, Apr. 7th
Boys Varsity Baseball
St. Mary's Calvert Hall 0 - 5 Calvert Hall
(Δ)
Sat, Apr. 8th
Boys Varsity Baseball
St. Peter's (NY) Calvert Hall 3 - 10 Calvert Hall
Tue, Apr. 11th
Boys Varsity Baseball
Arch. Spalding Calvert Hall 7 - 2 Calvert Hall
(Δ)
Mon, Apr. 17th
Boys Varsity Baseball
Calvert Hall Gilman 15 - 7 Gilman
(Δ)
Wed, Apr. 19th
Boys Varsity Baseball
Mount St. Joseph Calvert Hall 1 - 4 Calvert Hall
(Δ)
Fri, Apr. 21st
Boys Varsity Baseball
Arch. Curley Calvert Hall 3 - 12 Calvert Hall
(Δ)
Sat, Apr. 22nd
Boys Varsity Baseball
Penncrest (PA) Calvert Hall 12:00pm Calvert Hall
Fri, Apr. 28th
Boys Varsity Baseball
St. Paul's Calvert Hall 0 - 20 Calvert Hall
(Δ)
Sat, Apr. 29th
Boys Varsity Baseball
Calvert Hall John Carroll 9 - 0 John Carroll
(Δ)
Mon, May. 1st
Boys Varsity Baseball
Calvert Hall Loyola 13 - 0 Loyola Blakefield
(Δ)
Wed, May. 3rd
Boys Varsity Baseball
Calvert Hall McDonogh 14 - 1 McDonogh
(Δ)
Thu, May. 4th
Boys Varsity Baseball
Calvert Hall St. Mary's 7 - 2 Joe Cannon Stadium
(Δ)
Tue, May. 9th
Boys Varsity Baseball
Calvert Hall Arch. Spalding 6 - 2 Archbishop Spalding
(Δ)
Mon, May. 15th
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Gm 5
Loyola Calvert Hall 2 - 1 Calvert Hall
Tue, May. 16th
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Gm 6
Gilman Calvert Hall 1 - 8 Calvert Hall
Wed, May. 17th
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Gm 7
Arch. Curley Calvert Hall 2 - 3 Calvert Hall
Fri, May. 19th
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Gm 9
Arch. Spalding Calvert Hall 5 - 7 Calvert Hall
Sun, May. 21st
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Finals
Calvert Hall Loyola 9 - 0 Harford Community College
Mon, May. 22nd
Boys Varsity Baseball
MIAA A Conference Baseball Finals
Loyola Calvert Hall 8 - 3 Harford Community College

Twitter

 

TERMS OF SERVICE   |   PRIVACY STATEMENT  | Copyright @ 2010 SportsCom Media LLC | .