CHANNELS:
Patterson_Mill
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 = 11751 OR s.id = 11765 OR s.id = 11778 OR s.id = 11787 OR s.id = 11810 OR s.id = 11816 OR s.id = 11828 OR s.id = 11829 OR s.id = 11830 OR s.id = 11831 OR s.id = 11832 OR s.id = 11833 OR s.id = 11834 OR s.id = 11835 OR s.id = 11836 OR s.id = 14122 OR s.id = 15071 OR s.id = 15084 OR s.id = 26600 OR s.id = 26607 OR s.id = 26610 OR s.id = 26618 OR s.id = 26627 OR s.id = 26631 OR s.id = 26636 OR s.id = 26643 OR s.id = 26645 OR s.id = 26647 OR s.id = 26654 OR s.id = 26655 OR s.id = 26656 OR s.id = 28477 OR s.id = 28481 OR s.id = 28483 OR s.id = 29455 OR s.id = 29585 OR s.id = 26652 OR s.id = 30057 OR s.id = 30131 OR s.id = 30235 OR s.id = 30236 OR s.id = 30272 OR s.id = 41108 OR s.id = 43090 OR s.id = 43097 OR s.id = 43100 OR s.id = 43107 OR s.id = 43113 OR s.id = 43120 OR s.id = 43126 OR s.id = 43492 OR s.id = 43493 OR s.id = 43494 OR s.id = 43495 OR s.id = 43496 OR s.id = 43497 OR s.id = 43498 OR s.id = 43499 OR s.id = 43500 OR s.id = 45374 OR s.id = 45376 OR s.id = 45696 OR s.id = 45863 OR s.id = 45920 OR s.id = 45990 OR s.id = 57177 OR s.id = 57186 OR s.id = 57201 OR s.id = 57219 OR s.id = 57229 OR s.id = 57233 OR s.id = 57235 OR s.id = 57238 OR s.id = 57248 OR s.id = 57256 OR s.id = 57258 OR s.id = 57259 OR s.id = 57260 OR s.id = 57261 OR s.id = 57265 OR s.id = 57266 OR s.id = 57267 OR s.id = 57421 OR s.id = 62143 OR s.id = 62144 OR s.id = 75326 OR s.id = 76318 OR s.id = 76325 OR s.id = 76350 OR s.id = 76359 OR s.id = 76362 OR s.id = 76366 OR s.id = 76371 OR s.id = 76374 OR s.id = 76379 OR s.id = 76385 OR s.id = 76387 OR s.id = 76388 OR s.id = 76389 OR s.id = 76390 OR s.id = 76391 OR s.id = 76392 OR s.id = 76393 OR s.id = 78471 OR s.id = 78472 OR s.id = 78595 OR s.id = 78661 OR s.id = 78685 OR s.id = 91974 OR s.id = 91981 OR s.id = 91985 OR s.id = 91991 OR s.id = 91995 OR s.id = 92002 OR s.id = 92014 OR s.id = 92020 OR s.id = 92023 OR s.id = 92026 OR s.id = 92035 OR s.id = 92037 OR s.id = 92041 OR s.id = 92042 OR s.id = 92043 OR s.id = 92044 OR s.id = 92045 OR s.id = 92046 OR s.id = 92047 OR s.id = 92048 OR s.id = 94429 OR s.id = 94583 OR s.id = 94665 OR s.id = 94680 OR s.id = 94701 OR s.id = 106830 OR s.id = 108771 OR s.id = 108772 OR s.id = 108773 OR s.id = 108774 OR s.id = 108775 OR s.id = 108776 OR s.id = 108777 OR s.id = 108778 OR s.id = 108779 OR s.id = 108782 OR s.id = 108783 OR s.id = 108784 OR s.id = 108785 OR s.id = 108786 OR s.id = 108787 OR s.id = 108788 OR s.id = 108789 OR s.id = 108780 OR s.id = 105416 OR s.id = 110445 OR s.id = 110635 OR s.id = 110691 OR s.id = 110764) 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, '|1522|') > 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 | .