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 = 11 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 ('1993-11-19') AND date_add('1993-11-19',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 1993 >>
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/19
A Richland Northeast
H Aiken
A Allendale-Fairfax
H Barnwell
A Central (Pageland)
H Batesburg-Leesville
A Dixie (Due West)
H Buford (Lancaster)
A Strom Thurmond (Johnston)
H Cheraw
A Fort Mill
H Clinton
A Ayden-Grifton 0
H Clinton 7
A Tuscola (Waynesville) 0
H Crest (Boiling Springs) 33
A James Kenan (Warsaw) 16
H Cummings (Burlington) 27
A Spartanburg
H Dorman (Roebuck)
A Garner 38
H Douglas Byrd (Fayetteville) 20
A Bladenboro 35
H East Montgomery 6
A Whiteville 26
H Eastern Alamance 0
A Pisgah (Canton) 21
H Forest Hills (Marshville) 0
A Irmo
H Gaffney
A Seneca
H Greer
A North Augusta
H Hartsville
A Rosman
H Hayesville
A Northeastern (Elizabeth City)
H Hillside (Durham) Forfeited
A Pamlico County
H Hobbton (Newton Grove)
A Hertford County
H Hunt (Wilson)
A Johnsonville
H Lake View
A Dillon
H Lancaster
A Smithfield-Selma 34
H Lee County 14
A Calhoun Falls
H Lewisville
A Starmount (Boonville) 33
H Lincolnton 49
A Lexington 7
H Maiden 30
A Glenn (Kernersville) 32
H Monroe 22
A Bandys (Catawba) 23
H Mooresville 26
A Beaufort 0
H Myrtle Beach 13
A Perquimans
H North Edgecombe
A South Robeson 21
H North Moore 7
A J.H. Rose (Greenville)
H Northern Durham
A Orangeburg-Wilkinson
H Northwestern (Rock Hill)
A Scotland 14
H Page (Greensboro) 21
A South Point (Belmont) 49
H Pisgah (Canton) 21
A Wake Forest 9
H Reidsville 14
A Asheville 10
H Shelby 17
A Swansea
H Silver Bluff (Aiken)
A McDowell County 14
H South Mecklenburg 19
A Midway (Dunn) 15
H Southwest Onslow 9
A Greenwood
H Summerville
A Robbinsville 7
H Swain County 9
A Forest Hills (Marshville)
H T.W. Andrews (High Point)
A West Craven
H Tarboro
A Randleman 27
H Thomasville 45
A Farmville Central
H Wallace-Rose Hill
A Eastern Randolph 12
H West Brunswick 43
A Olympic (Charlotte) 7
H West Charlotte 44
A Roanoke
H Williamston