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 = 40 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 ('2010-11-21') AND date_add('2010-11-21',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 2010 >>
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/26
A Porter Ridge (Indian Trail) 24
H A.C. Reynolds (Asheville) 21
A Charlotte Catholic 45
H A.L. Brown (Kannapolis) 7
A Hibriten (Lenoir) 31
H Asheville 20
A Mitchell 47
H Avery 22
A Northern Guilford 35
H Cardinal Gibbons (Raleigh) 10
A East Bladen 56
H Carrboro 48
A Erwin (Asheville) 21
H Crest (Boiling Springs) 52
A Carver (Winston-Salem) 47
H Cummings (Burlington) 14
A High Point Central 15
H Davie County 18
A Manning 22
H Dillon 28
A Tarboro 13
H East Duplin 10
A Pender 28
H Goldsboro 8
A Northwestern (Rock Hill) 41
H Goose Creek 34
A North Augusta 21
H Greenwood 34
A South Brunswick ForfeitedForfeit
H Havelock Double
A Lee County 22
H Hillside (Durham) 42
A Northern Nash 7
H Hunt (Wilson) 14
A Dorman (Roebuck) 30
H Irmo 19
A Hobbton (Newton Grove) 20
H Lakewood 19
A Byrnes (Duncan) 31
H Lexington 7
A Polk County 14
H Lincolnton 28
A Vance (Charlotte) 10
H Mallard Creek (Charlotte) 7
A Albemarle 31
H Monroe 13
A Robbinsville 7
H Murphy 42
A Bluffton 0
H Myrtle Beach 47
A Eastern Alamance 38
H Northeast Guilford 7
A Bunn 7
H Northeastern (Elizabeth City) 35
A Cedar Ridge 28
H Northwood (Pittsboro) 20
A Butler (Matthews) 48
H Richmond 21
A Berry (Charlotte) 35
H Salisbury 45
A Panther Creek (Cary) 35
H Seventy-First (Fayetteville) 32
A Wilkes Central 3
H Shelby 28
A Fairfield Central 8
H South Pointe (Rock Hill) 53
A Ayden-Grifton 6
H Southwest Onslow 38
A Garner 21
H Wake Forest 40
A Concord 28
H West Rowan 48
Saturday's Game 11/27
A Bamberg-Ehrhardt 13
H Abbeville 42
A Southeast Raleigh 17
H New Bern 44