CHANNELS:
Liberty
Team News  |  Schedule  |  Roster  |  Photos  |  Videos
GIRLS VARSITY LACROSSE
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 = 28923 OR s.id = 28915 OR s.id = 29079 OR s.id = 29088 OR s.id = 29099 OR s.id = 29100 OR s.id = 29101 OR s.id = 29102 OR s.id = 29103 OR s.id = 29104 OR s.id = 29105 OR s.id = 29860 OR s.id = 42715 OR s.id = 44412 OR s.id = 44431 OR s.id = 44511 OR s.id = 44515 OR s.id = 44565 OR s.id = 44583 OR s.id = 44640 OR s.id = 44661 OR s.id = 44665 OR s.id = 44666 OR s.id = 44667 OR s.id = 45636 OR s.id = 45635 OR s.id = 45856 OR s.id = 59965 OR s.id = 59972 OR s.id = 59980 OR s.id = 59981 OR s.id = 59982 OR s.id = 59983 OR s.id = 59984 OR s.id = 59985 OR s.id = 59986 OR s.id = 59987 OR s.id = 59988 OR s.id = 59989 OR s.id = 62022 OR s.id = 62218 OR s.id = 75583 OR s.id = 75756 OR s.id = 76190 OR s.id = 76992 OR s.id = 76993 OR s.id = 76994 OR s.id = 76995 OR s.id = 76996 OR s.id = 76997 OR s.id = 76998 OR s.id = 76999 OR s.id = 77000 OR s.id = 77001 OR s.id = 76810 OR s.id = 78319 OR s.id = 78568 OR s.id = 89695 OR s.id = 89784 OR s.id = 89816 OR s.id = 89817 OR s.id = 89818 OR s.id = 89819 OR s.id = 89822 OR s.id = 89823 OR s.id = 89824 OR s.id = 89825 OR s.id = 89826 OR s.id = 89827 OR s.id = 90134 OR s.id = 90403 OR s.id = 94350 OR s.id = 94492 OR s.id = 94652 OR s.id = 106733 OR s.id = 106746 OR s.id = 106755 OR s.id = 106756 OR s.id = 106757 OR s.id = 106758 OR s.id = 106759 OR s.id = 106760 OR s.id = 106761 OR s.id = 106762 OR s.id = 106763 OR s.id = 106764 OR s.id = 106765 OR s.id = 110381 OR s.id = 110382 OR s.id = 110659 OR s.id = 110751 OR s.id = 29960 OR s.id = 30202 OR s.id = 30248 OR s.id = 30264 OR s.id = 45070 OR s.id = 44068 OR s.id = 44077 OR s.id = 44232 OR s.id = 44233 OR s.id = 44234 OR s.id = 44235 OR s.id = 44236 OR s.id = 44237 OR s.id = 44238 OR s.id = 44239 OR s.id = 44240 OR s.id = 44524 OR s.id = 44548 OR s.id = 44593 OR s.id = 44602 OR s.id = 44652 OR s.id = 45071 OR s.id = 45766 OR s.id = 59349 OR s.id = 59359 OR s.id = 59371 OR s.id = 59378 OR s.id = 59382 OR s.id = 59383 OR s.id = 59384 OR s.id = 59385 OR s.id = 59386 OR s.id = 59387 OR s.id = 59388 OR s.id = 59389 OR s.id = 59390 OR s.id = 59391 OR s.id = 59393 OR s.id = 59394 OR s.id = 59395 OR s.id = 59396 OR s.id = 61667 OR s.id = 61671 OR s.id = 62041 OR s.id = 62273 OR s.id = 75590 OR s.id = 75602 OR s.id = 75774 OR s.id = 75789 OR s.id = 76201 OR s.id = 76209 OR s.id = 76979 OR s.id = 76981 OR s.id = 76982 OR s.id = 76983 OR s.id = 76984 OR s.id = 76985 OR s.id = 76986 OR s.id = 76987 OR s.id = 76988 OR s.id = 76989 OR s.id = 76990 OR s.id = 76991 OR s.id = 77066 OR s.id = 76510 OR s.id = 78383 OR s.id = 78627 OR s.id = 78657 OR s.id = 89728 OR s.id = 89735 OR s.id = 89757 OR s.id = 89763 OR s.id = 89828 OR s.id = 89829 OR s.id = 89830 OR s.id = 89831 OR s.id = 89832 OR s.id = 89833 OR s.id = 89834 OR s.id = 89835 OR s.id = 89836 OR s.id = 89875 OR s.id = 89880 OR s.id = 89989 OR s.id = 89998 OR s.id = 94131 OR s.id = 94200 OR s.id = 94376 OR s.id = 94613 OR s.id = 94672 OR s.id = 108715 OR s.id = 108873 OR s.id = 108882 OR s.id = 108891 OR s.id = 108892 OR s.id = 108903 OR s.id = 108904 OR s.id = 108905 OR s.id = 108906 OR s.id = 108907 OR s.id = 108908 OR s.id = 108909 OR s.id = 108910 OR s.id = 108911 OR s.id = 108912 OR s.id = 108913 OR s.id = 108915 OR s.id = 108916 OR s.id = 108973 OR s.id = 109972 OR s.id = 110500 OR s.id = 110501 OR s.id = 110648) 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, '|2232|') > 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 | .