CHANNELS:
KASA
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 = 12620 OR s.id = 12828 OR s.id = 12846 OR s.id = 12871 OR s.id = 13038 OR s.id = 13040 OR s.id = 13058 OR s.id = 13066 OR s.id = 13082 OR s.id = 13095 OR s.id = 13099 OR s.id = 13113 OR s.id = 13122 OR s.id = 13123 OR s.id = 13127 OR s.id = 25877 OR s.id = 25881 OR s.id = 25882 OR s.id = 25886 OR s.id = 25889 OR s.id = 25893 OR s.id = 25896 OR s.id = 25899 OR s.id = 25903 OR s.id = 25908 OR s.id = 25912 OR s.id = 25917 OR s.id = 25921 OR s.id = 25925 OR s.id = 25929 OR s.id = 30076 OR s.id = 45639 OR s.id = 60006 OR s.id = 60007 OR s.id = 60015 OR s.id = 60027 OR s.id = 60029 OR s.id = 60036 OR s.id = 60112 OR s.id = 60105 OR s.id = 60124 OR s.id = 60133 OR s.id = 60138 OR s.id = 60146 OR s.id = 60147 OR s.id = 62111 OR s.id = 106208 OR s.id = 77726 OR s.id = 77751 OR s.id = 77781 OR s.id = 77789 OR s.id = 77790 OR s.id = 77798 OR s.id = 77800 OR s.id = 78459 OR s.id = 78460 OR s.id = 78600 OR s.id = 78663 OR s.id = 93036 OR s.id = 93037 OR s.id = 93038 OR s.id = 93039 OR s.id = 93040 OR s.id = 93041 OR s.id = 93042 OR s.id = 93043 OR s.id = 93044 OR s.id = 93045 OR s.id = 93046 OR s.id = 93047 OR s.id = 93048 OR s.id = 94420 OR s.id = 94421 OR s.id = 106203 OR s.id = 106210 OR s.id = 106211 OR s.id = 106212 OR s.id = 106213 OR s.id = 106214 OR s.id = 106216 OR s.id = 106217 OR s.id = 106218 OR s.id = 106219 OR s.id = 106220 OR s.id = 106247 OR s.id = 110443 OR s.id = 110636 OR s.id = 110690) 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, '|1888|') > 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
Wed, Mar. 22nd
Boys Varsity Baseball
Ben Franklin KASA 3:45pm KASA
(Δ)
Fri, Mar. 24th
Boys Varsity Baseball
KASA Carver Vo-Tech 11 - 1 Carver Vo-Tech
(Δ)
Fri, Mar. 31st
Boys Varsity Baseball
KASA Northwestern 3:45pm
Postponed
Northwestern
(Δ)
Mon, Apr. 3rd
Boys Varsity Baseball
KASA New Era 15 - 16 New Era Academy
(Δ)
Fri, Apr. 7th
Boys Varsity Baseball
KASA FAET 3:45pm FAET
(Δ)
Wed, Apr. 19th
Boys Varsity Baseball
Reginald Lewis KASA 3:45pm KASA
(Δ)
Fri, Apr. 21st
Boys Varsity Baseball
KASA Bluford Drew Jemison 3:45pm Bluford Drew Jemison
(Δ)
Wed, Apr. 26th
Boys Varsity Baseball
National Academy KASA 3:45pm KASA
(Δ)
Fri, Apr. 28th
Boys Varsity Baseball
KASA Ben Franklin 3:45pm Masonville Cove
(Δ)
Mon, May. 1st
Boys Varsity Baseball
Carver Vo-Tech KASA 3:45pm KASA
(Δ)
Wed, May. 3rd
Boys Varsity Baseball
KASA Lake Clifton 16 - 13 Lake Clifton
(Δ)
Fri, May. 5th
Boys Varsity Baseball
Northwestern KASA 3:45pm
Postponed
KASA
(Δ)
Sat, May. 13th
Boys Varsity Baseball
1A Baseball South Region Section II Semifinals
KASA FAET 19 - 12 North Haford Rec. Center
Tue, May. 16th
Boys Varsity Baseball
1A Baseball South Region Section II Finals
KASA Reginald Lewis 28 - 19 North Haford Rec. Center
Fri, May. 19th
Boys Varsity Baseball
1A Baseball South Region Final
KASA Pikesville 0 - 12 Pikesville

Twitter

 

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