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 = 42 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 ('2012-10-30') AND date_add('2012-10-30',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

<< October 2012 >>
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
31
   
Thursday's Game 11/01
A Piedmont (Monroe) 14
H T.W. Andrews (High Point) 28
Friday's Game 11/02
A Pickens 31
H A.C. Flora (Columbia) 55
A Alexander Central 35
H A.C. Reynolds (Asheville) 63
A North Forsyth 34
H A.L. Brown (Kannapolis) 41
A Barnwell 29
H Academic Magnet (N. Charleston) 7
A South Aiken 28
H Aiken 21
A Whale Branch (Seabrook) 32
H Allendale Fairfax 22
A North Central (Kershaw) 14
H Andrew Jackson (Kershaw) 35
A Mullins 18
H Andrews 7
A Gates County 7
H Ayden-Grifton 57
A Kingstree 36
H Aynor 44
A Woodland (Dorchester) 18
H Bamberg-Ehrhardt 21
A East Burke 7
H Bandys (Catawba) 34
A Estill 20
H Baptist Hill (Hollywood) 13
A Colleton County 28
H Beaufort 29
A Ridge View (Columbia) 17
H Blythewood 36
A Mauldin 34
H Boiling Springs 54
A Daniel (Central) 45
H Broome (Spartanburg) 21
A North Brunswick
H Bunn Forfeited
A Forestview (Gastonia) 6
H Burns (Lawndale) 28
A West Forsyth 0
H Butler (Matthews) 49
A Wade Hampton (Greenville) 21
H Byrnes (Duncan) 48
A West Ashley 11
H Cane Bay (Summerville) 19
A Gray's Creek (Hope Mills) 52
H Cardinal Gibbons (Raleigh) 57
A Cummings (Burlington) 31
H Carrboro 68
A Marvin Ridge (Waxhaw) 12
H Charlotte Catholic 15
A Charlotte Latin 20
H Charlotte Christian 48
A Providence Day (Charlotte) 24
H Charlotte Country Day 14
A Wake Christian (Raleigh) 6
H Christ School (Arden) 75
A Knightdale 14
H Clayton 39
A McMichael (Mayodan) 38
H Concord 51
A Carolina Forest (Myrtle Beach) 27
H Conway 24
A Ashbrook (Gastonia) 14
H Crest (Boiling Springs) 58
A Ragsdale (Jamestown) 8
H Davie County 38
A Riverside (Greer) 0
H Dorman (Roebuck) 45
A Chapel Hill 23
H Douglas Byrd (Fayetteville) 20
A Owen (Black Mountain) 35
H Draughn (Valdese) 6
A Reagan (Pfafftown) 22
H Dudley (Greensboro) 44
A North Augusta 21
H Dutch Fork (Irmo) 28
A Northern Durham 14
H E.E. Smith (Fayetteville) 42
A Whiteville 7
H East Bladen 28
A North Stokes 6
H East Columbus 52
A SouthWest Edgecombe 30
H East Duplin 26
A Providence (Charlotte) 7
H East Forsyth 42
A Hunter Huss (Gastonia) 21
H East Henderson 44
A Wheatmore (Trinity) 0
H East Lincoln 49
A Carson (China Grove) 14
H East Rowan 49
A South Brunswick 14
H Eastern Alamance 28
A Providence Grove 7
H Eastern Randolph 47
A Alleghany 6
H Elkin 44
A Chester 49
H Emerald (Greenwood) 34
A Asheville 34
H Erwin (Asheville) 41
A Central Davidson 47
H Forest Hills (Marshville) 46
A Ashley Ridge (Summerville) 41
H Fort Dorchester (N. Charleston) 20
A Randleman 21
H Franklinton 16
A Franklin 14
H Freedom (Morganton) 42
A Green Hope (Cary) 33
H Fuquay-Varina 43
A Athens Drive (Raleigh) 21
H Garner 59
A Dixon 0
H Goldsboro 40
A Stratford (Goose Creek) 23
H Goose Creek 31
A Chapin 21
H Greenville 35
A Laurens 7
H Greenwood 17
A Seneca 14
H Greer 28
A High Point Christian 18
H Harrells Christian 70
A Southside (Greenville) 0
H Hartsville 54
A Currituck County 0
H Havelock 49
A North Wilkes 13
H Hendersonville 61
A West Carteret 28
H Hertford County 52
A Hibriten (Lenoir) 17
H Hickory 35
A Ledford 14
H Hickory Ridge (Harrisburg) 69
A Mt. Tabor (Winston-Salem) 15
H High Point Central 12
A Woodmont 15
H Hillcrest (Simpsonville) 41
A Southeast Guilford 17
H Hillside (Durham) 14
A Pinecrest (Southern Pines) 14
H Hoke County 24
A Louisburg 6
H Holmes (Edenton) 56
A West Mecklenburg 45
H Hough (Cornelius) 10
A Southern Nash 7
H Hunt (Wilson) 28
A Northwest Guilford 42
H Independence (Charlotte) 45
A Lugoff-Elgin 6
H Irmo 40
A Easley 70
H J.L. Mann (Greenville) 20
A Lumberton 14
H Jack Britt (Fayetteville) 28
A First Flight (Kill Devil Hills) 21
H Kinston 48
A Avery 0
H Lake Norman Charter 48
A Southside Christian (Simpsonville) 7
H Lamar 39
A Terry Sanford (Fayetteville) 35
H Lee County 57
A Heritage (Wake Forest) 13
H Leesville Road (Raleigh) 43
A Rosewood 34
H Lejeune 20
A White Knoll (Lexington) 28
H Lexington 0
A Mountain Heritage 7
H Madison 62
A Thomasville 27
H Maiden 24
A Lake Norman 0
H Mallard Creek (Charlotte) 66
A Northside (Beaufort) 12
H Manteo 49
A Georgetown 3
H Marlboro County 37
A Laney (Wilmington) 21
H Middle Creek (Apex) 31
A Bishop McGuinness (Kernersville) 0
H Monroe 69
A Central Academy (Monroe) 14
H Mount Airy 47
A Cherokee 20
H Murphy 69
A Manning 14
H Myrtle Beach 43
A Fort Mill 28
H Nation Ford (Fort Mill) 21
A Pine Forest (Fayetteville) 7
H New Bern 48
A Southeast Raleigh 14
H New Hanover (Wilmington) 28
A Indian Land 13
H Newberry 42
A Ashe County 0
H Newton-Conover 49
A Western Guilford 17
H North Davidson 45
A Princeton 28
H North Duplin 21
A Weldon 12
H North Edgecombe 30
A Topsail 27
H North Pitt 48
A Hickory Grove Baptist (Charlotte) 13
H North Raleigh Christian 31
A Riverside Martin 32
H Northampton 42
A Bertie 22
H Northeastern (Elizabeth City) 35
A Asheboro 0
H Northern Guilford 69
A Croatan (Newport) 10
H Northside (Jacksonville) 47
A Rock Hill 21
H Northwestern (Rock Hill) 48
A McDowell 0
H Olympic (Charlotte) 42
A Eastern Wayne 6
H Orange 38
A Swansea 17
H Orangeburg-Wilkinson 0
A Western Alamance 20
H Overhills 38
A Rocky River (Mint Hill) 14
H Page (Greensboro) 40
A Mid-Carolina (Prosperity) 6
H Pendleton 9
A Smoky Mountain 28
H Pisgah (Canton) 49
A East Rutherford 13
H Polk County 23
A Watauga 0
H Porter Ridge (Indian Trail) 69
A Midway 9
H Red Springs 62
A Corinth Holders 24
H Reidsville 41
A Cary 7
H Richmond 40
A Hayesville 8
H Robbinsville 12
A Central Cabarrus 33
H Rockingham County 48
A Jacksonville 27
H Rocky Mount 14
A Cuthbertson (Waxhaw) 31
H Salisbury 42
A East Chapel Hill 5
H Scotland 40
A Chase (Forest City) 7
H Shelby 10
A Crestwood (Sumter) 12
H Socastee (Myrtle Beach) 30
A Hopewell (Huntersville) 14
H South Caldwell 17
A Clinton 20
H South Columbus 31
A Jordan-Matthews (Siler City) 0
H South Granville 11
A West Lincoln 15
H South Iredell 69
A Berry (Charlotte) 25
H South Point (Belmont) 55
A Lancaster 13
H South Pointe (Rock Hill) 35
A Chatham Central 20
H South Stanly 29
A East Surry 24
H South Stokes 22
A Jones Senior 7
H Southeast Halifax 6
A Hoggard (Wilmington) 28
H Southern Durham 26
A Westover (Fayetteville) 12
H Southern Guilford 37
A Fayetteville Christian 6
H Southlake Christian 48
A Camden County 12
H Southwest Onslow 35
A Gaffney 35
H Spartanburg 18
A Richland Northeast (Columbia) 14
H Spring Valley (Columbia) 57
A Northwood (Pittsboro) 14
H St. Pauls 22
A Carver (Winston-Salem) 20
H Starmount (Boonville) 24
A Enka 12
H Statesville 65
A Bluffton 22
H Summerville 31
A East Wilkes 22
H Swain County 68
A Sun Valley (Monroe) 37
H T.C. Roberson (Asheville) 31
A Beddingfield (Wilson) 13
H Tarboro 53
A Rosman 26
H Thomas Jefferson 14
A D.H. Conley (Greenville) 33
H Triton (Erwin) 0
A Lakewood 7
H Union 42
A West Columbus 6
H Union Academy (Monroe) 56
A Wren (Piedmont) 28
H Union County 56
A Myers Park (Charlotte) 17
H Vance (Charlotte) 40
A Trinity Christian (Fayetteville) 12
H Victory Christian 24
A Wake Forest 38
H Wakefield (Raleigh) 40
A Pender 40
H Wallace-Rose Hill 20
A C.B. Aycock (Pikeville) 36
H Walter Williams (Burlington) 22
A West Craven 6
H Washington 48
A Cox Mill (Concord) 6
H Weddington 42
A Cleveland (Clayton) 40
H West Brunswick 33
A Northeast Guilford 17
H West Rowan 21
A North Surry 9
H West Stokes 16
A Cherryville 14
H West Wilkes 19
A Lincolnton 41
H Wilkes Central 21
A Clover 0
H York 54