CHANNELS:
Northeast-AA
Team News  |  Schedule  |  Roster  |  Photos  |  Videos
GIRLS VARSITY SOFTBALL
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 = 11612 OR s.id = 11617 OR s.id = 11624 OR s.id = 11630 OR s.id = 11639 OR s.id = 11641 OR s.id = 11650 OR s.id = 11658 OR s.id = 11662 OR s.id = 11665 OR s.id = 11670 OR s.id = 11684 OR s.id = 11690 OR s.id = 11698 OR s.id = 11706 OR s.id = 11709 OR s.id = 11722 OR s.id = 11729 OR s.id = 14868 OR s.id = 14955 OR s.id = 14989 OR s.id = 26797 OR s.id = 26805 OR s.id = 26850 OR s.id = 26873 OR s.id = 26876 OR s.id = 26880 OR s.id = 26883 OR s.id = 26885 OR s.id = 26886 OR s.id = 26887 OR s.id = 26888 OR s.id = 26889 OR s.id = 26825 OR s.id = 26776 OR s.id = 29951 OR s.id = 30189 OR s.id = 30252 OR s.id = 30253 OR s.id = 43604 OR s.id = 43628 OR s.id = 43644 OR s.id = 43653 OR s.id = 43661 OR s.id = 43668 OR s.id = 43675 OR s.id = 43693 OR s.id = 43695 OR s.id = 43702 OR s.id = 43704 OR s.id = 43705 OR s.id = 43706 OR s.id = 43707 OR s.id = 43708 OR s.id = 43709 OR s.id = 43710 OR s.id = 43760 OR s.id = 45297 OR s.id = 45534 OR s.id = 45725 OR s.id = 61367 OR s.id = 61733 OR s.id = 61776 OR s.id = 61639 OR s.id = 61641 OR s.id = 61754 OR s.id = 61763 OR s.id = 61781 OR s.id = 61785 OR s.id = 61794 OR s.id = 61803 OR s.id = 61808 OR s.id = 61809 OR s.id = 61810 OR s.id = 61811 OR s.id = 61812 OR s.id = 61813 OR s.id = 61814 OR s.id = 61815 OR s.id = 61827 OR s.id = 62056 OR s.id = 62274 OR s.id = 74389 OR s.id = 74410 OR s.id = 74423 OR s.id = 74424 OR s.id = 74548 OR s.id = 74438 OR s.id = 74447 OR s.id = 74454 OR s.id = 74514 OR s.id = 74520 OR s.id = 74523 OR s.id = 74530 OR s.id = 74533 OR s.id = 74543 OR s.id = 74541 OR s.id = 74545 OR s.id = 74547 OR s.id = 78158 OR s.id = 78059 OR s.id = 78063 OR s.id = 78401 OR s.id = 78511 OR s.id = 93284 OR s.id = 93432 OR s.id = 93443 OR s.id = 93457 OR s.id = 93476 OR s.id = 93477 OR s.id = 93478 OR s.id = 93479 OR s.id = 93481 OR s.id = 93503 OR s.id = 93768 OR s.id = 93777 OR s.id = 93866 OR s.id = 93874 OR s.id = 93878 OR s.id = 93886 OR s.id = 93891 OR s.id = 93894 OR s.id = 93895 OR s.id = 93896 OR s.id = 94393 OR s.id = 94611 OR s.id = 94668 OR s.id = 94687 OR s.id = 107744 OR s.id = 109542 OR s.id = 109553 OR s.id = 109884 OR s.id = 109889 OR s.id = 109900 OR s.id = 109911 OR s.id = 109913 OR s.id = 109914 OR s.id = 109915 OR s.id = 109916 OR s.id = 109933 OR s.id = 109944 OR s.id = 109990 OR s.id = 110046 OR s.id = 110051 OR s.id = 110063 OR s.id = 110065 OR s.id = 110067 OR s.id = 108653 OR s.id = 110527 OR s.id = 110716 OR s.id = 110729 OR s.id = 110771) and (se.id is null OR se.id = 0) 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, '|1769|') > 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
NO GAMES HAVE BEEN ENTERED YET FOR THIS SEASON. PLEASE USE THE DROP DOWN WINDOW ABOVE TO NAVIGATE TO A PREVIOUS SEASON.

Twitter

 

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