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 = 1 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 ('2002-11-19') AND date_add('2002-11-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

<< November 2002 >>
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/22
A West Charlotte 0
H A.C. Reynolds (Asheville) 14
A Burns (Lawndale) 42
H A.L. Brown (Kannapolis) 27
A Blue Ridge (Greer) 7
H Abbeville 28
A Bessemer City 14
H Albemarle 42
A Hickory 10
H Asheville 21
A Monroe 21
H Bandys (Catawba) 35
A Apex 22
H Broughton (Raleigh) 29
A Freedom (Morganton) 13
H Butler (Matthews) 35
A Northwest Cabarrus 7
H Carver (Winston-Salem) 54
A Mount Pleasant 14
H Charlotte Catholic 20
A High Point Central ForfeitedForfeit
H Clayton Double
A Northside (Jacksonville) 8
H Clinton 47
A North Duplin 26
H Columbia 0
A T.C. Roberson (Asheville) 10
H Crest (Boiling Springs) 34
A Person (Roxboro) 14
H E.E. Smith (Fayetteville) 17
A Whiteville 18
H East Duplin 26
A Hendersonville 12
H East Surry 35
A Lumberton 21
H East Wake 35
A Lakewood 8
H Elkin 36
A North Brunswick 6
H Farmville Central 27
A Ashbrook (Gastonia) 16
H Glenn (Kernersville) 14
A Asheboro
H Goldsboro Forfeited
A Western Alamance 17
H Greene Central 13
A South Stanly 0
H Hayesville 20
A Swain County 21
H Hobbton (Newton Grove) 26
A Wakefield (Raleigh) 16
H Hoggard (Wilmington) 24
A Jack Britt (Fayetteville) 13
H Independence (Charlotte) 51
A Douglas Byrd (Fayetteville) 38
H J.H. Rose (Greenville) 8
A Shelby 28
H Lexington 7
A Pamlico County 14
H Louisburg 21
A Thomasville 7
H Maiden 21
A Hunt (Wilson) 0
H Manteo 20
A Starmount (Boonville) 38
H Murphy 12
A Southeast Raleigh 7
H New Bern 14
A Cummings (Burlington) 40
H Newton-Conover 12
A Rosewood 43
H North Edgecombe 46
A Hibriten (Lenoir) 13
H Owen (Black Mountain) 24
A Davie County
H Page (Greensboro) Forfeited
A Parkland (Winston-Salem) 35
H Piedmont (Monroe) 38
A Hoke County 21
H R.J. Reynolds (Winston-Salem) 28
A Mooresville 27
H Ragsdale (Jamestown) 21
A North Pitt 14
H Reidsville 35
A Providence (Charlotte) 37
H Richmond 7
A Northern Nash 14
H Riverside (Durham) 7
A Cherokee 37
H Robbinsville 6
A Richlands 22
H South Columbus 29
A Franklin 27
H South Point (Belmont) 37
A Dudley (Greensboro) 27
H Southern Alamance 19
A Eastern Randolph 35
H Southern Durham 12
A Fairmont 2
H Southwest Onslow 12
A Spartanburg 14
H Summerville 34
A Walter Williams (Burlington) 28
H Trinity 42
A Topsail 14
H Wallace-Rose Hill 50
A Pisgah (Canton) 14
H West Caldwell 7
A Hillside (Durham) 14
H West Craven 34
A Scotland 7
H West Forsyth 6
A South View (Hope Mills) 34
H Western Harnett 13
A R.L. Fike (Wilson) 21
H White Oak (Jacksonville) 14