Thomas David Baker bakert
bakert
/ gist:b1eb9cecd606cbf541732310d48d11d9
Created
November 28, 2024 19:20
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MariaDB [gatherli_gatherling]> SELECT * FROM deckcontents WHERE deck IN (SELECT id FROM decks WHERE id NOT IN (SELECT deck FROM entries WHERE deck IS NOT NULL)); | |
| +--------+--------+-----+-------------+ | |
| | card | deck | qty | issideboard | | |
| +--------+--------+-----+-------------+ | |
| | 1359 | 7146 | 4 | 0 | | |
| | 2172 | 7146 | 1 | 0 | | |
| | 2176 | 7146 | 2 | 1 | | |
| | 2178 | 7146 | 1 | 0 | | |
| | 2183 | 7146 | 1 | 1 | | |
| | 2186 | 7146 | 1 | 0 | |
bakert
/ survey2.txt
Created
January 29, 2018 04:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [deepthought ~] mysql survey | |
| Reading table information for completion of table and column names | |
| You can turn off this feature to get a quicker startup with -A | |
| Welcome to the MySQL monitor. Commands end with ; or \g. | |
| Your MySQL connection id is 4655 | |
| Server version: 5.7.17 Source distribution | |
| Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. |
bakert
/ survey.txt
Created
January 29, 2018 01:57
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> SELECT q1, COUNT(*) AS n, ROUND(COUNT(*) / (SELECT COUNT(*) FROM response WHERE participant = 'Yes' AND q1 <> '') * 100) AS percent FROM response WHERE participant = 'Yes' AND q1 <> '' GROUP BY q1 ORDER BY percent DESC; | |
| +-------+----+---------+ | |
| | q1 | n | percent | | |
| +-------+----+---------+ | |
| | Red | 41 | 98 | | |
| | Green | 1 | 2 | | |
| +-------+----+---------+ | |
| 2 rows in set (0.00 sec) | |
| mysql> SELECT q2, COUNT(*) AS n, ROUND(COUNT(*) / (SELECT COUNT(*) FROM response WHERE participant = 'Yes' AND q2 <> '') * 100) AS percent FROM response WHERE participant = 'Yes' AND q2 <> '' GROUP BY q2 ORDER BY percent DESC; |
bakert
/ mm2-pd.txt
Created
January 20, 2018 18:19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Aethersnipe | |
| Agony Warp | |
| Air Servant | |
| Algae Gharial | |
| Alloy Myr | |
| All Suns' Dawn | |
| Ant Queen | |
| Apocalypse Hydra | |
| Aquastrand Spider | |
| Argent Sphinx |
bakert
/ gist:dc78dc1691a941e1c384db1dd44a3c73
Last active
December 19, 2017 17:25
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| +--------------------------+------+-------+-------+------+-------+ | |
| | name | wins | top8s | decks | win% | top8% | | |
| +--------------------------+------+-------+-------+------+-------+ | |
| | Mono White Heroic | 6 | 32 | 55 | 0.11 | 0.58 | | |
| | Demonic Rising | 4 | 15 | 31 | 0.13 | 0.48 | | |
| | Hyperwave | 4 | 14 | 22 | 0.18 | 0.64 | | |
| | Red Deck Wins | 3 | 44 | 93 | 0.03 | 0.47 | | |
| | Cruel Control | 3 | 20 | 37 | 0.08 | 0.54 | | |
| | Hypergenesis | 3 | 10 | 22 | 0.14 | 0.45 | | |
| | Blink | 3 | 8 | 11 | 0.27 | 0.73 | |
bakert
/ gist:cac32fffff94993f8c7df93b606d3a68
Created
July 14, 2017 18:52
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Cards that have never been legal in PD before Season 5 | |
| Adamaro, First to Desire | |
| Airdrop Condor | |
| Akoum Battlesinger | |
| Akuta, Born of Ash | |
| Altar of the Brood | |
| Ancient Spider | |
| Angel of Retribution | |
| Anointer Priest |