CHANNELS:
Fallston
Fallston High School  // 2301 Carrs Mill Road  // Fallston, MD 21047 
Athletic Director: Dave Cesky   //  Mascot: Cougars  // School Website  // 410-638-4120
School Home  |  Sports 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-03-30' and s.start_time <= '2017-04-13 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(schools, '|40|') > 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
Thu, Mar. 30th
Girls Varsity Lacrosse
Fallston Patterson Mill 6:45pm Patterson Mill
(Δ)
Fri, Mar. 31st
Boys Varsity Baseball
Rising Sun Fallston 3:30pm Fallston
(Δ)
Girls Varsity Softball
Aberdeen Fallston 4:15pm Fallston
(Δ)
Boys Varsity Lacrosse
Patterson Mill Fallston 6:45pm Fallston
(Δ)
Mon, Apr. 3rd
Boys Varsity Baseball
Fallston Bel Air 3:30pm Bel Air
(Δ)
Girls Varsity Softball
Fallston Elkton 3:30pm Elkton
(Δ)
Boys Varsity Lacrosse
Fallston River Hill 5:30pm River Hill
Tue, Apr. 4th
Girls Varsity Lacrosse
Perryville Fallston 6:45pm Fallston
(Δ)
Wed, Apr. 5th
Boys Varsity Baseball
Fallston Elkton 3:15pm Elkton
(Δ)
Girls Varsity Softball
Patterson Mill Fallston 3:30pm Fallston
(Δ)
Boys Varsity Lacrosse
Fallston Havre de Grace 6:45pm Havre de Grace
(Δ)
Thu, Apr. 6th
Girls Varsity Lacrosse
Fallston Harford Tech 6:45pm Harford Tech
(Δ)
Fri, Apr. 7th
Boys Varsity Lacrosse
Fallston Dulaney TBA Johns Hopkins University
Girls Varsity Lacrosse
Fallston Dulaney TBA Johns Hopkins University
Boys Varsity Baseball
North Harford Fallston 3:30pm Fallston
(Δ)
Girls Varsity Softball
Fallston Harford Tech 3:30pm Harford Tech
(Δ)
Mon, Apr. 10th
Boys Varsity Baseball
Fallston C. Milton Wright 3:30pm C.M. Wright
(Δ)
Girls Varsity Softball
Fallston Joppatowne 3:30pm Joppatowne
(Δ)
Boys Varsity Lacrosse
Fallston North Harford 6:45pm North Harford
(Δ)
Tue, Apr. 11th
Girls Varsity Lacrosse
North Harford Fallston 6:45pm Fallston
(Δ)
Wed, Apr. 12th
Girls Varsity Softball
Havre de Grace Fallston 3:30pm Fallston
(Δ)

Twitter

 

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