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 = 104 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 ('2015-11-27') AND date_add('2015-11-27',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name Chris Hughes' CarolinaPreps.com | Your Digital Destination for High School Football News & Information Array
Array

<< November 2015 >>
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/27
A Saluda
H Abbeville
A Latta 0
H Allendale-Fairfax 28
A Sumter
H Byrnes (Duncan)
A North Davidson
H Charlotte Catholic
A Southern Durham ForfeitedForfeit
H Cleveland (Clayton) Double
A T.W. Andrews (High Point) 13
H Clinton 14
A Thomas Jefferson (Mooresboro)
H Community School of Davidson
A South Iredell
H Concord
A Weddington 44
H Crest (Boiling Springs) 47
A Lake Marion
H Dillon
A South Caldwell
H Dudley (Greensboro)
A Dorman (Roebuck)
H Dutch Fork (Irmo)
A Bunn
H East Duplin
A West Forsyth 6
H East Forsyth 31
A East Burke
H East Lincoln
A Walkertown
H East Surry
A SouthWest Edgecombe
H Fairmont
A Boiling Springs
H Fort Dorchester (N. Charleston)
A Hillcrest (Simpsonville)
H Goose Creek
A New Hanover 52
H Hillside (Durham) 15
A Mallard Creek (Charlotte)
H Hough (Cornelius)
A D.H. Conley (Greenville)
H J.H. Rose (Greenville)
A Hibriten (Lenoir)
H Kings Mountain
A Mountain Heritage (Burnsville)
H Lincolnton
A Southside Christian (Simpsonville) 56
H McBee 26
A Fuquay-Varina 7
H Middle Creek (Apex) 42
A East Wilkes
H Mitchell
A Franklin
H Monroe
A Rocky Mount
H Morehead (Eden)
A Shelby
H Mount Pleasant
A Robbinsville 20
H Murphy 14
A Fairfield Central
H Newberry
A Southside (Chocowinity)
H North Edgecombe
A Kinston
H Northeastern (Elizabeth City)
A Westwood (Columbia) 21
H Northwestern (Rock Hill) 49
A South Creek
H Plymouth
A Page (Greensboro)
H Richmond County
A Marion
H Silver Bluff (Aiken)
A Eastern Alamance ForfeitedForfeit
H Southern Guilford Double
A T.L. Hanna (Anderson)
H Spartanburg
A James Kenan (Warsaw)
H Tarboro
A Northern Guilford
H Terry Sanford (Fayetteville)
A Chapin 21
H Union County 51
A East Carteret
H Wallace-Rose Hill
A South Point (Belmont) 28
H West Rowan 27
A Nation Ford (Fort Mill)
H Westside (Anderson)