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-11-16') AND date_add('2012-11-16',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 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
 
Friday's Game 11/16
A Union County 41
H A.C. Flora (Columbia) 38
A Chesterfield 0
H Abbeville 63
A East Columbus 18
H Albemarle 19
A Freedom (Morganton) 19
H Burns (Lawndale) 18
A East Forsyth 15
H Butler (Matthews) 25
A Spartanburg 13
H Byrnes (Duncan) 54
A Reidsville 16
H Carrboro 20
A A.L. Brown (Kannapolis) 18
H Charlotte Catholic 49
A Fairfield Central 27
H Cheraw 10
A Daniel (Central) 35
H Chester 6
A East Rowan 20
H Concord 21
A Loris 7
H Dillon 21
A Boiling Springs 28
H Dutch Fork (Irmo) 63
A South Columbus 24
H East Bladen 14
A Thomasville 12
H East Lincoln 28
A Orange 14
H Eastern Alamance 13
A Stratford (Goose Creek) 12
H Gaffney 28
A Leesville Road (Raleigh) 35
H Garner 56
A Bluffton 25
H Goose Creek 35
A North Augusta 32
H Greenwood 34
A Socastee (Myrtle Beach) 14
H Hartsville 40
A Washington 7
H Havelock 57
A Cleveland (Clayton) 28
H Hunt (Wilson) 33
A White Knoll (Lexington) 3
H Irmo 0
A Red Springs 41
H James Kenan (Warsaw) 68
A Shelby 21
H Madison 28
A Olympic (Charlotte) 0
H Mallard Creek (Charlotte) 42
A Monroe 61
H Mount Airy 31
A Rosman 13
H Murphy 56
A New Hanover (Wilmington) 35
H New Bern 49
A Central (Pageland) 14
H Newberry 21
A Mt. Tabor (Winston-Salem) 14
H North Davidson 20
A Southern Guilford 14
H Northern Guilford 49
A Bunn 10
H Northside (Jacksonville) 21
A West Florence 28
H Northwestern (Rock Hill) 40
A Sun Valley (Monroe) 21
H Porter Ridge (Indian Trail) 28
A Jack Britt (Fayetteville) 56
H Richmond 52
A Princeton 27
H Rosewood 7
A E.E. Smith (Fayetteville) 28
H Scotland 35
A Bandys (Catawba) 14
H South Iredell 45
A Statesville 27
H South Point (Belmont) 21
A York 28
H South Pointe (Rock Hill) 31
A Northampton 6
H Southwest Onslow 50
A Hendersonville 24
H Swain County 56
A Salisbury 36
H T.W. Andrews (High Point) 35
A Northeastern (Elizabeth City) 24
H Tarboro 52