Launchpad itself

  1. Bug #866100
  2. Comment #8

Comment 8 for bug 866100

Revision history for this message
Robert Collins (lifeless) wrote :

SELECT BugTask.*, Bug.*
FROM BugTask, Bug, BugAffectsPerson
WHERE
    Bug.id = BugTask.bug
    AND BugTask.product = 10294
    AND BugTask.status IN (10, 15, 20, 21, 22, 25)
    AND Bug.duplicateof IS NULL
    AND Bug.id = BugAffectsPerson.bug
    AND BugAffectsPerson.person = 78
    AND BugAffectsPerson.affected IS TRUE
ORDER BY BugTask.importance DESC, BugTask.bug LIMIT 76 OFFSET 0;