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 = 38 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 ('2008-11-20') AND date_add('2008-11-20',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 2008 >>
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/21
A R.J. Reynolds (Winston-Salem) 9
H A.C. Reynolds (Asheville) 16
A Marvin Ridge (Waxhaw) 13
H A.L. Brown (Kannapolis) 21
A Woodruff 38
H Abbeville 21
A Swain County 6
H Albemarle 27
A Olympic (Charlotte) 20
H Anson 55
A Goldsboro 42
H Bunn 26
A Providence (Charlotte) 7
H Butler (Matthews) 45
A Clover 7
H Byrnes (Duncan) 47
A Ayden-Grifton 46
H Camden County 19
A North Buncombe 11
H Carver (Winston-Salem) 27
A Erwin (Asheville) 13
H Charlotte Catholic 34
A Charlotte Christian 15
H Charlotte Latin 0
A Timberland (St. Stephen) 24
H Cheraw 21
A Lakewood 21
H Cherokee 41
A Bamberg-Ehrhardt 7
H Chesterfield 43
A Chester 24
H Clinton 14
A Laurens 10
H Conway 3
A South Mecklenburg 49
H Crest (Boiling Springs) 20
A Manning 7
H Dillon 10
A R.L. Fike (Wilson) 0
H Dudley (Greensboro) 46
A Topsail 12
H East Bladen 14
A Hopewell (Huntersville) 7
H East Forsyth 21
A Mount Pleasant 14
H East Henderson 33
A Lincolnton 7
H East Lincoln 24
A Hobbton (Newton Grove) 0
H Elkin 28
A Cardinal Gibbons (Raleigh) 12
H Forest Hills (Marshville) 26
A Douglas Byrd (Fayetteville) 17
H Fuquay-Varina 14
A Sumter 34
H Gaffney 31
A Lancaster 28
H Goose Creek 20
A Northeast Guilford 49
H Harnett Central 28
A Jordan-Matthews (Siler City) 7
H Hendersonville 35
A Eastern Alamance 15
H Hertford County 13
A Pisgah (Canton) 26
H Hibriten (Lenoir) 35
A Apex 6
H Hoggard (Wilmington) 3
A East Mecklenburg 16
H Independence (Charlotte) 43
A Rock Hill 26
H Irmo 3
A Garner 3
H Jack Britt (Fayetteville) 39
A Midway 13
H James Kenan (Warsaw) 10
A Manteo 36
H Jones Senior 48
A Mooresville 34
H Kings Mountain 41
A SouthWest Edgecombe 47
H Kinston 13
A Carvers Bay (Hemingway) 40
H Lamar 14
A Dorman (Roebuck) 38
H Lexington 14
A Pender 24
H Louisburg 20
A Camden 28
H Marlboro County 35
A South Stanly 6
H Mount Airy 50
A Seventy-First (Fayetteville) 14
H Mt. Tabor (Winston-Salem) 0
A East Surry 0
H Murphy 20
A Crestwood (Sumter) 20
H Myrtle Beach 36
A Cape Fear (Fayetteville) 48
H New Hanover (Wilmington) 27
A Bessemer City 21
H Newton-Conover 48
A Clinton 43
H Northeastern (Elizabeth City) 31
A North Brunswick 0
H Northside (Jacksonville) 27
A Richland Northeast (Columbia) 9
H Northwestern (Rock Hill) 49
A West Stokes 14
H Northwood (Pittsboro) 21
A South Brunswick 27
H Orange 20
A Westover (Fayetteville) 10
H Page (Greensboro) 28
A Western Guilford 3
H Ragsdale (Jamestown) 14
A North Pitt 6
H Reidsville 46
A North Duplin 0
H Robbinsville 38
A Webb (Oxford) 14
H Rocky Mount 48
A Bandys (Catawba) 22
H Shelby 21
A Lexington 27
H South Columbus 28
A T.W. Andrews (High Point) 14
H South Point (Belmont) 42
A Berkeley 14
H South Pointe (Rock Hill) 48
A Leesville Road (Raleigh) 24
H South View (Hope Mills) 41
A Middle Creek (Apex) 17
H Southeast Raleigh 47
A Hillside (Durham) 7
H Southern Durham 0
A West Davidson 13
H Starmount (Boonville) 37
A Franklinton 6
H Tarboro 38
A Asheville 31
H Tuscola (Waynesville) 10
A Lumberton 7
H Wake Forest 41
A Richmond 63
H West Charlotte 12
A Washington 7
H West Craven 28
A Statesville 14
H West Rowan 27
Saturday's Game 11/22
A Wilkes Central 7
H Mountain Heritage 34