[{"text":"The tournament was open to all players and took place at Get Some Game (http:\/\/www.getsomegame.com\/) in Charlotte, North Caroline on February 23, 2019. "},{"image":[{"src":"get914863get-some.jpg"},{"caption":""}]},{"text":"The number of players that participated in the event was:"},{"sql":"SELECT COUNT(`id`) as value1 FROM `dcdb_event_personnel_listing` WHERE (`role` LIKE 'Player' AND `eventNumber` LIKE '192')"},{"text":"Participants consisted of players from the following states:"},{"list":[{"listType":"bullet"},{"caption":"North Carolina"},{"caption":"South Carolina"}]},{"text":"The following is the player list, in alphabetical order by last name:"},{"sql":"SELECT name as value1 FROM dcdb_event_personnel_listing WHERE eventNumber =192 AND role = 'Player' ORDER By name ASC"},{"text":"The judging staff was:"},{"sql":"SELECT name as value1, role as value2 FROM dcdb_event_personnel_listing WHERE eventNumber = 192 AND role LIKE '%judge%' ORDER BY id ASC"},{"text":"The tournament consisted of three rounds of swiss pairings followed by a finals consisting of the top four players. A first place finish awards four match points, second place awards two, and third and fourth place award zero."},{"header":"ROUND 1"},{"text":"Table 1"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 1 AND tableNumber = 1 ORDER BY playerResult ASC"},{"text":"Table 2"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 1 AND tableNumber = 2 ORDER BY playerResult ASC"},{"text":"Table 3"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 1 AND tableNumber = 3 ORDER BY playerResult ASC"},{"text":"Standings after Round 1: Points - Player"},{"sql":"SELECT playerPoints as value1, playerName as value3 FROM dcdb_event_round_standings WHERE eventNumber = 192 AND roundNumber = 1 ORDER BY playerPoints DESC"},{"header":"ROUND 2"},{"text":"Table 1"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 2 AND tableNumber = 1 ORDER BY playerResult ASC"},{"text":"Table 2"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 2 AND tableNumber = 2 ORDER BY playerResult ASC"},{"text":"Table 3"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 2 AND tableNumber = 3 ORDER BY playerResult ASC"},{"text":"Standings after Round 2: Points - Player"},{"sql":"SELECT playerPoints as value1, playerName as value3 FROM dcdb_event_round_standings WHERE eventNumber = 192 AND roundNumber = 2 ORDER BY playerPoints DESC"},{"header":"ROUND 3"},{"text":"Table 1"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 3 AND tableNumber = 1 ORDER BY playerResult ASC"},{"text":"Table 2"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 3 AND tableNumber = 2 ORDER BY playerResult ASC"},{"text":"Table 3"},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 3 AND tableNumber = 3 ORDER BY playerResult ASC"},{"text":"Standings after Round 3: Points - Player"},{"sql":"SELECT playerPoints as value1, playerName as value3, orderForStandings as value2 FROM dcdb_event_round_standings WHERE eventNumber = 192 AND roundNumber = 3 ORDER BY playerPoints DESC, orderForStandings ASC"},{"header":"finals"},{"text":"The top four players continued on to play in the finals."},{"sql":"SELECT articleText as value1 FROM dcdb_event_round_results WHERE eventNumber = 192 AND roundNumber = 4 AND tableNumber = 1 ORDER BY playerResult ASC"},{"text":"Riding the Booster Gold hype train, Cesar Parra wins the tournament!"},{"image":[{"src":"20162573220190224.jpg"},{"caption":""}]},{"header":"VP TALLY"},{"text":"These players collectively gathered a VP total of:"},{"sql":"SELECT SUM(`vpPlayer[1]`+`vpPlayer[2]`+`vpPlayer[3]`+`vpPlayer[4]`) as value1 FROM `dcdb_games_played_log` WHERE `eventNumber` = 192"},{"header":"event notes"},{"text":"This was a community lead tournament, and we hope this inspires other groups to have their own events as well! Link to match slips and native image files:&nbsp;https:\/\/drive.google.com\/open?id=1j54VTlSqVhQgTVP8YjKChM_SIIIGp0r2 "}]