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 = 39 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 ('2009-11-27') AND date_add('2009-11-27',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 2009 >>
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/27
A Mt. Tabor (Winston-Salem) 7
H A.C. Reynolds (Asheville) 9
A South Point (Belmont) 24
H A.L. Brown (Kannapolis) 7
A Central (Pageland) 34
H Abbeville 7
A Swain County 27
H Albemarle 28
A East Mecklenburg 8
H Butler (Matthews) 58
A Spartanburg 16
H Byrnes (Duncan) 51
A Eastern Alamance 28
H Cardinal Gibbons (Raleigh) 0
A Daniel (Central) 28
H Clinton 35
A Manning 14
H Dillon 30
A Gaffney 0
H Dorman (Roebuck) 10
A Ragsdale (Jamestown) 7
H Dudley (Greensboro) 13
A Jordan-Matthews (Siler City) 8
H East Bladen 14
A Newton-Conover 35
H East Lincoln 14
A Robbinsville 40
H Elkin 6
A Trask (Rocky Point) 6
H Goldsboro 20
A Berkeley 38
H Goose Creek 35
A Southern Nash 13
H Gray's Creek (Hope Mills) 6
A Middle Creek (Apex) 8
H Harnett Central 14
A Havelock 29
H Hertford County 22
A Tuscola (Waynesville) 28
H Hibriten (Lenoir) 27
A Lumberton 14
H Jack Britt (Fayetteville) 28
A North Edgecombe 16
H Jones Senior 8
A Chesterfield 36
H Lamar 6
A Princeton 20
H Mount Airy 51
A Lincolnton 21
H Mountain Heritage 27
A Marlboro County 13
H Myrtle Beach 40
A Anson 34
H Northern Guilford 32
A South Pointe (Rock Hill) 6
H Northwestern (Rock Hill) 24
A Kinston 34
H Northwood (Pittsboro) 21
A Salisbury 35
H Pisgah (Canton) 7
A Independence (Charlotte) 46
H Richmond 27
A New Hanover (Wilmington) 21
H Southern Durham 10
A Reidsville 22
H SouthWest Edgecombe 20
A Pender 14
H Southwest Onslow 48
A Whiteville 0
H Tarboro 41
A Lexington 28
H Thomasville 21
A Fuquay-Varina 6
H Wake Forest 26
A Asheville 14
H West Rowan 28
Saturday's Game 11/28
A Douglas Byrd (Fayetteville) 12
H South Johnston 41