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
with spns as (select sourcepackagename from SourcePackagePu blishingHistory join
SourcePack ageRelease on SourcePackageRe lease.id = SourcePackagePu blishingHistory .sourcepackager elease blishingHistory .distroseries = 106 blishingHistory .archive IN (1, 534) blishingHistory .component IN ('3') blishingHistory .status = 2) select bug.id FROM BugTask distribution = 1 sourcepackagena me in (select sourcepackagename from spns)
AND SourcePackagePu
AND SourcePackagePu
AND SourcePackagePu
AND SourcePackagePu
JOIN Bug ON BugTask.bug = Bug.id
WHERE Bug.id = BugTask.bug
AND BugTask.
AND ((BugTask.status = 10))
AND Bug.duplicateof IS NULL
AND Bug.private = FALSE
and bugtask.
ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76
OFFSET 0
Time: 860.792 ms