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 = 103 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 ('2014-11-23') AND date_add('2014-11-23',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name Chris Hughes' CarolinaPreps.com Team Pages | Your Digital Destination for High School Football News & Information

<< November 2014 >>
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/28
A South Pointe (Rock Hill) 40
H A.C. Flora (Columbia) 21
A Weddington 28
H Asheville 23
A Forestview (Gastonia) 7
H Crest (Boiling Springs) 52
A Statesville 0
H Cuthbertson (Waxhaw) 42
A Newberry 27
H Dillon 49
A Byrnes (Duncan) 6
H Dutch Fork (Irmo) 41
A Lincolnton 14
H East Lincoln 35
A Havelock 63
H Eastern Alamance 28
A Hillcrest (Simpsonville) 20
H Fort Dorchester (N. Charleston) 0
A Monroe 14
H Franklin 17
A Panther Creek (Cary) 6
H Garner 31
A York 21
H Greenwood 6
A Marlboro County 20
H Hartsville 23
A Scotland 21
H Hoggard (Wilmington) 24
A Clinton 39
H Holmes (Edenton) 21
A Lake View 28
H Hunter-Kinard-Tyler 42
A Tarboro 14
H James Kenan (Warsaw) 22
A Hough (Cornelius) 42
H Lake Norman 52
A South Creek 6
H Lakewood 14
A Providence (Charlotte) 21
H Mallard Creek (Charlotte) 49
A Hillside (Durham) 7
H New Bern 13
A SouthWest Edgecombe 6
H Northeastern (Elizabeth City) 48
A Northern Guilford 31
H Orange 7
A Mount Pleasant 42
H Owen (Black Mountain) 21
A Charlotte Catholic 49
H Reagan (Pfafftown) 0
A Shelby 17
H Reidsville 7
A Murphy 13
H Robbinsville 21
A Spartanburg 63
H South Florence 30
A East Rowan 32
H South Point (Belmont) 42
A Chapel Hill 39
H Southern Durham 28
A Farmville Central 7
H Southwest Onslow 35
A Alleghany 35
H Thomas Jefferson 28
A Keenan (Columbia) 12
H Timberland (St. Stephen) 35
A Rocky River (Mint Hill) 14
H Vance (Charlotte) 21
A Millbrook (Raleigh) 21
H Wake Forest 28
A Princeton 20
H Wallace-Rose Hill 42
A Roanoke Rapids 0
H Washington 28
A Swain County 35
H Whiteville 24
Saturday's Game 11/29
A Eastern Wayne 56
H Southern Guilford 55