Bugs search

Bugs search

Useful queries for testing (trixie)

277 bugs found

Generated in 4.553 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, status, affects_stable, affects_testing, affects_unstable, affects_experimental , coalesce(testing_autoremovals.removal_time, 0) as autormdate , coalesce(testing_autoremovals.removal_time, 1745045426) as autormtime , coalesce(mb, '-') as missingbuilds
from bugs  left join testing_autoremovals on (bugs.source = testing_autoremovals.source)  left join (
        select string_agg(distinct(wannabuild.architecture),', ' order by wannabuild.architecture) mb, source
        from wannabuild
        where distribution='sid'
        and not vancouvered
        and notes='out-of-date'
        and state not in ('Installed')
        group by source
        ) as wb on (bugs.source = wb.source) 
where id in (select id from bugs_rt_affects_testing) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
and status = 'done' 
and (current_timestamp - interval '5 days' > last_modified) 
AND (severity >= 'serious')
order by last_modified asc