Duplicate entries in 1993 #217
Description
This problem report was submitted by @gurujeet-ngc via email:
AGAGD shows a big spike of over 3000 games on a day in 1993. This is in error and a result of games from the Go congress being doubly counted. See analysis and recommended action below.
The doubling occurred on the reporting for the Go Congress where games were reported as occurring on 8/7/1993. The total games for tournament cong19930807a (1540) equals the sum of the games for cong19930807b (778) and cong19930807c (762).
Looking at just one player’s games, Pin_Player_1, it is clear that the 9 games played in ‘a’ reappear in ‘b’ or ‘c’. This is true for all other players as well.
Recommendation: delete tournament cong19930807 and its games from the database as they are erroneous duplicates. Additionally there is a tournament cong19930808 with a much smaller number of games that all appear to duplicate some of the games played in the previous tournaments. It is possible that these were self-pair games but should be investigated further to see if they are duplicates also.
