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-11-20') AND date_add('1987-11-20',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

<< November 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
     
Friday's Game 11/20
A Marion
H Aiken
A Mid-Carolina (Prosperity)
H Andrew Jackson (Kershaw)
A Cummings (Burlington) 6
H Asheboro 7
A Holmes (Edenton) 13
H Ayden-Grifton 30
A Lower Richland
H Berkeley (Moncks Corner)
A Starmount (Boonville) 27
H Bunker Hill (Claremont) 59
A Chapin
H Central (Pageland)
A Manning
H Cheraw
A North Pitt
H Clayton
A Belton-Honea Path
H Clinton
A Sumter
H Conway
A Hartsville
H Dillon
A East Bladen
H East Duplin
A R-S Central
H Erwin (Asheville)
A A.C. Reynolds (Asheville) 7
H Freedom (Morganton) 14
A Whiteville
H Fuquay-Varina
A Great Falls
H Gilbert
A Ashbrook (Gastonia) 13
H Harding (Charlotte) 18
A Rosman
H Hayesville
A Jacksonville
H J.H. Rose (Greenville)
A Timmonsville
H Lake View
A Blackville-Hilda
H Lewisville
A Lexington 28
H Monroe 7
A Mount Airy
H Newton-Conover
A Columbia
H North Edgecombe
A West Caldwell 27
H North Iredell 7
A East Montgomery 21
H North Moore 14
A Gates County
H Northampton County West
A New Hanover 27
H Northern Durham 35
A Gaffney
H Northwestern (Rock Hill)
A Grimsley (Greensboro) 10
H Page (Greensboro) 7
A Clarkton
H Richlands
A Lee County 6
H Richmond County 21
A Garner 28
H Richmond County 24
A Greer
H Riverside (Greer)
A Red Springs 8
H Saint Pauls 7
A South Point (Belmont) 6
H Shelby 41
A Mullins 0
H Silver Bluff (Aiken) 16
A Lincolnton 17
H South Iredell 7
A Bertie County
H SouthWest Edgecombe
A Hobbton (Newton Grove) 7
H Southwest Onslow 28
A Greenwood
H Spartanburg
A Barnwell 21
H St. John's 7
A Spring Valley (Columbia)
H Summerville
A Murphy 47
H Swain County 6
A West Craven
H Tarboro
A Charlotte Catholic 14
H Thomasville 21
A Brookland-Cayce
H Wade Hampton (Greenville)
A Northwest Guilford
H Walter Williams (Burlington)
A Hunter Huss (Gastonia) 0
H West Mecklenburg 22
A Laurens 41
H Westside (Anderson) 42