SELECT build.id, package.name, build.version, build.release
FROM build
    JOIN package on package.id = build.pkg_id
    LEFT OUTER JOIN tag_listing ON tag_listing.build_id = build.id
        AND tag_listing.active IS TRUE
WHERE tag_listing.tag_id IS NULL AND build.state = 1

SELECT b.id, p.name, b.version, b.release
FROM build b, package p
WHERE
    NOT EXISTS
        (SELECT 1 FROM tag_listing tl
         WHERE tl.build_id = b.id
             AND tl.active = TRUE
        )
    AND p.id = b.pkg_id
    AND b.state = 1