API keeps more than one active review per page

[scorphus]

mysql> select domain_id, count(page_id) as q from reviews where is_active is true group by domain_id order by q desc;
+-----------+---------+
| domain_id | q       |
+-----------+---------+
|         3 | 4153211 |
|         2 | 3874689 |
|         6 |  640686 |
|         5 |  447583 |
|        10 |    2990 |
|         4 |    1593 |
|         9 |    1475 |
|         1 |      13 |
|         7 |       2 |
+-----------+---------+
9 rows in set (48.40 sec)

mysql> select domain_id, count(distinct(page_id)) as q from reviews where is_active is true group by domain_id order by q desc;
+-----------+---------+
| domain_id | q       |
+-----------+---------+
|         3 | 4153143 |
|         2 | 3874501 |
|         6 |  640684 |
|         5 |  447583 |
|        10 |    2988 |
|         4 |    1585 |
|         9 |    1473 |
|         1 |      13 |
|         7 |       2 |
+-----------+---------+
9 rows in set (30.48 sec)

[scorphus]

The aforereferenced commit is just a stopgap, we still need to track and fix this issue (a.k.a. seek and destroy).