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 = 23 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 ('1986-09-19') AND date_add('1986-09-19',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

<< September 1986 >>
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 09/19
A Mount Pleasant 20
H Albemarle 17
A North Stokes 14
H Alleghany 15
A North Gaston 0
H Ashbrook (Gastonia) 48
A Western Guilford 6
H Asheboro 14
A Southern Wayne 7
H Beddingfield (Wilson) 14
A Cummings (Burlington) 21
H Ben L. Smith (Greensboro) 0
A Chesnee 16
H Bessemer City 6
A Enka 7
H Brevard 52
A St. Stephens 31
H Bunker Hill 20
A North Lenoir 8
H C.B. Aycock (Pikeville) 6
A West Iredell 21
H Central Cabarrus 0
A East Surry 6
H Central Davidson 28
A Hillside (Durham) 21
H Chapel Hill 9
A R-S Central 0
H Chase (Forest City) 6
A Gates County 26
H Columbia 29
A Charlotte Catholic 15
H Concord 34
A Farmville Central 6
H D.H. Conley (Greenville) 12
A East Forsyth 40
H Davie County 8
A Scotland 12
H Douglas Byrd (Fayetteville) 28
A Walter Williams (Burlington) 28
H Dudley (Greensboro) 35
A Watauga 0
H East Burke 20
A Union 6
H East Duplin 54
A South Point (Belmont) 12
H East Gaston 34
A West Henderson 9
H East Henderson 7
A West Lincoln 35
H East Lincoln 12
A Clinton 21
H East Wake 20
A West Wilkes 13
H East Wilkes 7
A Graham 33
H Eastern Guilford 13
A North Wilkes 14
H Elkin 7
A Broughton (Raleigh) 37
H Enloe (Raleigh) 0
A Madison 7
H Erwin (Asheville) 21
A St. Pauls 26
H Fairmont 0
A Clayton 49
H Franklinton 0
A Bandys (Catawba) 32
H Fred T. Foard (Newton) 0
A Millbrook (Raleigh) 26
H Garner 6
A East Mecklenburg 28
H Harding (Charlotte) 21
A Hobbton (Newton Grove) 27
H Harnett Central 0
A Mountain Heritage 6
H Hendersonville 41
A Wilkes Central 6
H Hibriten (Lenoir) 15
A Currituck County 0
H Holmes (Edenton) 33
A Crest (Boiling Springs) 3
H Hunter Huss (Gastonia) 21
A Eastern Wayne 14
H J.H. Rose (Greenville) 28
A Kinston 0
H Jacksonville 55
A Midway 19
H James Kenan (Warsaw) 7
A East Carteret 22
H Jones Senior 0
A West Carteret 13
H Lejeune 18
A Southwest Guilford 7
H Lexington 12
A Newton-Conover 14
H Lincolnton 6
A Cape Fear (Fayetteville) 0
H Lumberton 12
A McDowell 33
H Mitchell 6
A Parkwood (Monroe) 6
H Monroe 34
A Rockingham County 0
H Morehead (Eden) 24
A Asheville 20
H North Buncombe 14
A South Caldwell 16
H North Davidson 30
A R.J. Reynolds (Winston-Salem) 14
H North Forsyth 0
A Alexander Central 14
H North Iredell 12
A Bunn 12
H North Johnston 13
A South Mecklenburg 6
H North Mecklenburg 13
A Randleman 10
H North Rowan 0
A East Rowan 7
H North Stanly 20
A Mount Airy 6
H North Surry 38
A Southeast Guilford 6
H Northeast Guilford 20
A Southern Durham 0
H Northern Durham 29
A Southern Nash 6
H Northern Nash 28
A South Rowan 7
H Northwest Cabarrus 4
A Western Alamance 22
H Northwest Guilford 30
A Myers Park (Charlotte) 7
H Olympic (Charlotte) 27
A A.C. Reynolds (Asheville) 14
H Owen (Black Mountain) 31
A Grimsley (Greensboro) 15
H Page (Greensboro) 49
A West Craven 41
H Pamlico County 20
A Glenn (Kernersville) 0
H Parkland (Winston-Salem) 13
A Northeastern (Elizabeth City) 20
H Perquimans 26
A West Stanly 21
H Piedmont (Monroe) 0
A South View (Hope Mills) 21
H Pinecrest (Southern Pines) 12
A Southern Guilford 7
H Ragsdale (Jamestown) 35
A South Lenoir 8
H Richlands 2
A Warren County 13
H Roanoke Rapids 19
A Andrews 6
H Robbinsville 28
A Goldsboro 6
H Rocky Mount 34
A West Davidson 0
H Salisbury 17
A Apex 12
H Sanderson (Raleigh) 35
A Hoke County 0
H Seventy-First (Fayetteville) 29
A Hickory 12
H Shelby 33
A Cary 21
H Smithfield-Selma 7
A Pender 12
H South Johnston 0
A Hunt (Wilson) 0
H SouthWest Edgecombe 33
A White Oak (Jacksonville) 16
H Southwest Onslow 14
A North Moore 12
H Southwestern Randolph 14
A Forbush 7
H Starmount (Boonville) 28
A Mooresville 0
H Statesville 28
A Franklin 16
H Swain County 20
A Hoggard (Wilmington) 6
H Terry Sanford (Fayetteville) 48
A East Davidson 8
H Thomasville 34
A Eastern Randolph 35
H Trinity 8
A Athens Drive (Raleigh) 20
H Triton (Erwin) 7
A T.C. Roberson (Asheville) 12
H Tuscola (Waynesville) 33
A Northwood (Pittsboro) 18
H Union Pines (Cameron) 19
A Louisburg 18
H Wake Forest 13
A Swansboro 6
H Wallace-Rose Hill 43
A Ayden-Grifton 40
H Washington 12
A Person (Roxboro) 33
H Webb (Oxford) 10
A Laney (Wilmington) 28
H West Brunswick 0
A Freedom (Morganton) 10
H West Caldwell 14
A Independence (Charlotte) 0
H West Charlotte 10
A Carver (Winston-Salem) 7
H West Forsyth 7
A Garinger (Charlotte) 15
H West Mecklenburg 34
A South Iredell 35
H West Rowan 14
A Lakewood 6
H Western Harnett 28