Comment 2 for bug 1130389

Ben Shum (bshum) wrote :

SQL used to find some of these bad entries:

SELECT astat.name, COUNT(*)
FROM actor.stat_cat astat
JOIN actor.stat_cat_entry_usr_map asceum ON asceum.stat_cat = astat.id
WHERE astat.allow_freetext = FALSE AND astat.required = FALSE
AND asceum.stat_cat_entry = ''
GROUP BY 1
ORDER BY 1;