CHANNELS:
CMW
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 = 13560 OR s.id = 12008 OR s.id = 10915 OR s.id = 12007 OR s.id = 12004 OR s.id = 12005 OR s.id = 12006 OR s.id = 12009 OR s.id = 12010 OR s.id = 12011 OR s.id = 12053 OR s.id = 12091 OR s.id = 14411 OR s.id = 14504 OR s.id = 14765 OR s.id = 14948 OR s.id = 14993 OR s.id = 15075 OR s.id = 26903 OR s.id = 26911 OR s.id = 26921 OR s.id = 26928 OR s.id = 26932 OR s.id = 26933 OR s.id = 26934 OR s.id = 26935 OR s.id = 26936 OR s.id = 26937 OR s.id = 26938 OR s.id = 26939 OR s.id = 26940 OR s.id = 26941 OR s.id = 26942 OR s.id = 26943 OR s.id = 26944 OR s.id = 26945 OR s.id = 27208 OR s.id = 27298 OR s.id = 29946 OR s.id = 29947 OR s.id = 30204 OR s.id = 40878 OR s.id = 40938 OR s.id = 41722 OR s.id = 41723 OR s.id = 41724 OR s.id = 41725 OR s.id = 41726 OR s.id = 41727 OR s.id = 41728 OR s.id = 41729 OR s.id = 41730 OR s.id = 41731 OR s.id = 41732 OR s.id = 41733 OR s.id = 41734 OR s.id = 43636 OR s.id = 43664 OR s.id = 45330 OR s.id = 45331 OR s.id = 45382 OR s.id = 45536 OR s.id = 45711 OR s.id = 45713 OR s.id = 45955 OR s.id = 45981 OR s.id = 57448 OR s.id = 57458 OR s.id = 57788 OR s.id = 57795 OR s.id = 57926 OR s.id = 57927 OR s.id = 57928 OR s.id = 57929 OR s.id = 57930 OR s.id = 57931 OR s.id = 57932 OR s.id = 57933 OR s.id = 57934 OR s.id = 61697 OR s.id = 60716 OR s.id = 61643 OR s.id = 61722 OR s.id = 61795 OR s.id = 62062 OR s.id = 62179 OR s.id = 62276 OR s.id = 62355 OR s.id = 62367 OR s.id = 73152 OR s.id = 73192 OR s.id = 73201 OR s.id = 78698 OR s.id = 76558 OR s.id = 77126 OR s.id = 77460 OR s.id = 77461 OR s.id = 77462 OR s.id = 77463 OR s.id = 77464 OR s.id = 77467 OR s.id = 77468 OR s.id = 77469 OR s.id = 77470 OR s.id = 77471 OR s.id = 77472 OR s.id = 77473 OR s.id = 78065 OR s.id = 78069 OR s.id = 78392 OR s.id = 78510 OR s.id = 78650 OR s.id = 78690 OR s.id = 78705 OR s.id = 94169 OR s.id = 94089 OR s.id = 89724 OR s.id = 89993 OR s.id = 91719 OR s.id = 93278 OR s.id = 93634 OR s.id = 93640 OR s.id = 93649 OR s.id = 93655 OR s.id = 93661 OR s.id = 93663 OR s.id = 93664 OR s.id = 93665 OR s.id = 93666 OR s.id = 93667 OR s.id = 93668 OR s.id = 93669 OR s.id = 93670 OR s.id = 93672 OR s.id = 94396 OR s.id = 94504 OR s.id = 94639 OR s.id = 94610 OR s.id = 94688 OR s.id = 107733 OR s.id = 110200 OR s.id = 108649 OR s.id = 108947 OR s.id = 109574 OR s.id = 109575 OR s.id = 109576 OR s.id = 109577 OR s.id = 109578 OR s.id = 109579 OR s.id = 109582 OR s.id = 109583 OR s.id = 109584 OR s.id = 109585 OR s.id = 109586 OR s.id = 109587 OR s.id = 109588 OR s.id = 109589 OR s.id = 109590 OR s.id = 110047 OR s.id = 110518 OR s.id = 110632 OR s.id = 110677 OR s.id = 110730 OR s.id = 110771 OR s.id = 110789) 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, '|1510|') > 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 | .