← Back to Session: MTGO Pauper Challenge Data Limitations

Tournament matches with player records and archetypes

Query Result

match_id
result
mirror
pair_id
player1
archetype1
p1_wins
p1_losses
p1_rank
player2
archetype2
p2_wins
p2_losses
p2_rank
e0048b0c-9dbd-4a05-ae08-42f58a1bd345LOSS004f99c6a-8d0e-44dd-94a4-466a5fd48854irrrwinspy combo110billsivewhite aggro210
96e51267-4262-4463-b83e-c967f891ed97WIN004f99c6a-8d0e-44dd-94a4-466a5fd48854billsivewhite aggro210irrrwinspy combo110
42c71bfc-287a-4310-93f1-4b26d3327ec7LOSS022d176d1-0f7c-473f-87c4-2842647b2c7eAnpanMoeMoered madness010NickNormangolgari garden110
0c0ecc25-cd94-4cb4-aef9-ff02b4ac3bdcWIN022d176d1-0f7c-473f-87c4-2842647b2c7eNickNormangolgari garden110AnpanMoeMoered madness010
b110ba63-d20d-41dd-9c58-81786836afc1LOSS0496703a9-a54f-4c1f-b99a-7a85344e45e3billsivewhite aggro210MisterTwinred madness300
6eff25ed-2508-42ae-9322-821b9d4ac323WIN0496703a9-a54f-4c1f-b99a-7a85344e45e3MisterTwinred madness300billsivewhite aggro210
cc42ca6e-69f2-4086-8455-615398734ca5LOSS086ad1ed1-f269-4e6d-b81e-5402cf0a85b1Boinaura bogles010MisterTwinred madness300
81672ba2-0d09-4905-9565-fe33fd18022aWIN086ad1ed1-f269-4e6d-b81e-5402cf0a85b1MisterTwinred madness300Boinaura bogles010
4810d667-fb07-488f-b937-01229627a82eLOSS0a59e6b07-efba-4b7b-98a4-3f63fbfc81c3FRFSEIXASgruul ponza010irrrwinspy combo110
b8c94fe8-bd9b-4a23-8b36-ba3e9b3d500bWIN0a59e6b07-efba-4b7b-98a4-3f63fbfc81c3irrrwinspy combo110FRFSEIXASgruul ponza010
f409e745-de47-489b-b87e-c7e9651a16ecWIN0c9064346-5413-485d-8e98-a803d2d5eb88MisterTwinred madness300NickNormangolgari garden110
16656cde-043c-4fea-bb4d-f70a1fef76a1LOSS0c9064346-5413-485d-8e98-a803d2d5eb88NickNormangolgari garden110MisterTwinred madness300
abb489b6-3d8b-4d94-8ca4-674528b7a462WIN0f70b5ef9-185b-4f91-896c-a118e9c41f35billsivewhite aggro210Denisevichred madness010
308355ce-b36b-4f4c-b778-efff6e53ad6aLOSS0f70b5ef9-185b-4f91-896c-a118e9c41f35Denisevichred madness010billsivewhite aggro210