Comment 3 for bug 731679

with spns as (select sourcepackagename from SourcePackagePublishingHistory join
            SourcePackageRelease on SourcePackageRelease.id = SourcePackagePublishingHistory.sourcepackagerelease
  AND SourcePackagePublishingHistory.distroseries = 106
  AND SourcePackagePublishingHistory.archive IN (1, 534)
  AND SourcePackagePublishingHistory.component IN ('3')
  AND SourcePackagePublishingHistory.status = 2) select bug.id FROM BugTask
JOIN Bug ON BugTask.bug = Bug.id
WHERE Bug.id = BugTask.bug
  AND BugTask.distribution = 1
  AND ((BugTask.status = 10))
  AND Bug.duplicateof IS NULL
  AND Bug.private = FALSE
  and bugtask.sourcepackagename in (select sourcepackagename from spns)
ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76
OFFSET 0

Time: 860.792 ms