search

holmes-app / holmes-api

API for holmes website validation.
MIT License
17 stars 7 forks source link

Pages with more than one active review #93

Closed scorphus closed 10 years ago

scorphus commented 10 years ago

Querying the “PROD” database, I found out there are some pages with more than one active review:

SELECT page_id, count(*) active_reviews
FROM reviews
WHERE is_active = 1
GROUP BY page_id
HAVING active_reviews > 1
ORDER BY active_reviews DESC;
page_id | active_reviews
--------|---------------
264121  |              3
1186    |              2
6556    |              2
673     |              2
8679    |              2
705     |              2
3265    |              2
... goes on with a total of 44 rows out of 268,279 pages

We should check if this still happens with latest changes in worker.

scorphus commented 10 years ago

Still an issue, see #111