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 = 2 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 ('2003-11-11') AND date_add('2003-11-11',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 2003 >>
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
      
Thursday's Game 11/13
A East Gaston 15
H High Point Central 21
Friday's Game 11/14
A Burns (Lawndale) 12
H A.L. Brown (Kannapolis) 37
A Pendleton 36
H Abbeville 42
A Richland Northeast (Columbia) 28
H Aiken 12
A West Davidson 6
H Albemarle 23
A Mooresville 0
H Ashbrook (Gastonia) 20
A Statesville 27
H Asheville 37
A West Henderson 21
H Bandys (Catawba) 42
A Pine Forest (Fayetteville) 45
H Broughton (Raleigh) 37
A Holmes (Edenton) 14
H Bunn 7
A Forbush 6
H Charlotte Catholic 26
A Charlotte Latin 26
H Charlotte Country Day 14
A Triton (Erwin) 19
H Clayton 10
A Hunter Huss (Gastonia) 6
H Concord 55
A Hickory 0
H Crest (Boiling Springs) 19
A Lincolnton 7
H Cummings (Burlington) 35
A Colleton County 0
H Dorman (Roebuck) 28
A Jack Britt (Fayetteville) 14
H E.E. Smith (Fayetteville) 17
A Richlands 6
H East Bladen 45
A Hunt (Wilson) 9
H Eastern Randolph 17
A Lakewood 6
H Elkin 57
A Franklinton 3
H Farmville Central 48
A Greenwood 37
H Goose Creek 30
A South Columbus 27
H Graham 8
A South View (Hope Mills) 35
H Green Hope (Cary) 16
A East Duplin 14
H Greene Central 27
A Rosman 28
H Hayesville 20
A Maiden 12
H Hendersonville 34
A East Rutherford 10
H Hibriten (Lenoir) 31
A Robbinsville 18
H Hobbton (Newton Grove) 24
A New Hanover (Wilmington) 12
H Hoggard (Wilmington) 14
A Hopewell (Huntersville) 6
H Independence (Charlotte) 41
A Wakefield (Raleigh) 2
H J.H. Rose (Greenville) 38
A Goldsboro 33
H Kinston 16
A Topsail 32
H Louisburg 61
A North Davidson 21
H Mt. Tabor (Winston-Salem) 28
A Jordan (Durham) 0
H New Bern 28
A Northside (Beaufort) 0
H North Duplin 14
A Northern Nash 7
H Northern Durham 21
A Fort Dorchester (N. Charleston) 34
H Northwestern (Rock Hill) 27
A Western Guilford 32
H Northwood (Pittsboro) 13
A Whiteville 28
H Owen (Black Mountain) 21
A Davie County 34
H Page (Greensboro) 14
A Ayden-Grifton 27
H Pamlico County 17
A Glenn (Kernersville) 3
H Parkland (Winston-Salem) 7
A Forest Hills (Marshville) 21
H Pisgah (Canton) 0
A Murphy 25
H Polk County 19
A Scotland 7
H Providence (Charlotte) 21
A Northeast Guilford 34
H R.L. Fike (Wilson) 22
A Southern Alamance 24
H Ragsdale (Jamestown) 31
A Ledford 10
H Reidsville 21
A Butler (Matthews) 6
H Richmond 20
A Franklin 0
H South Point (Belmont) 42
A Garner 7
H Southeast Raleigh 35
A Dudley (Greensboro) 0
H Southern Durham 5
A Tarboro 8
H Southwest Onslow 41
A Thomasville 21
H Starmount (Boonville) 7
A Ridge View (Columbia) 21
H Summerville 24
A Mount Airy 8
H Swain County 38
A James Kenan (Warsaw) 0
H Wallace-Rose Hill 44
A West Carteret 20
H West Brunswick 27
A South Rowan 20
H West Charlotte 21
A Beddingfield (Wilson) 13
H West Craven 48
A East Burke 0
H West Forsyth 23
A St. Pauls 8
H Western Alamance 37