SELECT COUNT(*) FROM BugTask JOIN Bug ON BugTask.bug = Bug.id WHERE Bug.id = BugTask.bug AND BugTask.product = 22 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.id IN ( SELECT BugTask.id FROM BugTask, BugAffectsPerson WHERE BugTask.bug = BugAffectsPerson.bug
AND BugAffectsPerson.person = 16
AND BugAffectsPerson.affected = TRUE
)
the sql looks like this:
SELECT COUNT(*) FROM BugTask JOIN Bug ON BugTask.bug = Bug.id WHERE Bug.id = BugTask.bug AND BugTask.product = 22 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND
BugTask. id IN (
SELECT BugTask.id FROM BugTask, BugAffectsPerson
WHERE BugTask.bug = BugAffectsPerso n.bug n.person = 16 n.affected = TRUE
AND BugAffectsPerso
AND BugAffectsPerso
)
and some of the top user ids are in https:/ /bugs.launchpad .net/launchpad/ +bug/858618/ comments/ 2 with one easy one being user 2, lifeless.