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 = 105 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 ('2016-11-10') AND date_add('2016-11-10',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 2016 >>
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
   
Thursday's Game 11/10
A Nash Central
H Fike (Wilson)
A Eastern Wayne
H J.H. Rose (Greenville)
A Lakewood (Salemburg)
H James Kenan (Warsaw)
A Rosewood
H North Duplin
A Southern Nash
H Northern Nash
A Spring Creek 7
H Princeton 54
A Rocky Mount Prep 0
H Tarboro 54
A Southern Lee
H Terry Sanford (Fayetteville)
A Midway (Dunn)
H Wallace-Rose Hill
Friday's Game 11/11
A Marion
H Andrews
A North Lenoir 6
H Ayden-Grifton 34
A North Pitt
H Beddingfield (Wilson)
A Beaufort 14
H Berkeley (Moncks Corner) 48
A Edisto (Cordova)
H Brookland-Cayce
A South Central (Winterville)
H C.B. Aycock (Pikeville)
A Creswell
H Camden County
A Lee Central
H Cheraw
A Union (Clinton)
H Clinton
A South Florence
H Conway
A Southern Wayne
H D.H. Conley (Greenville)
A Southeast Guilford 14
H Davie County 42
A Aynor
H Dillon
A Westover (Fayetteville)
H Douglas Byrd (Fayetteville)
A Hope Mills South View 43
H E.E. Smith (Fayetteville) 41
A Trask (Rocky Point)
H East Bladen
A South Robeson
H East Columbus
A Loris
H Georgetown
A South Lenoir 20
H Goldsboro 7
A Southeast Halifax 18
H Granville Central 7
A Colleton County
H Hilton Head
A Currituck County
H Holmes (Edenton)
A Rocky Mount
H Hunt (Wilson)
A Latta
H Johnsonville
A Greene Central
H Kinston
A Hannah Pamplico
H Lake View
A Gray's Creek (Hope Mills)
H Lee County
A Warren County
H Louisburg
A Hoke County
H Lumberton
A Myrtle Beach
H Marlboro County
A Williamston Riverside
H North Edgecombe
A Farmville Central
H North Johnston
A Wilson (Florence)
H North Myrtle Beach
A Weldon 48
H Northwest Halifax 26
A Dreher (Columbia)
H Orangeburg-Wilkinson
A Cape Fear (Fayetteville) 25
H Pine Forest (Fayetteville) 7
A Purnell Swett (Pembroke)
H Richmond County
A Overhills
H Seventy-First (Fayetteville)
A West Florence
H Socastee (Myrtle Beach)
A Fairmont
H South Columbus
A Carolina Forest (Myrtle Beach)
H Sumter
A Manning
H Timberland
A SouthWest Edgecombe
H Washington
A Pender County
H West Bladen
A Red Springs
H West Columbus
A West Carteret
H West Craven
A Academic Magnet (N. Charleston)
H Whale Branch (Beaufort)
A Saint Pauls
H Whiteville
A Garrett (N.Charleston)
H Woodland (Dorchester)
A Fairfield Central
H Woodruff