Bugs search

Bugs search

Useful queries for testing (forky)

61 bugs found

Generated in 2.145 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, 1804300421) as autormtime , coalesce(key_packages.reason, '') as whykey, to_char(lastupload_s,'YYYY-MM-DD') as lastupload
from bugs  left join testing_autoremovals on (bugs.source = testing_autoremovals.source)  left join key_packages on (bugs.source = key_packages.source)  left join (
        select max(date) lastupload_s, s1.source
        from sources s1, upload_history uh
        where s1.source = uh.source
        and s1.version = uh.version
        and s1.release='sid'
        group by s1.source
        ) as lu on (bugs.source = lu.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 ( id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag = 'out-of-sync') ) 
AND (severity >= 'serious')
order by lastupload_s asc