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 = 109 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 ('2020-10-02') AND date_add('2020-10-02',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

<< October 2020 >>
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
Friday's Game 10/02
A Richland Northeast
H A.C. Flora (Columbia)
A Woodland (Dorchester)
H Abbeville
A Bethune-Bowman
H Allendale-Fairfax
A North Central (Kershaw)
H Andrew Jackson (Kershaw)
A Mullins
H Andrews
A Hickory Grove Baptist (Charlotte)
H Asheville School
A Eau Claire (Columbia)
H Batesburg-Leesville
A Wando (Mt. Pleasant)
H Berkeley (Moncks Corner)
A Landrum
H Blacksburg
A Wagener-Salley
H Blackville-Hilda
A May River (Bluffton)
H Bluffton
A Northwestern (Rock Hill)
H Blythewood
A Chesterfield
H Buford (Lancaster)
A Riverside (Greer)
H Byrnes (Duncan)
A Great Falls
H C.A. Johnson (Columbia)
A Hunter-Kinard-Tyler
H Calhoun County
A McCormick
H Calhoun Falls
A Manning 0
H Camden 57
A Conway
H Carolina Forest (Myrtle Beach)
A Scott's Branch (Summerton)
H Carvers Bay (Hemingway)
A Emerald (Greenwood)
H Chapman (Inman)
A Charlotte Providence Day 48
H Charlotte Latin 0
A St. Joseph's (Greenville)
H Chesnee
A Keenan (Columbia)
H Chester
A West-Oak (Westminster)
H Christ Church (Greenville)
A Broome (Spartanburg)
H Clinton
A Gray Collegiate (West Columbia)
H Columbia
A Pendleton
H Daniel (Central)
A Aynor
H Dillon
A Gaffney 30
H Dorman (Roebuck) 29
A Chapin 12
H Dutch Fork (Irmo) 51
A Lower Richland 18
H Fairfield Central 28
A John Paul II (Greenville) 52
H Faith Christian (Rocky Mount) 42
A Ravenscroft (Raleigh)
H Fayetteville Trinity Christian
A Goose Creek
H Fort Dorchester (N. Charleston)
A Clover
H Fort Mill
A Fox Creek (N. Augusta)
H Gilbert
A Arendell-Parrott (Kinston)
H GRACE Christian (Raleigh)
A Hannah Pamplico
H Green Sea-Floyds
A Eastside (Taylors)
H Greenwood
A West Florence
H Hartsville
A Mid-Carolina (Prosperity)
H Indian Land
A Dreher (Columbia)
H Irmo
A Beaufort 48
H James Island (Charleston) 6
A Timmonsville
H Johnsonville
A Lake City
H Lakewood (Sumter)
A Greenville
H Laurens
A Kingstree
H Marion
A Crestwood (Sumter)
H Marlboro County
A Lamar
H McBee
A Georgetown
H Myrtle Beach
A Boiling Springs
H Nation Ford (Fort Mill)
A Crescent (Iva)
H Ninety Six
A Airport (West Columbia)
H North Augusta
A South Florence
H North Myrtle Beach
A North Charleston
H Oceanside Collegiate (Mt. Pleasant)
A Swansea
H Orangeburg-Wilkinson
A Lake Marion 8
H Philip Simmons (Charleston) 43
A Berea (Greenville)
H Powdersville
A Metrolina Christian (Indian Trail)
H Rabun Gap
A Wren (Piedmont)
H Seneca
A St. James (Murrells Inlet)
H Socastee (Myrtle Beach)
A Lancaster
H South Pointe (Rock Hill)
A Carolina (Greenville)
H Southside (Greenville)
A Dixie (Due West)
H Southside Christian (Simpsonville)
A Wade Hampton (Greenville)
H Spartanburg
A Ridge View (Columbia)
H Spring Valley (Columbia)
A Cane Bay (Summerville)
H Stratford (Goose Creek)
A Brookland-Cayce
H Strom Thurmond (Johnston)
A Stall (Charleston)
H Summerville
A Rock Hill
H Sumter
A Mauldin
H T.L. Hanna (Anderson)
A Burke (Charleston)
H Timberland
A Woodruff
H Union County
A Ashley Ridge (Summerville)
H West Ashley
A Travelers Rest
H Westside (Anderson)
A Lugoff-Elgin
H Westwood (Columbia)
A South Aiken
H White Knoll (Lexington)
A Darlington
H Wilson (Florence)
A Catawba Ridge (Fort Mill)
H York