People appearing multiple times in `person` table
Opened this issue · 0 comments
davorg commented
This is on the dev DB server.
> select * from person where slug in ('4fbbc3-alastair-windsor-2nd-duke-of-connaught-and-strathearn', '9a2b2a-princess-elisabeth-of-hesse-and-by-rhine') order by slug, id;
+-----+------------+------------+--------+--------------+-----+-----------+--------------------------------------------------------------+
| id | born | died | parent | family_order | sex | wikipedia | slug |
+-----+------------+------------+--------+--------------+-----+-----------+--------------------------------------------------------------+
| 143 | 1914-08-09 | 1943-04-26 | 142 | 1 | m | NULL | 4fbbc3-alastair-windsor-2nd-duke-of-connaught-and-strathearn |
| 367 | 1914-08-09 | 1943-04-26 | 366 | 1 | m | NULL | 4fbbc3-alastair-windsor-2nd-duke-of-connaught-and-strathearn |
| 268 | 1895-03-11 | 1903-11-16 | 267 | 3 | f | NULL | 9a2b2a-princess-elisabeth-of-hesse-and-by-rhine |
| 555 | 1895-03-11 | 1903-11-16 | 301 | 2 | f | NULL | 9a2b2a-princess-elisabeth-of-hesse-and-by-rhine |
+-----+------------+------------+--------+--------------+-----+-----------+--------------------------------------------------------------+
4 rows in set (0.001 sec)