SELECT tag.id, tag.name, build.id, build.id, build.version, build.release, build.epoch, build.state, build.completion_time, build.start_time, build.task_id, events.id, events.time, volume.id, volume.name, package.id, package.name, package.name, package.name || '-' || build.version || '-' || build.release, users.id, users.name
            FROM tag_listing, tag, build, users, events, package, volume where
            tag.id = tag_listing.tag_id and
            build.id = tag_listing.build_id and            
            users.id = build.owner and
            events.id = build.create_event and
            package.id = build.pkg_id and
            volume.id = build.volume_id and
            tag_listing.active = TRUE AND tag_id=1234
                AND build.state=1
            ORDER BY tag_listing.create_event DESC;