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-24') AND date_add('2006-11-24',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name NCPreps.com - Chris Hughes' CarolinaPreps History Project | 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/24
A Watauga 24
H A.C. Reynolds (Asheville) 23
A Clinton 34
H Bunn 16
A Northwest Cabarrus 37
H Burns (Lawndale) 33
A Providence (Charlotte) 26
H Butler (Matthews) 34
A North Gaston (Dallas) 21
H Carver (Winston-Salem) 22
A Sun Valley (Monroe) 28
H Charlotte Catholic 35
A North Duplin 13
H Cherokee 0
A Blythewood 31
H Clinton 30
A Anson 3
H Concord 34
A Berkeley 17
H Conway 28
A Owen (Black Mountain) 14
H Cummings (Burlington) 51
A Cheraw 36
H Dillon 20
A East Bladen 30
H East Carteret 15
A West Charlotte 35
H East Gaston (Mount Holly) 25
A Southeast Guilford 19
H Eastern Randolph 24
A Hobbton (Newton Grove) 24
H Elkin 49
A Stratford (Goose Creek) 17
H Gaffney 26
A Seventy-First (Fayetteville) 12
H Garner 25
A Westside (Anderson) 7
H Greenwood 14
A Southern Durham 14
H Hoggard (Wilmington) 52
A Davie County 19
H Independence (Charlotte) 40
A Dutch Fork (Irmo) 10
H Irmo 14
A Fuquay-Varina 21
H J.H. Rose (Greenville) 28
A Pender 0
H James Kenan (Warsaw) 7
A Riverside (Durham) 27
H Leesville Road (Raleigh) 20
A Camden County 7
H Manteo 35
A Columbia 0
H Newberry 27
A Southwest Onslow 28
H Northside (Jacksonville) 35
A South Iredell 23
H Pisgah (Canton) 38
A Newton-Conover 29
H Reidsville 30
A Forest Hills (Marshville) 34
H Salisbury 21
A East Lincoln 14
H Shelby 30
A Mount Airy 21
H South Stanly 18
A Eastern Alamance 21
H SouthWest Edgecombe 20
A Cherryville 6
H Thomasville 35
A Southern Alamance 19
H Walter Williams (Burlington) 22
A Rocky Mount 37
H Western Alamance 41