SELECT G.away_team_score, G.home_team_score, G.Time, G.Date AS Gdate, G.score_entered, G.game_alter, G.ID AS GID, H.media_name AS HomeTeam, A.media_name AS AwayTeam, HTT.Abbreviation AS HomeTeamType, ATT.Abbreviation AS AwayTeamType, H.show_full_name AS HomeTeamShowFullName, A.show_full_name AS AwayTeamShowFullName, H.show_type AS HomeTeamShowType, A.show_type AS AwayTeamShowType, H.ID AS HID, A.ID AS AID, H.League=3 AS HOOS, A.League=3 AS AOOS, H.ZIPcode, G.Location, G.alternative_location FROM games AS G, high_schools AS H, high_schools AS A, high_school_types AS HTT,high_school_types AS ATT WHERE H.ID = G.home_team AND A.ID = G.away_team AND HTT.ID = H.Type AND ATT.ID = A.Type AND H.status=1 AND A.status=1 AND G.Season = 105 AND G.Sport = 1 AND (H.active_nc_team = 1 OR H.active_sc_team = 1) AND (A.active_nc_team = 1 OR A.active_sc_team = 1) AND DATE(G.Date) BETWEEN ('2016-12-14') AND date_add('2016-12-14',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name CarolinaPreps.com | The Carolinas #1 Source For High School Football News

<< December 2016 >>
Su M Tu W Th F Sa
    
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Thursday's Game 12/15
A Dillon 27
H Chapman 29
A Lake View 31
H Lamar 14
Friday's Game 12/16
A West Montgomery 7
H Wallace-Rose Hill 30
Saturday's Game 12/17
A Boiling Springs 21
H Dutch Fork 28
A Weddington 33
H Eastern Guilford 20
A Reidsville 58
H Edenton Holmes 12
A Greensboro Dudley 54
H Fayetteville Cape Fear 0
A Shelby 28
H Jacksonville Northside 6
A Murphy 15
H Plymouth 14
A Hartsville 28
H Rock Hill South Pointe 51
A Belmont South Point 16
H Rocky Mount 7
A Greensboro Page 0
H Wake Forest 29