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 = 102 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 ('2013-11-23') AND date_add('2013-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 2013 >>
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/29
A Dutch Fork (Irmo) 31
H Byrnes (Duncan) 21
A Southeast Guilford 30
H Charlotte Catholic 56
A Fairfield Central 37
H Cheraw 13
A South Point (Belmont) 13
H Concord 21
A A.C. Reynolds (Asheville) 14
H Crest (Boiling Springs) 30
A Washington 46
H Currituck County 6
A Timberland (St. Stephen) 0
H Dillon 14
A Hunt (Wilson) 20
H Douglas Byrd (Fayetteville) 14
A Rocky River (Mint Hill) 7
H Dudley (Greensboro) 28
A Eastern Alamance 7
H Eastern Wayne 12
A North Forsyth 2
H Havelock 48
A Forestview (Gastonia) 42
H Hibriten (Lenoir) 20
A J.H. Rose (Greenville) 26
H Hoggard (Wilmington) 15
A Parkwood (Monroe) 24
H Hunter Huss (Gastonia) 14
A Whiteville 7
H James Kenan (Warsaw) 17
A Southeast Halifax 3
H Lejeune 38
A Northwest Guilford 13
H Mallard Creek (Charlotte) 56
A Garner 21
H Middle Creek (Apex) 24
A Wake Forest 27
H Millbrook (Raleigh) 24
A East Lincoln 18
H Monroe 34
A Hayesville 12
H Murphy 49
A Marlboro County 6
H Myrtle Beach 20
A Shelby 45
H North Rowan 21
A Ayden-Grifton 35
H Northeastern (Elizabeth City) 41
A Weddington 19
H Northern Guilford 22
A North Augusta 21
H Northwestern (Rock Hill) 49
A Lincolnton 10
H Reidsville 13
A Knightdale 17
H Scotland 24
A Stratford (Goose Creek) 36
H South Pointe (Rock Hill) 13
A Orange 24
H Southern Durham 31
A Eastern Randolph 9
H Southwest Onslow 29
A Sumter 28
H Summerville 27
A Starmount (Boonville) 14
H Swain County 49
A Northside (Jacksonville) 14
H T.W. Andrews (High Point) 21
A Wallace-Rose Hill 35
H Tarboro 10
A Butler (Matthews) 48
H West Forsyth 7