CHANNELS:
Saints Peter & Paul
Team News  |  Schedule  |  Roster  |  Photos  |  Videos
BOYS 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 = 9945 OR s.id = 9914 OR s.id = 9921 OR s.id = 9968 OR s.id = 9949 OR s.id = 9952 OR s.id = 9959 OR s.id = 9970 OR s.id = 9965 OR s.id = 9974 OR s.id = 9976 OR s.id = 9978 OR s.id = 9981 OR s.id = 9984 OR s.id = 9985 OR s.id = 14352 OR s.id = 14898 OR s.id = 14899 OR s.id = 25119 OR s.id = 25133 OR s.id = 25158 OR s.id = 25163 OR s.id = 25193 OR s.id = 25197 OR s.id = 25202 OR s.id = 25204 OR s.id = 25208 OR s.id = 25210 OR s.id = 25399 OR s.id = 25400 OR s.id = 25401 OR s.id = 25402 OR s.id = 25403 OR s.id = 30034 OR s.id = 30200 OR s.id = 40412 OR s.id = 40416 OR s.id = 40705 OR s.id = 40710 OR s.id = 40749 OR s.id = 40807 OR s.id = 42062 OR s.id = 42066 OR s.id = 42302 OR s.id = 42306 OR s.id = 42309 OR s.id = 42313 OR s.id = 42316 OR s.id = 42317 OR s.id = 42320 OR s.id = 42321 OR s.id = 45858 OR s.id = 45978 OR s.id = 57011 OR s.id = 57855 OR s.id = 57860 OR s.id = 58409 OR s.id = 58416 OR s.id = 58443 OR s.id = 58450 OR s.id = 58486 OR s.id = 58650 OR s.id = 58773 OR s.id = 59116 OR s.id = 59121 OR s.id = 59123 OR s.id = 59124 OR s.id = 62092 OR s.id = 62185 OR s.id = 62302 OR s.id = 73888 OR s.id = 74822 OR s.id = 74849 OR s.id = 74948 OR s.id = 74951 OR s.id = 74982 OR s.id = 74993 OR s.id = 74998 OR s.id = 75005 OR s.id = 75017 OR s.id = 75018 OR s.id = 75019 OR s.id = 75020 OR s.id = 75021 OR s.id = 78261 OR s.id = 89237 OR s.id = 89305 OR s.id = 89327 OR s.id = 89348 OR s.id = 89356 OR s.id = 89358 OR s.id = 89359 OR s.id = 89360 OR s.id = 89361 OR s.id = 89362 OR s.id = 89363 OR s.id = 90643 OR s.id = 90645 OR s.id = 90646 OR s.id = 90647 OR s.id = 90648 OR s.id = 90649 OR s.id = 91900 OR s.id = 94123 OR s.id = 94300 OR s.id = 105754 OR s.id = 106191 OR s.id = 106883 OR s.id = 107156 OR s.id = 107181 OR s.id = 107217 OR s.id = 107233 OR s.id = 107248 OR s.id = 107249 OR s.id = 107250 OR s.id = 107251 OR s.id = 107252 OR s.id = 107253 OR s.id = 107254 OR s.id = 107255 OR s.id = 107256 OR s.id = 107257 OR s.id = 110701 OR s.id = 110704) 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, '|1078|') > 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
Fri, Mar. 10th
Boys Varsity Lacrosse
Saints Peter & Paul Plano East (TX) 16 - 1 Sts. Peter & Paul
Fri, Mar. 17th
Boys Varsity Lacrosse
Saints Peter & Paul St. Mary's 3 - 12 St. Mary's Field
Tue, Mar. 21st
Boys Varsity Lacrosse
Saints Peter & Paul St. Paul's 2 - 17 St. Paul's
Fri, Mar. 24th
Boys Varsity Lacrosse
Salesianum (DE) Saints Peter & Paul 4:00pm Sts. Peter & Paul
Tue, Mar. 28th
Boys Varsity Lacrosse
Saints Peter & Paul Calvert Hall 4 - 20 Calvert Hall
Fri, Mar. 31st
Boys Varsity Lacrosse
Saints Peter & Paul Arch. Spalding 2 - 18 Archbishop Spalding
Tue, Apr. 4th
Boys Varsity Lacrosse
Glenelg Country Saints Peter & Paul 7 - 8 Sts. Peter & Paul
(Δ)
Fri, Apr. 7th
Boys Varsity Lacrosse
Saints Peter & Paul Severn 8 - 15 Severn
Thu, Apr. 13th
Boys Varsity Lacrosse
Foothills (CA) Saints Peter & Paul 6 - 15 Sts. Peter & Paul
Tue, Apr. 18th
Boys Varsity Lacrosse
Saints Peter & Paul John Carroll 7 - 16 John Carroll
(Δ)
Fri, Apr. 21st
Boys Varsity Lacrosse
Saints Peter & Paul Annapolis Area Christian 6 - 7 Annap. Area Christian
(Δ)
Sat, Apr. 29th
Boys Varsity Lacrosse
Saints Peter & Paul Gerstell Academy 8 - 9 Gerstell Academy
(Δ)
Tue, May. 2nd
Boys Varsity Lacrosse
St. John's Catholic Prep Saints Peter & Paul 11 - 10 Sts. Peter & Paul
(Δ)
Thu, May. 4th
Boys Varsity Lacrosse
Saints Peter & Paul Arch. Curley 10 - 8 Archbishop Curley
(Δ)
Sat, May. 6th
Boys Varsity Lacrosse
Saints Peter & Paul Easton 4:00pm Easton HS
Tue, May. 9th
Boys Varsity Lacrosse
Park Saints Peter & Paul 4 - 5 Sts. Peter & Paul
(Δ)
Fri, May. 12th
Boys Varsity Lacrosse
Friends Saints Peter & Paul 10 - 6 Sts. Peter & Paul
(Δ)
Fri, May. 19th
Boys Varsity Lacrosse
MIAA B Conference Lacrosse Quarterfinals
Saints Peter & Paul Park 12 - 4 Park School
Mon, May. 22nd
Boys Varsity Lacrosse
MIAA B Conference Lacrosse Semifinals
Saints Peter & Paul Gerstell Academy 9 - 18 Gerstell Academy

Twitter

 

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