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 = 3 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 ('2004-11-23') AND date_add('2004-11-23',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
You are here: Home / Scoreboard

<< November 2004 >>
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/26
A Thomasville 28
H Albemarle 21
A Asheville 35
H Burns (Lawndale) 28
A Aiken
H Byrnes (Duncan)
A Northside (Pinetown) 19
H Camden County 16
A Monroe 33
H Charlotte Catholic 47
A Belton-Honea Path
H Clinton
A Carver (Winston-Salem) 22
H Concord 25
A Parkland (Winston-Salem) 21
H Crest (Boiling Springs) 28
A East Rutherford 26
H Cummings (Burlington) 51
A Hoke County 0
H Davie County 41
A Manning
H Dillon
A Jacksonville 13
H Dudley (Greensboro) 28
A Wake Forest 34
H E.E. Smith (Fayetteville) 70
A Union (Clinton) 19
H Elkin 23
A Calhoun Falls
H Great Falls
A New Bern 19
H Green Hope (Morrisville) 20
A Nash Central 10
H Hertford County 41
A Millbrook (Raleigh) 6
H Hope Mills South View 33
A Beddingfield (Wilson) 20
H Hunt (Wilson) 21
A Northwest Guilford 7
H Independence (Charlotte) 62
A Beaufort 12
H Irmo 14
A Blackville-Hilda
H Lamar
A Starmount (Boonville) 14
H Maiden 20
A Broome (Spartanburg)
H Ninety Six
A East Carteret 21
H Northside (Jacksonville) 0
A Rock Hill
H Northwestern (Rock Hill)
A Farmville Central 26
H Pamlico County 29
A Southern Vance 7
H Reidsville 50
A Mount Tabor (Winston-Salem) 28
H Richmond County 35
A J.H. Rose (Greenville) 17
H Rocky Mount 15
A Bandys (Catawba) 27
H Salisbury 10
A Owen (Black Mountain) 7
H Shelby 27
A Walter Williams (Burlington) 16
H Southern Durham 31
A Lejeune 12
H Southside (Chocowinity) 28
A East Duplin 24
H Southwest Onslow 27
A Wando (Mt. Pleasant)
H Stratford (Goose Creek)
A Hobbton (Newton Grove) 7
H Swain County 31
A Ashbrook (Gastonia) 21
H T.C. Roberson (Asheville) 34
A Ayden-Grifton 6
H Wallace-Rose Hill 28
A T.W. Andrews (High Point) 12
H Western Alamance 26