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-19') AND date_add('2010-11-19',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/19
A Sun Valley (Monroe) 21
H A.C. Reynolds (Asheville) 24
A Statesville 14
H A.L. Brown (Kannapolis) 28
A Swain County 12
H Avery 30
A Hemingway 14
H Bamberg-Ehrhardt 17
A Kinston 7
H Bunn 27
A Asheville 38
H Burns (Lawndale) 35
A Page (Greensboro) 14
H Butler (Matthews) 35
A Douglas Byrd (Fayetteville) 27
H Cardinal Gibbons (Raleigh) 28
A Concord 30
H Carson (China Grove) 21
A Thomasville 28
H Carver (Winston-Salem) 35
A Randleman 20
H Cedar Ridge 23
A Weddington 14
H Charlotte Catholic 58
A Lexington 31
H Cummings (Burlington) 45
A Timberland (St. Stephen) 14
H Dillon 31
A Fort Dorchester (N. Charleston) 28
H Dorman (Roebuck) 49
A Lee County 21
H Dudley (Greensboro) 12
A Byrnes (Duncan) 31
H Dutch Fork (Irmo) 14
A First Flight (Kill Devil Hills) 30
H East Duplin 49
A Mount Pleasant 13
H Eastern Alamance 31
A Carrboro 49
H Fairmont 28
A Crest (Boiling Springs) 34
H Freedom (Morganton) 7
A Middle Creek (Apex) 20
H Garner 35
A Ayden-Grifton 28
H Gates County 13
A James Kenan (Warsaw) 13
H Goldsboro 42
A Easley 0
H Goose Creek 49
A Northern Guilford 34
H Gray's Creek (Hope Mills) 27
A South Florence 7
H Greenwood 35
A Bluffton 40
H Hartsville 35
A East Henderson 25
H Hibriten (Lenoir) 35
A Purnell Swett (Pembroke) 13
H Hillside (Durham) 53
A Rosewood 0
H Hobbton (Newton Grove) 35
A West Carteret 17
H Hunt (Wilson) 37
A Gaffney 7
H Irmo 12
A North Stokes 8
H Lakewood 35
A Summerville 14
H Lexington 45
A Mountain Heritage 20
H Lincolnton 49
A Ardrey Kell (Charlotte) 23
H Mallard Creek (Charlotte) 49
A Southside (Beaufort) 27
H Manteo 40
A Albemarle 38
H Mount Airy 14
A Davie County 30
H Mt. Tabor (Winston-Salem) 29
A Andrews 21
H Murphy 62
A Berkeley 28
H Myrtle Beach 42
A Clayton 22
H New Bern 38
A T.L. Hanna (Anderson) 21
H North Augusta 28
A South Johnston 35
H Northeast Guilford 42
A Beddingfield (Wilson) 26
H Northeastern (Elizabeth City) 28
A Ashley Ridge (Summerville) 35
H Northwestern (Rock Hill) 49
A T.W. Andrews (High Point) 7
H Northwood (Pittsboro) 14
A Fuquay-Varina 28
H Panther Creek (Cary) 35
A East Columbus 8
H Pender 42
A Berry (Charlotte) 14
H Piedmont (Monroe) 7
A East Rutherford 0
H Polk County 12
A West Charlotte 7
H Porter Ridge (Indian Trail) 47
A High Point Central 21
H Ragsdale (Jamestown) 14
A Northwest Guilford 21
H Richmond 45
A Elkin 7
H Robbinsville 42
A Forest Hills (Marshville) 17
H Salisbury 41
A Jack Britt (Fayetteville) 36
H Seventy-First (Fayetteville) 54
A Owen (Black Mountain) 21
H Shelby 37
A Southern Wayne 14
H South Brunswick 42
A Northern Nash 37
H South Central (Winterville) 10
A East Bladen 26
H South Columbus 12
A Erwin (Asheville) 57
H South Point (Belmont) 56
A Greenville 7
H South Pointe (Rock Hill) 50
A Southern Durham 7
H Southeast Raleigh 38
A Riverside Martin 10
H Southwest Onslow 49
A Roanoke Rapids 14
H Tarboro 35
A Hopewell (Huntersville) 7
H Vance (Charlotte) 17
A Wakefield (Raleigh) 0
H Wake Forest 21
A North Duplin 7
H Wallace-Rose Hill 42
A Northwest Cabarrus 7
H West Rowan 41
A Mitchell 35
H West Wilkes 29
A Pisgah (Canton) 16
H Wilkes Central 24
Saturday's Game 11/20
A Lamar 12
H Abbeville 20