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 = 41 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 ('2011-11-13') AND date_add('2011-11-13',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 2011 >>
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/18
A Cane Bay (Summerville) 28
H A.C. Flora (Columbia) 44
A Chesterfield 13
H Abbeville 17
A Lakewood 14
H Albemarle 45
A Crest (Boiling Springs) 28
H Asheville 25
A Stratford (Goose Creek) 21
H Ashley Ridge (Summerville) 24
A Southwest Onslow 14
H Ayden-Grifton 35
A Hemingway 32
H Bamberg-Ehrhardt 7
A Summerville 20
H Byrnes (Duncan) 56
A A.L. Brown (Kannapolis) 9
H Charlotte Catholic 35
A Walter Williams (Burlington) 28
H Cleveland (Clayton) 42
A Reidsville 31
H Cummings (Burlington) 7
A Swansea 3
H Dillon 45
A Gaffney 33
H Dorman (Roebuck) 3
A Northern Guilford 35
H Douglas Byrd (Fayetteville) 6
A Boiling Springs 28
H Dutch Fork (Irmo) 27
A South Columbus 10
H East Bladen 0
A Strom Thurmond (Johnston) 49
H Emerald (Greenwood) 21
A Burns (Lawndale) 28
H Franklin 14
A Leesville Road (Raleigh) 21
H Garner 42
A Northwestern (Rock Hill) 7
H Goose Creek 41
A Easley 0
H Greenwood 17
A Currituck County 32
H Havelock 62
A Tarboro 28
H Holmes (Edenton) 26
A Cardinal Gibbons (Raleigh) 17
H Hunt (Wilson) 31
A Middle Creek (Apex) 14
H Jack Britt (Fayetteville) 28
A Bunn 46
H Kinston 47
A Maiden 21
H Lincolnton 34
A Myers Park (Charlotte) 10
H Mallard Creek (Charlotte) 42
A Swain County 28
H Mitchell 21
A Sun Valley (Monroe) 21
H Mooresville 42
A Andrews 13
H Murphy 56
A Bluffton 21
H Myrtle Beach 7
A New Hanover (Wilmington) 20
H New Bern 31
A South Florence 20
H North Augusta 46
A Jones Senior 22
H North Edgecombe 12
A Butler (Matthews) 26
H Page (Greensboro) 40
A Mt. Tabor (Winston-Salem) 28
H Porter Ridge (Indian Trail) 31
A Hillside (Durham) 7
H Scotland 35
A Bandys (Catawba) 16
H Shelby 41
A Fairfield Central 16
H South Pointe (Rock Hill) 35
A Salisbury 16
H Thomasville 27
A Red Springs 19
H Wallace-Rose Hill 34
A Concord 14
H West Rowan 22
A South Iredell 14
H West Stokes 28
A Daniel (Central) 7
H York 10