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 = 106 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 ('2017-11-24') AND date_add('2017-11-24',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name CarolinaPreps.com | The Carolinas #1 Source For High School Football News

<< November 2017 >>
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
  
Friday's Game 11/24
A Saluda 15
H Abbeville 20
A South Iredell 7
H Asheville Reynolds 17
A C.E. Murray 13
H Baptist Hill 54
A Bamberg-Ehrhardt 23
H Barnwell 3
A Hartsville 37
H Berkeley 20
A Dillon 42
H Brookland-Cayce 7
A Emerald 14
H Chapman 48
A Weddington 7
H Charlotte Catholic 42
A East Forsyth 7
H Charlotte Harding 36
A Greensboro Page 5
H Charlotte Mallard Creek 9
A Cornelius Hough 39
H Charlotte Myers Park 17
A Harrisburg Hickory Ridge 21
H Charlotte Vance 49
A Thomas Jefferson 20
H Cherokee 47
A Eastern Guilford 38
H Clayton 31
A Gaffney 10
H Dorman 14
A Fort Dorchester 14
H Dutch Fork 24
A Southwest Onslow 30
H East Bladen 13
A Randleman 13
H East Duplin 21
A Lakewood 7
H Edenton Holmes 49
A Wallace-Rose Hill 63
H Elizabeth City Northeastern 52
A Rock Hill South Pointe 67
H Greer 21
A Southern Nash 39
H Havelock 49
A Concord Robinson 47
H Kings Mountain 46
A Franklin 7
H Lenoir Hibriten 37
A Robbinsville 25
H Mitchell 45
A Garner 56
H Morrisville Green Hope 39
A Bessemer City 16
H Mount Airy 38
A Shelby 7
H Mount Pleasant 0
A Hendersonville 20
H Mountain Heritage 30
A East Surry 27
H Murphy 49
A Fayetteville Cape Fear 38
H New Hanover 41
A South Granville 19
H North Davidson 35
A Pamlico County 14
H North Duplin 42
A Plymouth 14
H Northampton 8
A South Columbus 0
H Reidsville 28
A Lamar 35
H Ridge Spring-Monetta 14
A South Central (Pitt) 34
H Scotland 74
A West Montgomery 3
H Tarboro 48
A Raleigh Sanderson 7
H Wake Forest 35
A Jacksonville 7
H Western Alamance 38
A Wake Forest Heritage 8
H Wilmington Hoggard 20
A Monroe Sun Valley 27
H Winston-Salem Mt. Tabor 20