Game Schedule

**More games to come at the convention!!**

test SELECT E.*, P.playerID , ( SELECT count( * ) FROM pcon_eventreg AS R WHERE R.eventID = E.eventID ) AS TotalPlayers FROM pcon_events AS E LEFT OUTER JOIN pcon_eventreg AS P ON P.eventID= E.eventID AND P.playerID=0 Where approved=1 AND archived=0 AND YearID=2019 AND E.eventID=2312 order by StartTime ASC