davorg/succession

People appearing multiple times in `person` table

Opened this issue · 0 comments

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)