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-01-19' and s.start_time <= '2017-02-02 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, Jan. 19th
Girls Varsity Basketball
Bel Air Fallston 6:45pm Fallston
(Δ)
Fri, Jan. 20th
Boys Varsity Wrestling
Havre de Grace Duals
Kenwood
Loch Raven
North Harford
Fallston
Patterson Mill
Joppatowne
Edgewood
Havre de Grace TBA Havre de Grace
Boys Varsity Basketball
Fallston Bo Manor 7:00pm Bo Manor
(Δ)
Mon, Jan. 23rd
Boys Varsity Wrestling
Perryville Fallston 4:30pm Fallston
Boys Varsity Wrestling
Mount Carmel Fallston 4:30pm Fallston
Boys Varsity Basketball
South Carroll Fallston 6:45pm Fallston
Tue, Jan. 24th
Boys Varsity Basketball
Rising Sun Fallston 6:45pm Fallston
(Δ)
Thu, Jan. 26th
Girls Varsity Basketball
Patterson Mill Fallston 6:45pm Fallston
(Δ)
Fri, Jan. 27th
Boys Varsity Wrestling
SnOverlea Tournament
Loyola
John Carroll
Milford Mill
Western Tech
Fallston
Overlea TBA Overlea
Boys Varsity Basketball
Fallston Havre de Grace 6:45pm Havre de Grace
(Δ)
Tue, Jan. 31st
Boys Varsity Basketball
North Harford Fallston 6:45pm Fallston
(Δ)
Girls Varsity Basketball
Fallston Elkton 7:00pm Elkton
(Δ)
Wed, Feb. 1st
Boys Varsity Wrestling
Harford Tech Fallston 5:30pm Fallston
(Δ)
Thu, Feb. 2nd
Girls Varsity Basketball
Harford Tech Fallston 6:45pm Fallston
(Δ)

Twitter

 

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