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 = 3 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 ('2004-11-13') AND date_add('2004-11-13',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 2004 >>
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
    
Saturday's Game 11/13
A Surry Central 0
H Albemarle 41
A Olympic (Charlotte) 6
H Alexander Central 17
A North Gaston 7
H Burns (Lawndale) 28
A South Aiken 3
H Byrnes (Duncan) 45
A R-S Central 14
H Carver (Winston-Salem) 38
A Trinity 9
H Crest (Boiling Springs) 21
A Providence (Charlotte) 0
H Grimsley (Greensboro) 12
A West Carteret 22
H Hertford County 41
A White Oak (Jacksonville) 27
H Kinston 14
A South Stokes 32
H Maiden 53
A West Forsyth 7
H Mt. Tabor (Winston-Salem) 47
A Enloe (Raleigh) 6
H New Bern 39
A West Iredell 8
H North Surry 19
A Douglas Byrd (Fayetteville) 15
H Northern Durham 23
A East Rowan 10
H Parkland (Winston-Salem) 27
A Westover (Fayetteville) 45
H Person (Roxboro) 14
A Northwood (Pittsboro) 7
H Reidsville 41
A Middle Creek (Apex) 16
H Riverside (Durham) 7
A Cape Fear (Fayetteville) 20
H Rocky Mount 45
A Ashe County 20
H Salisbury 41
A Southeast Raleigh 0
H South View (Hope Mills) 21
A Ragsdale (Jamestown) 20
H Southern Alamance 0
A Jones Senior 0
H Southside (Beaufort) 55
A North Lincoln 20
H Starmount (Boonville) 56
A Richlands 24
H Tarboro 14
A East Surry 18
H Thomasville 41
A Farmville Central 18
H Trask (Rocky Point) 12
A Southwestern Randolph 7
H Walter Williams (Burlington) 35
A Glenn (Kernersville) 7
H West Rowan 36
Thursday's Game 11/18
A Gaffney 14
H Rock Hill 15
Friday's Game 11/19
A Broome (Spartanburg) 28
H Abbeville 7
A Greenwood 30
H Aiken 49
A Bessemer City 15
H Albemarle 56
A Cheraw 31
H Andrews 0
A A.L. Brown (Kannapolis) 22
H Ashbrook (Gastonia) 30
A Tuscola (Waynesville) 14
H Asheville 28
A Midway 28
H Ayden-Grifton 58
A East Carteret 51
H Bunn 37
A Anson 18
H Burns (Lawndale) 28
A T.L. Hanna (Anderson) 7
H Byrnes (Duncan) 28
A North Edgecombe 14
H Camden County 20
A Manning 45
H Carolina Forest (Myrtle Beach) 35
A Franklin 25
H Carver (Winston-Salem) 41
A Pisgah (Canton) 21
H Charlotte Catholic 27
A Charlotte Latin 14
H Charlotte Country Day 38
A Fairfield Central 12
H Clinton 15
A East Henderson 3
H Concord 34
A Piedmont (Monroe) 28
H Crest (Boiling Springs) 63
A East Bladen 35
H Cummings (Burlington) 56
A South Caldwell 6
H Davie County 49
A Crestwood (Sumter) 9
H Dillon 26
A Ashley (Wilmington) 26
H E.E. Smith (Fayetteville) 63
A Northwest Guilford 14
H East Burke 10
A Lincolnton 0
H East Rutherford 22
A Wake Forest 34
H East Wake 31
A Walter Williams (Burlington) 41
H Eastern Randolph 10
A Hayesville 6
H Elkin 30
A Monroe 37
H Forbush 21
A Beaufort 35
H Goose Creek 14
A Apex 14
H Green Hope (Cary) 40
A Belton-Honea Path 24
H Greer 7
A White Oak (Jacksonville) 3
H Hertford County 28
A Bandys (Catawba) 16
H Hibriten (Lenoir) 10
A Dudley (Greensboro) 22
H High Point Central 7
A East Wilkes 18
H Hobbton (Newton Grove) 34
A New Bern 34
H Hoggard (Wilmington) 20
A Westover (Fayetteville) 13
H Hoke County 40
A East Duplin 16
H Holmes (Edenton) 13
A C.B. Aycock (Pikeville) 0
H Hunt (Wilson) 20
A Grimsley (Greensboro) 14
H Independence (Charlotte) 47
A Conway 6
H Irmo 9
A Jordan (Durham) 7
H Jack Britt (Fayetteville) 13
A Southeast Guilford 27
H Jacksonville 55
A Pamlico County 17
H James Kenan (Warsaw) 6
A Hemingway 7
H Lamar 25
A Northwestern (Rock Hill) 28
H Lexington 0
A Hendersonville 0
H Maiden 20
A Cary 14
H Millbrook (Raleigh) 20
A North Mecklenburg 14
H Mt. Tabor (Winston-Salem) 35
A Farmville Central 34
H North Brunswick 28
A Western Alamance 34
H North Lenoir 13
A J.H. Rose (Greenville) 20
H Northern Durham 17
A Richlands 13
H Northside (Jacksonville) 23
A Avery 6
H Owen (Black Mountain) 26
A West Rowan 19
H Parkland (Winston-Salem) 22
A Ninety Six 22
H Pendleton 20
A Thomasville 27
H Polk County 6
A Nash Central 28
H R.L. Fike (Wilson) 20
A Ledford 0
H Reidsville 40
A Myers Park (Charlotte) 7
H Richmond 35
A Union 28
H Robbinsville 27
A Middle Creek (Apex) 7
H Rocky Mount 40
A North Surry 8
H Salisbury 47
A Brevard 0
H Shelby 38
A Lee County 0
H South View (Hope Mills) 36
A Ragsdale (Jamestown) 41
H Southern Durham 48
A Clinton 8
H Southwest Onslow 31
A Mount Airy 7
H Starmount (Boonville) 23
A Wando (Mt. Pleasant) 35
H Summerville 28
A Chatham Central 0
H Swain County 62
A East Gaston 0
H T.C. Roberson (Asheville) 45
A Northside (Beaufort) 42
H Weldon 14
A Beddingfield (Wilson) 28
H West Craven 20