Bugs search

Bugs search

Useful queries for testing (bullseye)

434 bugs found

Generated in 4.617 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental , coalesce(popcon_src.insts, 0) as popcon
from bugs  left join popcon_src on (bugs.source = popcon_src.source) 
where id in (select id from bugs_rt_affects_testing) 
and not (id in (select id from bugs_tags where tag='patch')) 
and not (id in (select id from bugs_tags where tag='pending')) 
and not (id in (select id from bugs_tags where tag='security')) 
and not (id in (select id from bugs_usertags where email='bugsquash@qa.debian.org')) 
and not (id in (select id from deferred_closes)) 
and not (id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and component='main')) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
and not (status = 'done') 
AND (severity >= 'serious')
order by source asc