CHANNELS:
Spalding
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 = 10703 OR s.id = 10713 OR s.id = 10837 OR s.id = 10848 OR s.id = 10873 OR s.id = 10882 OR s.id = 10899 OR s.id = 11061 OR s.id = 11069 OR s.id = 11095 OR s.id = 11098 OR s.id = 11106 OR s.id = 11110 OR s.id = 11119 OR s.id = 11116 OR s.id = 11121 OR s.id = 11122 OR s.id = 11124 OR s.id = 11125 OR s.id = 11126 OR s.id = 11127 OR s.id = 14597 OR s.id = 14890 OR s.id = 15013 OR s.id = 15044 OR s.id = 15067 OR s.id = 15092 OR s.id = 25475 OR s.id = 25492 OR s.id = 25522 OR s.id = 25523 OR s.id = 25535 OR s.id = 25544 OR s.id = 25546 OR s.id = 25549 OR s.id = 25551 OR s.id = 25553 OR s.id = 25555 OR s.id = 25557 OR s.id = 25558 OR s.id = 25560 OR s.id = 25562 OR s.id = 25564 OR s.id = 25566 OR s.id = 25568 OR s.id = 25569 OR s.id = 25571 OR s.id = 25573 OR s.id = 25576 OR s.id = 25577 OR s.id = 25599 OR s.id = 29887 OR s.id = 30142 OR s.id = 40542 OR s.id = 40556 OR s.id = 40717 OR s.id = 40727 OR s.id = 41120 OR s.id = 41127 OR s.id = 41682 OR s.id = 41689 OR s.id = 41795 OR s.id = 41802 OR s.id = 41808 OR s.id = 41816 OR s.id = 41819 OR s.id = 41820 OR s.id = 41821 OR s.id = 41822 OR s.id = 41823 OR s.id = 41824 OR s.id = 41825 OR s.id = 41826 OR s.id = 41827 OR s.id = 41828 OR s.id = 41829 OR s.id = 41830 OR s.id = 41831 OR s.id = 41832 OR s.id = 45701 OR s.id = 45816 OR s.id = 45976 OR s.id = 57495 OR s.id = 57505 OR s.id = 57592 OR s.id = 57604 OR s.id = 58068 OR s.id = 58070 OR s.id = 58109 OR s.id = 58110 OR s.id = 58111 OR s.id = 58112 OR s.id = 58113 OR s.id = 58114 OR s.id = 58115 OR s.id = 58116 OR s.id = 58117 OR s.id = 58118 OR s.id = 58119 OR s.id = 58120 OR s.id = 58121 OR s.id = 58122 OR s.id = 58123 OR s.id = 58124 OR s.id = 60349 OR s.id = 60485 OR s.id = 60486 OR s.id = 60644 OR s.id = 60646 OR s.id = 62095 OR s.id = 62249 OR s.id = 62311 OR s.id = 73276 OR s.id = 73277 OR s.id = 73278 OR s.id = 77656 OR s.id = 73281 OR s.id = 73282 OR s.id = 73283 OR s.id = 73284 OR s.id = 73285 OR s.id = 73286 OR s.id = 73288 OR s.id = 73289 OR s.id = 73290 OR s.id = 73291 OR s.id = 73292 OR s.id = 73293 OR s.id = 73294 OR s.id = 73295 OR s.id = 73296 OR s.id = 73298 OR s.id = 73299 OR s.id = 73300 OR s.id = 78092 OR s.id = 73297 OR s.id = 78013 OR s.id = 78014 OR s.id = 78016 OR s.id = 78679 OR s.id = 78422 OR s.id = 78585 OR s.id = 89101 OR s.id = 89100 OR s.id = 89096 OR s.id = 89097 OR s.id = 89095 OR s.id = 89098 OR s.id = 89099 OR s.id = 89102 OR s.id = 89103 OR s.id = 89104 OR s.id = 89105 OR s.id = 89106 OR s.id = 89107 OR s.id = 89108 OR s.id = 89109 OR s.id = 89110 OR s.id = 89111 OR s.id = 89112 OR s.id = 89113 OR s.id = 89114 OR s.id = 89115 OR s.id = 89116 OR s.id = 89117 OR s.id = 89118 OR s.id = 89119 OR s.id = 89120 OR s.id = 94083 OR s.id = 94091 OR s.id = 94084 OR s.id = 94515 OR s.id = 94633 OR s.id = 94642 OR s.id = 94698 OR s.id = 105185 OR s.id = 105196 OR s.id = 105217 OR s.id = 105224 OR s.id = 105441 OR s.id = 105455 OR s.id = 105692 OR s.id = 105700 OR s.id = 105895 OR s.id = 105861 OR s.id = 105872 OR s.id = 105888 OR s.id = 105894 OR s.id = 105896 OR s.id = 105897 OR s.id = 105898 OR s.id = 105900 OR s.id = 105902 OR s.id = 105903 OR s.id = 105904 OR s.id = 105905 OR s.id = 105906 OR s.id = 105907 OR s.id = 108995 OR s.id = 108980 OR s.id = 110157 OR s.id = 110553 OR s.id = 110654 OR s.id = 110724) 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, '|902|') > 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
Tue, Mar. 7th
Boys Varsity Baseball
Riverdale Baptist Arch. Spalding 8 - 2 Archbishop Spalding
Thu, Mar. 9th
Boys Varsity Baseball
Arch. Spalding Georgetown Prep 3 - 0 Georgetown Prep
Wed, Mar. 15th
Boys Varsity Baseball
Good Counsel Arch. Spalding 4:00pm
Postponed
Archbishop Spalding
Fri, Mar. 17th
Boys Varsity Baseball
Arch. Spalding St. John's (DC) 8 - 0 St. John's (DC)
Mon, Mar. 20th
Boys Varsity Baseball
Arch. Spalding Loyola 8 - 2 Loyola Blakefield
(Δ)
Wed, Mar. 22nd
Boys Varsity Baseball
Arch. Spalding Gilman 5 - 8 Gilman
(Δ)
Thu, Mar. 23rd
Boys Varsity Baseball
Arch. Spalding Mount St. Joseph 12 - 1 Mount St. Joe
(Δ)
Wed, Mar. 29th
Boys Varsity Baseball
Arch. Spalding St. Alban's 5 - 0 St. Alban's (DC)
Thu, Mar. 30th
Boys Varsity Baseball
Arch. Spalding John Carroll 6 - 0 John Carroll
(Δ)
Mon, Apr. 3rd
Boys Varsity Baseball
McDonogh Arch. Spalding 6 - 9 Archbishop Spalding
(Δ)
Tue, Apr. 4th
Boys Varsity Baseball
Arch. Spalding St. Mary's 5 - 4 Joe Cannon Stadium
(Δ)
Fri, Apr. 7th
Boys Varsity Baseball
Arch. Curley Arch. Spalding 6 - 8 Archbishop Spalding
(Δ)
Mon, Apr. 10th
Boys Varsity Baseball
St. Paul's Arch. Spalding 1 - 9 Archbishop Spalding
(Δ)
Tue, Apr. 11th
Boys Varsity Baseball
Arch. Spalding Calvert Hall 7 - 2 Calvert Hall
(Δ)
Thu, Apr. 13th
Boys Varsity Baseball
DeMatha Arch. Spalding 2 - 6 Archbishop Spalding
Sat, Apr. 15th
Boys Varsity Baseball
Bel Air Tournament
C. Milton Wright Arch. Spalding 8 - 17 Bel Air
Boys Varsity Baseball
Bel Air Tournament
Arch. Spalding Bel Air 16 - 0 Bel Air
Mon, Apr. 17th
Boys Varsity Baseball
Arch. Spalding Loyola 5 - 8 Loyola Blakefield
(Δ)
Wed, Apr. 19th
Boys Varsity Baseball
Gilman Arch. Spalding 1 - 13 Archbishop Spalding
(Δ)
Fri, Apr. 21st
Boys Varsity Baseball
Mount St. Joseph Arch. Spalding 8 - 6 Archbishop Spalding
(Δ)
Wed, Apr. 26th
Boys Varsity Baseball
Arch. Spalding St. Paul's 4 - 2 St. Paul's
(Δ)
Thu, Apr. 27th
Boys Varsity Baseball
John Carroll Arch. Spalding 0 - 10 Archbishop Spalding
(Δ)
Mon, May. 1st
Boys Varsity Baseball
Arch. Spalding McDonogh 4 - 5 McDonogh
(Δ)
Wed, May. 3rd
Boys Varsity Baseball
St. Mary's Arch. Spalding 0 - 9 Archbishop Spalding
(Δ)
Sat, May. 6th
Boys Varsity Baseball
Arch. Spalding Arch. Curley 6 - 1 Archbishop Curley
(Δ)
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 4
Arch. Curley Arch. Spalding 1 - 6 Archbishop Spalding
Wed, May. 17th
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Gm 8
Loyola Arch. Spalding 3 - 2 Archbishop Spalding
Fri, May. 19th
Boys Varsity Baseball
MIAA A Conference Baseball Tournament - Gm 9
Arch. Spalding Calvert Hall 5 - 7 Calvert Hall

Twitter

 

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