Code review comment for lp://staging/~mbp/launchpad/858618-affecting-me

Revision history for this message
Martin Pool (mbp) wrote :

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 = BugAffectsPerson.bug
                AND BugAffectsPerson.person = 16
                AND BugAffectsPerson.affected = TRUE
            )

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.

« Back to merge proposal