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-25') AND date_add('2008-11-25',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/28
A South Mecklenburg 10
H A.C. Reynolds (Asheville) 7
A Midway 17
H Ayden-Grifton 32
A A.L. Brown (Kannapolis) 28
H Charlotte Catholic 27
A Daniel (Central) 24
H Chester 27
A Timberland (St. Stephen) 27
H Dillon 28
A Byrnes (Duncan) 24
H Dorman (Roebuck) 13
A Cape Fear (Fayetteville) 27
H Douglas Byrd (Fayetteville) 30
A Ragsdale (Jamestown) 10
H Dudley (Greensboro) 26
A Pender 13
H East Bladen 28
A Richmond 38
H East Forsyth 24
A Hibriten (Lenoir) 13
H East Henderson 14
A Bandys (Catawba) 20
H East Lincoln 37
A Robbinsville 20
H Elkin 21
A South Brunswick 14
H Forest Hills (Marshville) 35
A Butler (Matthews) 7
H Independence (Charlotte) 49
A Weldon 26
H Jones Senior 40
A Anson 55
H Kings Mountain 56
A Cherokee 0
H Mount Airy 46
A Hendersonville 27
H Murphy 20
A Marlboro County 50
H Myrtle Beach 51
A Mountain Heritage 23
H Newton-Conover 44
A Clinton 3
H Northside (Jacksonville) 36
A Lancaster 14
H Northwestern (Rock Hill) 45
A Seventy-First (Fayetteville) 28
H Page (Greensboro) 3
A Northwood (Pittsboro) 20
H Reidsville 48
A Sumter 35
H Rock Hill 14
A Eastern Alamance 21
H Rocky Mount 42
A Starmount (Boonville) 17
H South Columbus 14
A Asheville 0
H South Point (Belmont) 28
A Laurens 14
H South Pointe (Rock Hill) 55
A Jack Britt (Fayetteville) 24
H South View (Hope Mills) 7
A Hillside (Durham) 30
H Southeast Raleigh 12
A Goldsboro 12
H Tarboro 28
A Albemarle 13
H Thomasville 24
A Apex 7
H Wake Forest 35
A SouthWest Edgecombe 27
H West Craven 42
A Carver (Winston-Salem) 16
H West Rowan 20