package: bugs.debian.org == debbugs=> select a.bug_id, a.archived, b.type_id, c.bug_id, c.archived from bug a join bug_assoc b on a.bug_id = b.from_id join bug c on b.to_id = c.bug_id where a.archived = 'N' and c.archived = 'Y' and b.type_id = 'MERGED_WITH'; bug_id | archived | type_id | bug_id | archived --------+----------+-------------+--------+---------- 518921 | N | MERGED_WITH | 526519 | Y (1 row) == doogie@busoni:/org/bugs.debian.org/spool$ grep Merged-With db-h/21/518921.summary archive/63/521863.summary archive/19/526519.summary db-h/21/518921.summary:Merged-With: 521863 526519 archive/63/521863.summary:Merged-With: 518921 526519 archive/19/526519.summary:Merged-With: 518921 521863 ==
-- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org