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 = 110 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 ('2021-11-19') AND date_add('2021-11-19',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 2021 >>
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 Gray Collegiate (West Columbia) 31
H Abbeville 15
A Baptist Hill (Yonges Island)
H Bamberg-Ehrhardt
A Philip Simmons (Charleston)
H Barnwell
A Southside Christian (Simpsonville)
H Calhoun County
A Brookland-Cayce
H Camden
A Rabun Gap
H Charlotte Providence Day
A Silver Bluff (Aiken)
H Cheraw
A Powdersville
H Chester
A Cardinal Gibbons (Raleigh) 29
H Cleveland (Clayton) 21
A Daniel (Central)
H Clinton
A North Davidson 14
H Crest (Boiling Springs) 35
A Oceanside Collegiate (Mt. Pleasant)
H Dillon
A Kings Mountain 10
H Dudley (Greensboro) 36
A Sumter 21
H Dutch Fork (Irmo) 49
A Wallace-Rose Hill 21
H East Duplin 17
A Glenn (Kernersville)
H East Forsyth
A Monroe 9
H East Surry 10
A Westover (Fayetteville)
H Eastern Alamance
A Murphy
H Eastern Randolph
A West Florence
H Hartsville
A Panther Creek (Cary)
H Hoggard (Wilmington)
A Mallard Creek (Charlotte) 17
H Hough (Cornelius) 31
A Greenville
H Irmo
A Porter Ridge (Indian Trail) 10
H Julius Chambers (Charlotte) 28
A Jacksonville 25
H Lee County 22
A Knightdale
H Leesville Road (Raleigh)
A Fort Dorchester (N. Charleston)
H Lexington
A Salisbury
H Maiden
A Rolesville 54
H Millbrook (Raleigh) 48
A Thomasville 21
H Mitchell 38
A Starmount (Boonville)
H Mount Airy
A Beaufort
H Myrtle Beach
A Christ Church (Greenville)
H Newberry
A Pender County 50
H North Moore 12
A Rosewood
H Northampton County
A Washington
H Northeastern (Elizabeth City)
A Scotland
H Northern Nash
A Southside (Chocowinity)
H Northside (Pinetown)
A Gaffney
H Northwestern (Rock Hill)
A Nash Central 12
H Princeton 63
A Hendersonville
H Reidsville
A North Rowan 47
H Robbinsville 50
A J.H. Rose (Greenville) 20
H Seventy-First (Fayetteville) 14
A East Gaston 15
H Shelby 64
A Forestview (Gastonia) 7
H South Point (Belmont) 27
A Greenwood
H South Pointe (Rock Hill)
A Ridge View (Columbia)
H Spartanburg
A Hibriten (Lenoir)
H Statesville
A Perquimans 0
H Tarboro 42
A Cuthbertson (Waxhaw)
H Weddington
A Saint Pauls
H Whiteville