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 = 22 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 ('1987-10-02') AND date_add('1987-10-02',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name Chris Hughes' CarolinaPreps.com | Your Digital Destination for High School Football News & Information Array
Array

<< October 1987 >>
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
31
Friday's Game 10/02
A Strom Thurmond (Johnston)
H A.C. Flora (Columbia)
A Enka (Candler)
H A.C. Reynolds (Asheville)
A R.J. Reynolds (Winston-Salem) 7
H A.L. Brown (Kannapolis) 35
A Roanoke
H Ahoskie
A C.A. Johnson (Columbia)
H Aiken
A Monroe 13
H Albemarle 3
A East Burke
H Alexander Central
A East Wilkes
H Alleghany
A Baptist Hill (Yonges Island)
H Allendale-Fairfax
A Robbinsville 44
H Andrews 6
A Hoke County 28
H Anson County 14
A Ben L. Smith (Greensboro) 7
H Asheboro 13
A North Pitt 16
H Ayden-Grifton 14
A Maiden 34
H Bandys (Catawba) 0
A Swansea
H Barnwell
A Walter Williams (Burlington) 30
H Bartlett Yancey 20
A Abbeville
H Batesburg-Leesville
A Walhalla
H Belton-Honea Path
A Wando (Mt. Pleasant)
H Berkeley (Moncks Corner)
A Pendleton
H Blacksburg
A Orrum
H Bladenboro
A Bessemer City 13
H Bunker Hill (Claremont) 28
A Clayton
H Bunn
A Chase (Forest City)
H Burns (Lawndale)
A Spartanburg
H Byrnes (Duncan)
A Farmville Central
H C.B. Aycock (Pikeville)
A Bamberg-Ehrhardt
H Calhoun County
A Manning
H Camden
A Gates County
H Camden County
A E.E. Smith (Fayetteville) 27
H Cape Fear (Fayetteville) 12
A Enloe (Raleigh)
H Cary
A Lamar
H Central (Pageland)
A West Rowan 10
H Central Cabarrus 15
A Northern Durham 42
H Chapel Hill 7
A Mid-Carolina (Prosperity)
H Chapin
A Piedmont (Monroe) 20
H Charlotte Catholic 36
A Liberty
H Chesnee
A Sumter
H Chester
A Pelion
H Chesterfield
A Chapman (Inman)
H Clinton
A Newberry
H Clover
A Keenan (Columbia)
H Columbia
A Forest Hills (Marshville) 13
H Concord 16
A South Florence
H Conway
A Ashbrook (Gastonia) 18
H Crest (Boiling Springs) 8
A Southern Alamance
H Cummings (Burlington)
A Socastee (Myrtle Beach)
H Dillon
A Christ Church (Greenville)
H Dixie (Due West)
A Union County
H Dorman (Roebuck)
A Seventy-First (Fayetteville) 22
H Douglas Byrd (Fayetteville) 0
A Fairmont
H East Bladen
A South Lenoir
H East Duplin
A Sun Valley (Indian Trail) 7
H East Rowan 14
A Surry Central
H East Surry
A Northwest Guilford
H Eastern Guilford
A Graham 7
H Eastern Randolph 13
A North Buncombe
H Erwin (Asheville)
A York
H Fairfield Central
A Kinston
H Fike (Wilson)
A Broome (Spartanburg)
H Fort Mill
A T.C. Roberson (Asheville)
H Franklin
A Lincolnton 10
H Freedom (Morganton) 20
A South Johnston
H Fuquay-Varina
A Rock Hill
H Gaffney
A Myers Park (Charlotte) 20
H Garinger (Charlotte) 17
A Athens Drive (Raleigh) 16
H Garner 46
A North Charleston
H Goose Creek
A Hannah Pamplico
H Green Sea-Floyds
A Pamlico County
H Greene Central
A Airport (West Columbia)
H Greenwood
A Woodmont (Piedmont)
H Greer
A North Mecklenburg 0
H Harding (Charlotte) 31
A Lake City
H Hartsville
A Washington
H Havelock
A Owen (Black Mountain) 3
H Hendersonville 0
A South Caldwell
H Hickory
A Easley
H Hillcrest (Simpsonville)
A J.F. Webb (Oxford)
H Hillside (Durham)
A Rosewood
H Hobbton (Newton Grove)
A Pine Forest (Fayetteville) 6
H Hope Mills South View 24
A Northeastern (Elizabeth City)
H Hunt (Wilson)
A Hunter Huss (Gastonia) 7
H Independence (Charlotte) 0
A Buford (Lancaster)
H Indian Land
A North Augusta
H Irmo
A Rocky Mount
H J.H. Rose (Greenville)
A Mullins
H Johnsonville
A Topsail
H Jones
A Person County
H Jordan (Durham)
A Latta
H Lake View
A Richland Northeast
H Lancaster
A Goldsboro
H Laney (Wilmington)
A Mauldin
H Laurens
A Purnell Swett (Pembroke)
H Lee County
A Swansboro
H Lejeune
A Andrew Jackson (Kershaw)
H Lewisville
A Ledford (Thomasville) 0
H Lexington 13
A Orangeburg-Wilkinson
H Lexington
A North Johnston
H Louisburg
A Great Falls
H Lugoff-Elgin
A Sanderson (Raleigh) 6
H Millbrook (Raleigh) 29
A West Lincoln 14
H Mooresville 20
A Cherokee 7
H Murphy 49
A Cheraw
H Myrtle Beach
A Hoggard (Wilmington)
H New Bern
A Eastern Wayne
H New Hanover
A Cherryville
H Newton-Conover
A Calhoun Falls
H Ninety Six
A Davie County 28
H North Davidson 10
A Princeton
H North Duplin
A Columbia
H North Edgecombe
A R-S Central
H North Gaston
A North Surry 6
H North Iredell 28
A Northwood (Pittsboro) 0
H North Moore 6
A West Davidson 10
H North Rowan 19
A Parkwood (Monroe) 20
H North Stanly 19
A West Wilkes
H North Wilkes
A Manteo
H Northampton County West
A Western Guilford 14
H Northeast Guilford 20
A Beddingfield (Wilson)
H Northern Nash
A West Montgomery 0
H Northwest Cabarrus 10
A Boiling Springs
H Northwestern (Rock Hill)
A East Gaston 16
H Olympic (Charlotte) 14
A Durham 6
H Orange (Hillsborough) 24
A Dudley (Greensboro) 13
H Page (Greensboro) 31
A Mount Tabor (Winston-Salem) 0
H Parkland (Winston-Salem) 14
A Harrells Christian
H Parkton
A Currituck County
H Perquimans
A Scotland 12
H Pinecrest (Southern Pines) 14
A Asheville
H Pisgah (Canton)
A Rockingham County 7
H Reidsville 9
A Lumberton 0
H Richmond County 26
A Greenville
H Riverside (Greer)
A Holmes (Edenton)
H Roanoke Rapids
A Madison County
H Rosman
A Tar Heel 0
H Saint Pauls 34
A Southwest Guilford 33
H Salisbury 21
A McCormick 7
H Saluda 20
A Kings Mountain 0
H Shelby 28
A Triton (Erwin)
H Smithfield-Selma
A North Brunswick
H South Brunswick
A Forbush (East Bend) 8
H South Iredell 54
A East Mecklenburg 28
H South Mecklenburg 0
A East Rutherford
H South Point (Belmont)
A West Columbus 13
H South Robeson 27
A East Forsyth
H South Stokes
A Bertie County
H Southeast Halifax
A Northwest Halifax
H Southern Nash
A Jacksonville
H Southern Wayne
A Palmetto (Williamston)
H Southside (Greenville)
A Richlands 10
H Southwest Onslow 14
A East Montgomery 47
H Southwestern Randolph 6
A Eau Claire (Columbia)
H Spring Valley (Columbia)
A Charlotte Country Day 7
H St. John's 40
A North Stokes
H Starmount (Boonville)
A West Iredell 7
H Statesville 19
A Georgetown
H Summerville
A Hayesville 14
H Swain County 42
A Daniel (Central)
H T.L. Hanna (Anderson)
A Littlefield (Lumberton)
H Tabor City
A SouthWest Edgecombe
H Tarboro
A Randleman 5
H Thomasville 42
A Carolina (Greenville)
H Travelers Rest
A East Henderson
H Tuscola (Waynesville)
A Lakewood (Salemburg)
H Union (Clinton)
A Chatham Central 7
H Union Pines (Cameron) 41
A Warren County
H Vance County
A Eastside (Taylors)
H Wade Hampton (Greenville)
A South Granville
H Wake Forest
A East Carteret
H Wallace-Rose Hill
A Whitmire
H Ware Shoals
A McDowell County
H Watauga County
A Whiteville 19
H West Brunswick 7
A D.H. Conley (Greenville)
H West Carteret
A West Mecklenburg 10
H West Charlotte 7
A North Lenoir
H West Craven
A South Rowan 24
H West Forsyth 0
A South Stanly 48
H West Stanly 6
A Eastern Alamance
H Western Alamance
A Pender County
H Western Harnett
A Terry Sanford (Fayetteville) 18
H Westover (Fayetteville) 15
A Plymouth
H Williamston
A Wagener-Salley
H Williston-Elko
A West Florence
H Wilson (Florence)
A Crescent (Iva)
H Woodruff
A Seneca
H Wren (Piedmont)
A Franklinton
H Zebulon