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-15') AND date_add('2002-11-15',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/15
A Olympic (Charlotte) 9
H A.C. Reynolds (Asheville) 62
A Smoky Mountain 24
H A.L. Brown (Kannapolis) 30
A Chapman 0
H Abbeville 14
A East Wilkes 0
H Albemarle 55
A Central (Pageland) 22
H Allendale Fairfax 19
A Weddington 20
H Ashbrook (Gastonia) 48
A St. Stephens 3
H Asheville 47
A West Iredell 7
H Bandys (Catawba) 47
A Asheboro 30
H Bertie 27
A Mount Airy 19
H Bessemer City 30
A Red Springs 7
H Brevard 12
A Cary 16
H Broughton (Raleigh) 22
A North Iredell 10
H Burns (Lawndale) 47
A East Burke 6
H Butler (Matthews) 42
A Erwin (Asheville) 20
H Carver (Winston-Salem) 54
A North Henderson 7
H Charlotte Catholic 41
A Princeton 0
H Cherokee 58
A Ben L. Smith (Greensboro) ForfeitedForfeit
H Clayton Double
A Bunn 20
H Clinton 42
A Jones Senior 6
H Columbia 30
A Northwest Cabarrus 28
H Concord 14
A West Rowan 7
H Crest (Boiling Springs) 19
A North Rowan 7
H Cummings (Burlington) 54
A McDowell 14
H Davie County 36
A Sumter 35
H Dorman (Roebuck) 28
A Webb (Oxford) 14
H Dudley (Greensboro) 41
A Chapel Hill 26
H E.E. Smith (Fayetteville) 37
A Southeast Halifax 0
H East Duplin 55
A Millbrook (Raleigh) 21
H East Wake 24
A Harnett Central 0
H Eastern Randolph 36
A Andrews 8
H Elkin 56
A Perquimans 6
H Farmville Central 28
A Spartanburg 44
H Fort Dorchester (N. Charleston) 7
A Statesville 8
H Franklin 41
A Gates County 24
H Franklinton 21
A Myers Park (Charlotte) 6
H Freedom (Morganton) 35
A Lumberton 41
H Garner 20
A Kings Mountain 28
H Glenn (Kernersville) 40
A Northeast Guilford
H Goldsboro Forfeited
A Central Davidson 0
H Graham 21
A Currituck County 7
H Greene Central 34
A Richmond 70
H Harding (Charlotte) 16
A North Stokes 8
H Hayesville 35
A West Davidson 6
H Hendersonville 12
A Salisbury 18
H Hibriten (Lenoir) 53
A East Gaston 20
H Hickory 27
A Eastern Wayne
H High Point Central Forfeited
A C.B. Aycock (Pikeville) 14
H Hillside (Durham) 21
A Chatham Central 0
H Hobbton (Newton Grove) 57
A Sanderson (Raleigh) 7
H Hoggard (Wilmington) 35
A Whiteville 30
H Holmes (Edenton) 0
A Grimsley (Greensboro) 0
H Independence (Charlotte) 56
A Jacksonville 0
H J.H. Rose (Greenville) 46
A North Mecklenburg 8
H Jack Britt (Fayetteville) 38
A Topsail 45
H Jordan-Matthews (Siler City) 27
A Highland Tech (Gastonia) 0
H Lakewood 49
A Apex 9
H Laney (Wilmington) 0
A Southern Guilford 0
H Ledford 41
A Providence (Charlotte) 54
H Lee County 21
A North Wilkes 7
H Lexington 45
A Dixon 14
H Louisburg 58
A South Stokes 7
H Maiden 37
A Washington 14
H Manteo 35
A Forbush 14
H Monroe 47
A Enka 7
H Mooresville 49
A Lincolnton 0
H Mount Pleasant 21
A Hoke County 21
H Mt. Tabor (Winston-Salem) 14
A Surry Central 6
H Murphy 21
A Camden 49
H Myrtle Beach 7
A Seventy-First (Fayetteville) 0
H New Bern 23
A Person (Roxboro) 55
H New Hanover (Wilmington) 28
A Avery 26
H Newton-Conover 42
A Ayden-Grifton 16
H North Brunswick 46
A West Mecklenburg 14
H North Davidson 19
A Union 12
H North Edgecombe 42
A West Charlotte 28
H North Forsyth 20
A Northwood (Pittsboro) 0
H North Pitt 8
A Western Alamance 28
H Northeastern (Elizabeth City) 3
A Douglas Byrd (Fayetteville) 24
H Northern Durham 19
A Cape Fear (Fayetteville) 0
H Northern Nash 22
A East Rutherford 7
H Owen (Black Mountain) 33
A South Rowan
H Page (Greensboro) Forfeited
A Midway 19
H Pamlico County 34
A East Lincoln 7
H Parkland (Winston-Salem) 41
A Hunt (Wilson) 37
H Pender 0
A Tuscola (Waynesville) 7
H Piedmont (Monroe) 39
A North Surry 9
H Pisgah (Canton) 56
A Kinston 0
H R.L. Fike (Wilson) 50
A Forestview (Gastonia) 6
H Ragsdale (Jamestown) 38
A Warren County 8
H Reidsville 42
A Tarboro 27
H Richlands 35
A Fuquay-Varina 21
H Riverside (Durham) 49
A Fairmont 8
H Roanoke Rapids 7
A Alleghany 3
H Robbinsville 13
A T.C. Roberson (Asheville) 24
H Robinson (Concord) 7
A Mitchell 13
H Shelby 27
A Croatan (Newport) 17
H South Columbus 57
A Anson 13
H South Point (Belmont) 38
A Chase (Forest City) 22
H South Robeson 23
A Rosman 6
H South Stanly 28
A Enloe (Raleigh) 0
H South View (Hope Mills) 42
A Pine Forest (Fayetteville) 14
H Southeast Raleigh 15
A Smithfield-Selma 22
H Southern Alamance 49
A Southeast Guilford 7
H Southern Durham 42
A Weldon 20
H Southside (Beaufort) 45
A East Bladen 12
H Southwest Onslow 33
A Cherryville 7
H Starmount (Boonville) 49
A Gaffney 27
H Summerville 37
A South Davidson 6
H Swain County 28
A North Lenoir
H T.W. Andrews (High Point) Forfeited
A Polk County 0
H Thomasville 42
A West Carteret 0
H Trinity 28
A Walter Williams (Burlington) 10
H Triton (Erwin) 7
A Scotland 35
H Vance (Charlotte) 20
A Rocky Mount 33
H Wakefield (Raleigh) 41
A Spring Creek 13
H Wallace-Rose Hill 70
A R.J. Reynolds (Winston-Salem) 24
H Watauga 9
A West Henderson 10
H West Caldwell 13
A Northside (Jacksonville) 16
H West Columbus 13
A Beddingfield (Wilson) 20
H West Craven 28
A East Mecklenburg 3
H West Forsyth 13
A Jordan (Durham) 6
H Western Harnett 18
A Morehead (Eden) 21
H White Oak (Jacksonville) 52