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 = 15 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 ('2006-11-17') AND date_add('2006-11-17',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 2006 >>
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/17
A Alexander Central 18
H A.C. Reynolds (Asheville) 28
A Chesterfield 35
H Allendale Fairfax 0
A Southeast Guilford 35
H Asheboro 6
A Greer 10
H Blythewood 42
A Glenn (Kernersville) 14
H Burns (Lawndale) 21
A Gaffney 16
H Byrnes (Duncan) 13
A Franklin 0
H Carver (Winston-Salem) 28
A A.L. Brown (Kannapolis) 21
H Charlotte Catholic 36
A Charlotte Latin 28
H Charlotte Country Day 25
A Manning 0
H Cheraw 12
A North Stokes 8
H Cherokee 44
A Jordan-Matthews (Siler City) 12
H Cherryville 18
A Riverside (Greer) 0
H Clinton 42
A Berkeley 20
H Clover 9
A Asheville 13
H Concord 21
A West Charlotte 33
H Crest (Boiling Springs) 20
A North Rowan 0
H Cummings (Burlington) 47
A Central (Pageland) 12
H Dillon 27
A Eastern Randolph 27
H Dudley (Greensboro) 6
A Wallace-Rose Hill 14
H East Bladen 27
A Ayden-Grifton 13
H East Carteret 42
A Clinton 26
H East Duplin 13
A Mt. Tabor (Winston-Salem) 28
H East Gaston 34
A East Henderson 7
H East Lincoln 28
A Beddingfield (Wilson) 19
H Eastern Alamance 28
A Lakewood 0
H Elkin 35
A Bunn 7
H Farmville Central 0
A Stratford (Goose Creek) 14
H Fort Dorchester (N. Charleston) 7
A Hillside (Durham) 18
H Fuquay-Varina 21
A Jack Britt (Fayetteville) 14
H Garner 17
A Westside (Anderson) 36
H Goose Creek 27
A Ridge View (Columbia) 19
H Greenwood 34
A Butler (Matthews) 20
H Grimsley (Greensboro) 8
A Walter Williams (Burlington) 48
H Harnett Central 40
A Rocky Mount 32
H Hertford County 16
A Weldon 0
H Hobbton (Newton Grove) 35
A New Hanover (Wilmington) 15
H Hoggard (Wilmington) 49
A North Gaston 26
H Hunter Huss (Gastonia) 21
A West Forsyth 35
H Independence (Charlotte) 52
A Rock Hill 27
H Irmo 69
A East Wake 21
H J.H. Rose (Greenville) 47
A Louisburg 6
H James Kenan (Warsaw) 35
A Riverside (Durham) 21
H Jordan (Durham) 17
A Carvers Bay (Hemingway) 27
H Lamar 26
A Wake Forest 3
H Leesville Road (Raleigh) 7
A Newton-Conover 17
H Maiden 6
A Wilson (Florence) 30
H Marlboro County 7
A Timberland (St. Stephen) 24
H Myrtle Beach 20
A Rosman 0
H North Duplin 14
A Davie County 14
H North Mecklenburg 11
A Southwest Onslow 16
H Northeastern (Elizabeth City) 14
A North Brunswick 8
H Northside (Jacksonville) 28
A Ledford 21
H Northwood (Pittsboro) 40
A Sun Valley (Monroe) 13
H Olympic (Charlotte) 7
A North Johnston 7
H Pender 13
A Newberry 14
H Pendleton 7
A Bandys (Catawba) 7
H Pisgah (Canton) 41
A Mount Airy 15
H Polk County 8
A Brevard 14
H Reidsville 30
A Providence (Charlotte) 27
H Richmond 0
A McMichael (Mayodan) 29
H Salisbury 32
A Cary 20
H Seventy-First (Fayetteville) 43
A West Henderson 7
H Shelby 21
A Mount Pleasant 6
H South Iredell 12
A Avery 14
H South Stanly 22
A C.B. Aycock (Pikeville) 15
H Southern Alamance 42
A Bertie 20
H SouthWest Edgecombe 33
A Dutch Fork (Irmo) 35
H Summerville 21
A Northwest Cabarrus 14
H T.C. Roberson (Asheville) 10
A Southern Durham 35
H Terry Sanford (Fayetteville) 28
A Page (Greensboro) 14
H Watauga 15
A Anson 17
H West Rowan 7
A Forest Hills (Marshville) 31
H West Stanly 7
A South Central (Winterville) 27
H Western Alamance 42
A Owen (Black Mountain) 27
H Wilkes Central 13
A Conway 27
H York 0