Deck 67191 has a duplicate match
Closed this issue · 2 comments
bakert commented
Describe the bug
Match that only happened once is listed twice.
To Reproduce
Steps to reproduce the behavior:
- Go to https://gatherling.one/deck.php?mode=view&id=67191
- View matches
Expected behavior
Game versus IAmVast should not be displayed twice.
Screenshots
Environment (please complete the following information):
n/a
Additional context
n/a
silasary commented
bakert commented
Cleaned up prod db with
MariaDB [decksite]> SELECT * FROM `match` WHERE id IN (SELECT match_id FROM deck_match WHERE deck_id = 48039);
+-------+------------+-------+-------------+---------+
| id | date | round | elimination | mtgo_id |
+-------+------------+-------+-------------+---------+
| 71765 | 1556991000 | 4 | 0 | NULL |
| 71767 | 1556991000 | 1 | 0 | NULL |
| 71768 | 1556991000 | 2 | 0 | NULL |
| 71769 | 1556991000 | 3 | 0 | NULL |
| 71770 | 1556991000 | 3 | 0 | NULL |
| 71771 | 1556991000 | 5 | 8 | NULL |
+-------+------------+-------+-------------+---------+
6 rows in set (0.00 sec)
MariaDB [decksite]> DELETE FROM `match` WHERE id = 71770;
Query OK, 1 row affected (0.02 sec)