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 = 17 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 ('2007-11-16') AND date_add('2007-11-16',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 2007 >>
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/16
A Charlotte Catholic 19
H A.L. Brown (Kannapolis) 14
A Chapman 23
H Abbeville 13
A East Surry 7
H Albemarle 24
A Franklin 17
H Anson 24
A Ardrey Kell (Charlotte) 28
H Ashbrook (Gastonia) 41
A Pisgah (Canton) 35
H Ashe County 14
A Statesville 0
H Asheville 24
A Chesterfield 21
H Bamberg-Ehrhardt 14
A West Craven 13
H Bertie 20
A Lincolnton 35
H Brevard 3
A Independence (Charlotte) 20
H Butler (Matthews) 7
A West Iredell 7
H Carver (Winston-Salem) 34
A Charlotte Christian 14
H Charlotte Latin 48
A South Stanly 28
H Cherokee 13
A Daniel (Central) 24
H Chester 48
A Cheraw 24
H Dillon 6
A Byrnes (Duncan) 31
H Dorman (Roebuck) 14
A Wallace-Rose Hill 7
H East Bladen 29
A Scotland 18
H East Burke 28
A Western Guilford 13
H Eastern Randolph 45
A Sumter 14
H Gaffney 21
A Millbrook (Raleigh) 49
H Garner 35
A Union County 31
H Greenville 14
A Clover 21
H Greenwood 9
A Ridge View (Columbia) 38
H Hartsville 34
A Glenn (Kernersville) 15
H Hickory 30
A J.H. Rose (Greenville) 30
H Hillside (Durham) 42
A Pine Forest (Fayetteville) 23
H Hoggard (Wilmington) 52
A Northwestern (Rock Hill) 41
H Irmo 24
A North Johnston 6
H James Kenan (Warsaw) 41
A Robbinsville 13
H Lakewood 14
A Carvers Bay (Hemingway) 41
H Lamar 7
A Camden County 8
H Louisburg 16
A Swain County 0
H Mount Airy 30
A Hibriten (Lenoir) 20
H Mount Pleasant 42
A Crest (Boiling Springs) 14
H Mt. Tabor (Winston-Salem) 40
A Crestwood (Sumter) 37
H Myrtle Beach 28
A Hunt (Wilson) 20
H Nash Central 53
A Athens Drive (Raleigh) 7
H New Bern 48
A Maiden 21
H Newton-Conover 28
A East Duplin 35
H North Brunswick 20
A Union 12
H North Duplin 30
A East Wilkes 28
H North Stokes 27
A Dudley (Greensboro) 18
H Northeast Guilford 13
A Southwest Onslow 7
H Northside (Jacksonville) 26
A Ledford 28
H Northwood (Pittsboro) 35
A Ayden-Grifton 0
H Pender 28
A A.C. Reynolds (Asheville) 21
H Purnell Swett (Pembroke) 22
A Cedar Ridge 12
H Reidsville 54
A East Mecklenburg 13
H Richmond 19
A South Granville 0
H Rocky Mount 52
A North Lincoln 21
H Salisbury 14
A West Henderson 7
H Shelby 41
A Chapel Hill 13
H Smithfield-Selma 7
A Bunn 0
H South Columbus 36
A Northwest Cabarrus 31
H South Point (Belmont) 70
A Berkeley 31
H South Pointe (Rock Hill) 21
A Jack Britt (Fayetteville) 23
H South View (Hope Mills) 34
A Fuquay-Varina 7
H Southern Durham 20
A Southern Lee 19
H Southern Wayne 28
A Southern Guilford 27
H St. Pauls 43
A Fort Dorchester (N. Charleston) 47
H Summerville 78
A Parkland (Winston-Salem) 0
H T.C. Roberson (Asheville) 37
A Jordan-Matthews (Siler City) 33
H Thomasville 21
A Halifax Academy 8
H Trinity Christian (Fayetteville) 16
A Leesville Road (Raleigh) 21
H Wake Forest 6
A Central Cabarrus 36
H Watauga 52
A Triton (Erwin) 13
H Webb (Oxford) 35
A Cummings (Burlington) 42
H West Bladen 39
A Grimsley (Greensboro)
H West Charlotte Forfeited
A East Lincoln 39
H West Davidson 16
A North Gaston 35
H West Rowan 22
A Hertford County 10
H Western Alamance 37
A Atkins (Winston-Salem) 38
H Wilkes Central 41