Skip to content

Instantly share code, notes, and snippets.

@nelhage

nelhage/gist:a5fa7c592d8beef4c68ac1f907856e13

Created May 3, 2016 03:05
Show Gist options
  • Save nelhage/a5fa7c592d8beef4c68ac1f907856e13 to your computer and use it in GitHub Desktop.
Save nelhage/a5fa7c592d8beef4c68ac1f907856e13 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
sqlite> select id, winner, player1, player2, result, moves from games where (player1='TakticianBot' and winner='black') OR (player2='TakticianBot' and winner='white');
6450|white|BenWo|TakticianBot|R-0|33
6454|white|BenWo|TakticianBot|R-0|27
6459|white|BenWo|TakticianBot|R-0|27
6469|white|BenWo|TakticianBot|R-0|27
6514|white|pythoner6|TakticianBot|F-0|61
6522|white|pythoner6|TakticianBot|R-0|81
6552|white|asgardiator|TakticianBot|1-0|73
6584|white|Archerion|TakticianBot|R-0|39
6979|white|Simmon|TakticianBot|F-0|54
7084|black|TakticianBot|CaptainSasquatch|0-F|57
7182|white|fwwwwibib|TakticianBot|1-0|75
7209|white|kakaburra|TakticianBot|R-0|35
7249|black|TakticianBot|kakaburra|0-R|30
7290|white|kakaburra|TakticianBot|R-0|27
7291|white|kakaburra|TakticianBot|R-0|35
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment