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 = 8 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 ('1997-11-21') AND date_add('1997-11-21',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
You are here: Home / Scoreboard

<< November 1997 >>
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/21
A Burns (Lawndale) 16
H A.L. Brown (Kannapolis) 17
A North Rowan 6
H Bandys (Catawba) 27
A Edisto (Cordova)
H Barnwell
A Camden County
H Bunn
A Hartsville
H Byrnes (Duncan)
A Dudley (Greensboro) 14
H Carver (Winston-Salem) 13
A Andrew Jackson (Kershaw)
H Central (Pageland)
A Warren County 14
H Clinton 41
A Page (Greensboro) 12
H Crest (Boiling Springs) 27
A Midland Valley
H Daniel (Central)
A Fairfield Central
H Dillon
A Rock Hill
H Dorman (Roebuck)
A Northern Durham 12
H Douglas Byrd (Fayetteville) 35
A Brevard 22
H Eastern Randolph 25
A Owen (Black Mountain) 29
H Forest Hills (Marshville) 8
A Lexington
H Gaffney
A Concord 28
H Hickory 14
A Hertford County
H Hunt (Wilson)
A Cary 3
H J.H. Rose (Greenville) 31
A Midway (Dunn) 20
H James Kenan (Warsaw) 17
A East Rowan 13
H Kings Mountain 23
A Johnsonville
H Lake View
A Buford (Lancaster)
H Lamar
A Person County 14
H Laney (Wilmington) 21
A Berkeley (Moncks Corner)
H Laurens
A Cummings (Burlington) 28
H Maiden 20
A Garner 49
H Millbrook (Raleigh) 36
A Starmount (Boonville)
H Mount Airy
A West Charlotte 28
H Mount Tabor (Winston-Salem) 14
A South Robeson
H North Brunswick
A Northside (Pinetown)
H North Edgecombe
A J.F. Webb (Oxford) 15
H Northeast Guilford 33
A Richland Northeast
H Northwestern (Rock Hill)
A North Surry 20
H Ragsdale (Jamestown) 38
A Scotland 14
H Richmond County 34
A Lugoff-Elgin
H Ridge View (Columbia)
A High Point Central 13
H Shelby 49
A Swansea
H Silver Bluff (Aiken)
A Southwest Onslow 23
H South Columbus 34
A Blackville-Hilda
H St. John's
A Sumter
H Summerville
A Hayesville 6
H Swain County 7
A Rosman 14
H Thomasville 7
A Seneca
H Union County
A East Duplin 38
H West Brunswick 15
A Saint Pauls 13
H Western Alamance 21
A Smithfield-Selma
H Western Guilford
A Easley
H Wilson (Florence)
A Abbeville
H Woodruff
Saturday's Game 11/22
A Freedom (Morganton) 35
H Davie County 41