Navigation: Suites / Filters / Types / Fields / Sort / Format / Search / Results

Bugs search

Useful queries

Suites[1]

Filters

off / include / exclude
  • tagged patch
  • tagged pending
  • tagged security
  • tagged wontfix
  • tagged moreinfo
  • tagged upstream
  • tagged unreproducible
  • tagged help
  • tagged d-i
  • forwarded upstream
  • claimed bugs
  • fixed in deferred/delayed
  • packages not in main
  • packages not in wheezy
  • packages not in jessie
  • packages not in stretch
  • packages in base system
  • packages in standard installation
  • orphaned packages
  • merged bugs
  • marked as done
  • outdated binaries in wheezy
  • outdated binaries in jessie
  • outdated binaries in stretch
  • outdated binaries in sid
  • different versions in stretch and sid
  • newer in Ubuntu than in sid
  • RT tag for wheezy: ignore
  • RT tag for wheezy: will-remove
  • RT tag for wheezy: can-defer
  • RT tag for wheezy: is-blocker
  • RT tag for jessie: ignore
  • RT tag for jessie: will-remove
  • RT tag for jessie: can-defer
  • RT tag for jessie: is-blocker
  • RT tag for jessie: no-auto-remove
  • RT tag for stretch: ignore
  • RT tag for stretch: will-remove
  • RT tag for stretch: can-defer
  • RT tag for stretch: is-blocker
  • RT tag for stretch: no-auto-remove
  • RT unblock hint
  • key packages
  • pseudo packages
  • packages marked for autoremoval
  • closed in packages in new
  • newer than days
  • modified in the last days

Bugs or packages selection


  ignore:
  ignore:
  ignore:
 
 

Additional fields

Sort

Format

215 bugs found

bug# tags package title modified
#832316 [U|S|u]   src:cakephp cakephp: CVE-2015-8379 2016-07-24
#832315   ocfs2-tools Ocfs2/o2cb bug 2016-07-24
#832283 [U|S|u]   src:cakephp cakephp: XML class SSRF vulnerability 2016-07-24
#831857 [S|u]   src:libupnp libupnp: CVE-2016-6255: write files via POST 2016-07-20
#831833 [C|u]   src:bedtools bedtools groupby broken; will break users pipelines. 2016-07-20
#831462   sbuild sbuild: requires gpg in chroot but does not install it 2016-07-17
#831360   lush /usr/bin/lush must not link libbfd-*-system.so dynamically 2016-07-19
#830610   src:python-sunlight python-sunlight: accesses the internet during build 2016-07-09
#830607   src:python-simpy python-simpy: accesses the internet during build 2016-07-09
#830516   clex clex: Cannot read the keyboard input 2016-07-08
#829691   ruby-shoulda-matchers ruby-shoulda-matchers: can not be used to satisfy shoulda dependency 2016-07-15
#829310 [+]   imapproxy imapproxy: fails to install under systemd 2016-07-07
#827079   triggerhappy triggerhappy: Generated event tables are empty, so nothing works. 2016-06-13
#826216   w3c-sgml-lib w3c-sgml-lib: inconsistencies in copyright file 2016-06-03
#826213   w3c-dtd-xhtml w3c-dtd-xhtml: inconsistencies in copyright file 2016-06-03
#826113   gridengine-common gridengine-common: postinst uses /usr/share/doc content (Policy 12.3): /usr/share/doc/gridengine-common/examples/gridengine.default 2016-06-28
#825381 [+]   makejail makejail fails on updating symbolic links 2016-05-26
#825379 [+]   cairo-dock-weather-plug-in cairo-dock-weather-plug-in: weather.com changed API 2016-07-17
#825002   sgml-base sgml-base: broken super catalog after removing docutils-common 2016-06-14
#824718 [+]   nethogs nethogs remains broken in Jessie 2016-05-25
#824160 [U|S|u]   src:p7zip p7zip: CVE-2016-2334 CVE-2016-2335 2016-06-09
#823750 [S]   imagemagick [imagemagick] Multiple security problems 2016-05-29
#823702   src:qpid-cpp Should qpid-cpp be removed? 2016-05-07
#823620 [S]   src:xen Multiple security issues 2016-05-06
#823379 [M]   elmerfem RM: elemerfem -- RoQA; unmaintained, RC-Buggy, FTBFS 2016-07-23
#823178   ruby-bluecloth ruby-bluecloth: obsolete 2016-07-05
#822129   diet Boost 1.55 to be removed; your attention required 2016-05-10
#822078 [d-i]   debian-installer debian-installer: Unbootable system after the installation on Dell XPS13 P54G model 2016-04-21
#821819   sympa sympa: upgrade overwrites configfiles with debconf values 2016-04-19
#821375 [u]   claws-mail-themes claws-mail-themes: Skypilot-Clawssic is non-free 2016-05-16
#819992   fsprotect [fsprotect] Requires aufs kernel module which is not part of Debian 2016-04-05
#819493 [+]   src:debian-security-support debian-security-support: FTBFS on jessie: attemps to install nonexistent security-support-ended.deb8+deb8u3 file 2016-03-31
#817305   src:qemu-launcher qemu-launcher: Removal of dh_desktop 2016-04-02
#817231   src:rabbitvcs rabbitvcs: All files in home folder removed 2016-07-22
#816759 [+|S]   minissdpd minissdpd: CVE-2016-3178 CVE-2016-3179 2016-05-04
#816593 [whe]   src:iceweasel [FTBFS] iceweasel esr for wheezy on amd64 2016-05-06
#815935 [whe]   src:phoronix-test-suite phoronix-test-suite: FTBFS with nonexistent $HOME 2016-02-25
#815154   gnome-control-center Removes XKBMODEL and XKBOPTIONS from /etc/default/keyboard 2016-02-25
#814589   src:otrs2 otrs2: source-less files; undocumented copyrights/licenses; abuse of lintian-overrides; systematic DFSG violations 2016-04-01
#814445 [u]   src:libsdl1.2 Non-Free file: src/stdlib/SDL_qsort.c 2016-03-05
#813880   src:tokyocabinet tokyocabinet: testsuite failures on some archs 2016-02-06
#813778   openwince-jtag Maintainer address bounces 2016-02-05
#813776   openwince-include Maintainer address bounces 2016-02-05
#813775   linux-atm Maintainer address bounces 2016-06-25
#811799   basic256 basic256: FTBFS with GCC 6: error: reference is ambiguous 2016-06-29
#811091   src:xtrkcad xtrkcad: missing and outdated licenses. 2016-02-17
#810153   busybox don't source initramfs.conf in busybox initramfs hook 2016-01-17
#809843   src:autopsy autopsy: maintainer address bounces 2016-01-10
#809813   gnuplot-doc gnuplot contain "lena" images 2016-06-07
#809733 [U|S|u]   src:activemq activemq: CVE-2015-5254: unsafe deserialization 2016-03-13
#808472   gnu-efi gnu-efi copyright file is wrong, includes GPL-licensed code on arm 2016-06-30
#808463   ntfs-3g non-free code in boot.c 2016-04-22
#808433 [U|+]   nethogs nethogs doesn't start, saying "creating socket failed" 2016-07-12
#808216 [+]   debmirror debmirror: Debmirror seeems to have problems with new SHA256 in Packages.diff/Index files 2016-06-19
#808004   libdiet-client2.8 libdiet-client2.8: not installable on sid 2016-05-09
#807487   pbuilder pbuilder fails when using aptitude resolver with aptitude 0.7.5 2015-12-11
#807074   fbreader fbreader: includes files with unclear DFSG-freeness and/or copyright status 2016-02-22
#806946   bindgraph bindgraph doesn't show any graphic 2016-02-29
#806930   pianobar pianobar needs update for new server SSL certificate 2015-12-05
#806273   os-prober os-prober: remove or disable-per default the non grub-mount based probing 2016-01-21
#805370 [u]   mpage mpage: non-free license 2015-11-17
#803658   plymouth boot hangs before cryptsetup passphrase prompt 2015-12-04
#803033   src:catdoc catdoc: non-free Unicode files 2015-12-23
#803003   ess ess: Maintainer field points to moderated mailing list 2015-10-27
#802776   src:matplotlib matplotlib: ttf-bitstream-vera missing in "Depends:" of python-matplotlib-data 2016-01-09
#802759   src:ampache-themes ampache-themes: non-free files (CC-BY-NC-SA-3.0 and IEC61966-2.1) 2015-10-23
#801582   nvram-wakeup grub-pc: default entry becomes Halt once (for setting alarm) => no boot 2015-11-04
#801046 [M|+]   git fatal: Out of memory, malloc failed (tried to allocate 524288000 bytes) 2016-05-18
#800913   nama nama: ChainSetup fails rendering all sound operations useless 2015-12-29
#799715 [+]   gxmessage gxmessage: ships /usr/share/info/dir.gz on arm64 2016-05-15
#799441   hijra-applet GNOME shell extension not compatible with recent GNOME versions 2015-10-20
#799313   src:jbofihe jbofihe: FTBFS under some locales (eg. fr_CH.UTF-8) 2015-09-17
#799311   src:fontmatrix fontmatrix: FTBFS: error: invalid new-expression of abstract class type 'IcuFontImpl' 2015-09-17
#798886 [U|S|u]   src:ipython ipython: CVE-2015-6938: XSS vulnerability 2016-01-07
#798862 [+|S|u]   shutter CVE-2015-0854: Insecure use of system() 2015-11-06
#798805 [+|P]   fonts-cantarell fonts-cantarell: Switch to autohinting to work around blurry rendering with CFF 2015-09-21
#797547   pgsnap pgsnap seems too old in Jessie 2016-05-06
#797046 [+|S]   src:libtorrent-rasterbar CVE-2015-5685: remote execution vulnerability in lazy_bdecode() 2016-03-23
#796495 [S]   yubiserver yubiserver: multiple vulnerabilities, affecting old/stable? 2016-01-03
#796235   rinetd rinetd fills up the logs until disk is full up if it cannot bind 2016-01-11
#796197 [S]   src:sogo CVE-2015-5395 2015-09-06
#796114 [S]   src:netty CVE-2015-2156 2015-09-12
#796033   src:ocamlodbc ocamlodbc: FTBFS under almost any locale (eg. en_GB.UTF-8) 2015-10-17
#794850   src:cl-plplot cl-plplot: non DFSG file in the source package 2015-08-08
#794849   os-prober linux: custom linux-image packages fail to install 2015-08-12
#794461   python-mock RequirementParseError: Expected version spec in funcsigs; python_version<"3.3" at ; python_version<"3.3" 2016-01-17
#793895 [whe]   src:netperf netperf: FTBFS with -Werror=format-security 2015-07-28
#793492 [C]   azureus Should this package be removed? 2016-03-09
#793465 [+|S|u]   src:libuser DoS and privilege escalation by local users (CVE-2015-3245 and CVE-2015-3246) 2016-05-30
#792927   python-ownet Python ownet library cannot access sensor's attribute 2015-08-21
#792925   webalizer webalizer: Webalizer stopped parsing squid logs (after 1 may 2015) saying Invlid Date Format 2015-07-22
#792852   gcom gcom: copyright file missing after upgrade (policy 12.5) 2015-07-21
#792126   mbr mbr:i386 self-tests depend on VM86 2016-06-29
#792078 [u]   cantor-backend-qalculate cantor-backend-qalculate: GPL3 not documented/incompatible mixing of GPL2/3 code 2016-06-24
#791838   src:php-ps php-ps: FTBFS on sid due to unsatisfiable build-dependency on libgd2-(no)xpm-dev 2015-07-08
#789407   pidgin-openpgp unable to send openpgp messages 2015-06-20
#789197 [S|u]   src:libmimedir libmimedir: CVE-2015-3205 2015-06-23
#788833 [U|+|S|u]   src:chicken chicken: CVE-2015-4556: buffer overrun in CHICKEN Scheme's string-translate* procedure 2016-06-12
#788725   src:jffnms [src:jffnms] Some sources are not included in your package 2016-04-02
#788350 [C]   libhttp-proxy-perl FTBFS - proxy tests 2015-06-12
#788322   src:yui [yui] Some sources are not included in your package 2015-06-10
#788319   src:yui3 [yui3] Some sources are not included in your package 2015-06-10
#788008   libcgi-application-plugin-anytemplate-perl libcgi-application-plugin-anytemplate-perl: missing dependency on libclone-perl 2015-06-07
#787594   freemat Some sources are not included in your package 2016-01-25
#787361   xhtmlrenderer [RC][cc-by-nc-sa] Please clarify license of a few svg files 2016-01-11
#787359   squirrelmail-spam-buttons [RC][cc-by-nc-sa] Please clarify license of a few files (false positive ?) 2015-05-31
#787355   src:openclipart2 [RC][cc-by-nc-sa] Please clarify license of a few svg files 2015-05-31
#787350   src:fontmatrix [RC][cc-by-nc-sa] Please clarify license of a few svg files 2015-05-31
#786694 [+]   fftw fftw: FTBFS with TZ=GMT-14 2015-06-26
#786442   squirrelmail some lines don't appear in some messages 2016-02-16
#786338   ears ears: broken since python-musicbrainz has been removed 2015-05-21
#784619 [U|u]   src:creepy [creepy] Qt4's WebKit removal 2016-05-28
#784446   backup-manager backup-manager: Current incremental backup implementation can cause data loss 2016-03-22
#783721   dnssec-tools dnssec-tools: dnssec-signzone behaviour changed; new signed zonefiles unparseable by rollerd 2016-02-01
#783545   xul-ext-automatic-save-folder Doesn’t work, abandonned upstream 2015-08-21
#783346 [+]   xen-utils-4.1 patch for booting Jessie domU with wheezy dom0 2015-10-24
#781595 [P|S]   src:xdeb xdeb: disables apt's signature checks 2015-12-30
#780875 [U|S|u]   mantis mantis: MantisBT <1.2.19 multiple vulnerabilities (Access control bypass/XSS/SQL injection/etc) 2015-03-20
#780429 [jes-i]   snmp-mibs-downloader snmp-mibs-downloader: postinst uses /usr/share/doc content (Policy 12.3): /usr/share/doc/mibrfcs/* 2015-04-01
#780323   coreutils /bin/cp: cp: *deletes* files' contents with --attributes-only option 2015-03-23
#780207   mdadm default HDD block error correction timeouts: make entire! drives fail + high risk of data loss during array re-build 2015-04-18
#779803 [F|S]   smuxi smuxi performs autoconnect on first startup 2015-08-27
#779468   apt-spy apt-spy: creates an invalid sources list 2015-03-08
#778747 [jes-i|S]   openssl openssl: RFC 7465 says RC4 is broken, never to be used 2016-01-05
#777184 [jes|+|whe]   ltsp-client-core ltsp-client: insserv: script ltsp-client-setup: service ltsp-client-setup already provided! 2015-07-19
#776512 [+]   mantis function InsertData() is defined twice: installation is broken 2015-05-12
#776118   nagios3-cgi nagios3-cgi: prompting due to modified conffiles which were not modified by the user: /etc/nagios3/cgi.cfg 2015-01-24
#775689 [d-i]   src:unetbootin Do NOT use unetbootin for Debian CD images 2016-06-01
#775346 [U|+|S|u]   chicken chicken: CVE-2014-9651: buffer overrun in CHICKEN Scheme's substring-index 2016-06-12
#775183 [+]   spamass-milter spamass-milter adds bad Received: header, creating false positive 2016-03-14
#774931   asr-manpages asr-manpages: Unknown licensing status 2015-01-18
#774891 [C|whe]   gtkpod gtkpod: unhandled symlink to directory conversion: /usr/share/doc/PACKAGE 2015-01-15
#774290   worldwind worldwind: Immediate crash (HeadlessException) with 'Java(TM) SE Runtime Environment (build 1.7.0_45-b18' 2014-12-31
#774149 [H|+]   usbmount usbmount: Can't mount ntfs drive (Transport endpoint is not connected) 2016-04-25
#773808   openclipart2 Openclipart2 included non-free images. 2014-12-23
#773059   ogre-doc ogre-doc: unhandled symlink to directory conversion: /usr/share/doc/PACKAGE 2014-12-13
#772795   grub-pc grub installation fails on a fakeraid/sataraid/dmraid system 2016-04-14
#772794 [S|u]   qpid-cpp qpid-cpp: Multiple security issues 2015-02-02
#771040   yaboot-installer installation-reports: Messes up Mac OS 9 driver partitions 2016-04-12
#770492 [S]   src:linux linux-image-3.16.0-4-686-pae: chown removes security.capability xattr on other users' files (CVE-2015-1350) 2016-06-08
#770402   nautilus-dropbox nautilus-dropbox: hangs during installation with 100% cpu usage 2015-09-14
#770369   eterm Eterm: does not run shell 2016-03-05
#770130 [M]   xserver-xorg-video-intel gnome-shell: crashes with "Failed to create texture 2d" after "[drm:i8xx_irq_handler] *ERROR* pipe A underrun" 2015-03-17
#769798   openswan-modules-dkms openswan-modules-dkms: module FTBFS with linux-headers-3.2.0-4-amd64 3.2.63-2+deb7u1 2015-01-25
#767572   libthunar-vfs-1-2-dbg libthunar-vfs-1-2-dbg: fails to upgrade from squeeze - trying to overwrite /usr/lib/debug/usr/lib/libthunar-vfs-1.so.2.3.1 2014-11-01
#766250 [|whe]   eject eject: [kfreebsd] fails to open cdrom tray 2016-06-07
#763824 [+]   libtar0 writes archives with checksums itself deems wrong 2014-10-05
#762950   libsolid4 digikam: Removes all images from database when unaccessible mount is found 2016-05-14
#762835   openafs-fileserver error exit on dafileserver (segfault) 2016-04-19
#759936   proftpd-mod-vroot proftpd-mod-vroot: Module is broken because of erroneous function vroot_lookup_path 2014-09-03
#758558 [u]   couchdb Includes file with unclear license 2014-08-19
#757771 [l10n]   rar rar: Incorrect handling of file names containing international characters when creating an archive 2014-08-25
#755992 [M]   proftpd-mod-clamav proftpd-mod-clamav: error: Can not stat file (9): Bad file descriptor 2015-04-07
#755637   src:django-genshi django-genshi: Please ensure it works with Django 1.7 2016-01-03
#755634   src:python-django-websocket python-django-websocket: Please ensure it works with Django 1.7 2016-01-03
#755618   src:python-django-djapian python-django-djapian: Please ensure it works with Django 1.7 2016-03-09
#755605   src:django-threaded-multihost django-threaded-multihost: Please ensure it works with Django 1.7 2016-01-03
#755600   src:djagios djagios: Please ensure it works with Django 1.7 2016-03-02
#755586   src:django-app-plugins django-app-plugins: Please ensure it works with Django 1.7 2016-01-03
#753927 [whe]   src:usbredir usbredir: Broken patch disallows dpkg-source unpack 2014-07-06
#753922 [whe]   src:herculesstudio herculesstudio: Broken patch disallows dpkg-source unpack 2014-07-06
#753235 [jes|+|sid|str|whe]   src:lldpad lldpad: FTBFS: dpkg-source: error: expected ^--- in line 2 of diff `lldpad-0.9.46/debian/patches/fix-typo-in-lldptool-ets-8.patch' 2016-02-05
#752610 [jes-i|S]   lynx-cur lynx: Can connect to CVE-2014-0092 test site 2015-02-01
#752381   src:grub2 initramfs-tools: does not activate logical volume before trying to mount root filesystem on LVM 2015-08-17
#751367 [whe]   dictionaries-common unupgradeable: "shared/packages-wordlist doesn't exist" 2015-04-30
#750943 [+|u|whe]   stunnel4 stunnel4: init script missing lsb-required status target 2014-10-16
#750141 [M|S]   libqt4-xml libqt4-xml: vulnerable to billion laughs attack (CVE-2013-4549) 2014-06-10
#749833 [jes-i]   scilab scilab: Scilab include non-free codes 2016-03-09
#748130 [whe]   libscotch-5.1 on wheezy/amd64: libscotch-5.1 depends on mpich while mpi-default is openmpi 2014-09-03
#746937   xmail xmail links against libssl but doesn't have openssl exception in License 2014-05-04
#744698   src:fontmatrix [fontmatrix] [DFSG] missing source 2014-11-08
#743955   coreutils coreutils: corrupted files on heavily fragmented ext3 and ext4 partitions 2016-01-15
#743828 [S|whe]   redmine redmine: security: CVE-2014-1985: open redirector issue 2014-12-31
#740998 [ipv6]   rdnssd NetworkManager and rdnssd do not play well together 2016-03-30
#740911 [U|+|whe]   evolution-data-server WebDAV: Evolution sends invalid REV field, DAViCal expects timestamp 2015-04-30
#740463   libelmersolver-6.1 libelmersolver-6.1.so links with both GPL-licensed and GPL-incompatible libraries 2014-03-02
#740111   icedtea-netx icedtea-netx: NullPointerException in SwingUtilities.appContextGet 2016-04-22
#739251 [S]   iptables iptables: Upgrade breaks existing rules (and is not documented) 2016-01-28
#737395   funny-manpages funny-manpages: Copyright problem 2014-09-07
#735935 [+]   grub-common grub2: LVM trouble at boot with several PVs 2016-04-14
#735260 [d-i]   yaboot-installer installation-reports: Jessie Netinst for PowerPC-64 creates will not boot after installation -- but works for PowerPC-32 2016-04-12
#734365   freeplayer freeplayer: unknown option or missing mandatory argument (while calling vlc) 2015-08-30
#731178   dante-server dante-server: requires libc6-dev to be installed 2016-04-09
#730104 [S]   yui yui: CVE-2013-6780 2014-01-03
#729986   libnss-mysql-bg libnss-mysql-bg: Patch 04_shadow.diff Introduces Lock Acquisition Hang 2015-02-23
#729975 [u]   hotot hotot: Wheezy version no longer usable with Twitter, uses retired 1.0 API 2015-04-29
#727245 [C]   abook abook: Add an address to Abook with Mutt delete all phone numbers 2015-12-31
#725417 [+|u]   mbr mbr: install-mbr wipes the disk-id portion of the MBR, rendering Windows 7 unbootable 2016-01-18
#722892   nautilus-pastebin nautilis-pastebin: Does not appear in file menu 2016-02-18
#715569 [whe]   proftpd-mod-vroot Official mod_vroot lib broken, lib built from source works 2015-09-16
#712510 [whe]   python-whoosh python-whoosh FTBFS:some tests failed on mips 2013-12-24
#712102   pidgin-microblog Plugin no longer functions with Twitter or Identica 2013-08-29
#709641   libaudiomask-dev libaudiomask-dev: symlink pointing to wrong location 2014-08-05
#709198 [jes-i]   debconf debconf: should not use python in maintainer scripts 2014-11-06
#709085   dvifb dvifb suffers total font failure 2013-05-20
#707305 [whe]   libquicktime2 runtime error on load, "can execute code" 2013-06-14
#706909   smartmontools smartmontools: updated drivedb.h should go to /var 2016-02-05
#706877 [whe]   insserv insserv: breaks dist-upgrade by installing before packages fix their init scripts 2014-12-28
#704303 [+]   iceweasel iceweasel: MPL license text is missing 2016-02-20
#701674   apf-firewall apf-firewall doesn't work with kernel-version >= 3.0 2015-07-18
#684499 [C|U|+]   dovecot-core dovecot-core: Expunged messages continue to reappear 2016-03-02
#678512 [ipv6|S]   ruby-eventmachine ruby-eventmachine: crashes when using IPv6 socket 2016-07-16
#666414   src:rggobi FTBFS on s390x: Segmentation fault during installation 2014-07-13
#665199   slapd slapd: fails to install, remove, distupgrade, and install again 2016-04-11
#642411 [R]   cltl endless loop installing cltl 2014-04-26
#635711 [H|+]   monkeysphere error on install 2015-05-07
#629337   src:gosa-perl gosa-perl: uses Switch.pm, removed in perl 5.14 2015-06-19
#629334   src:gbackground gbackground: uses Switch.pm, removed in perl 5.14 2015-06-19
#545827   toshset toshset does not work on 2.6.29 and later kernels 2016-06-19
#517472 [+|u]   libxml-libxml-perl libxml-libxml-perl: Missing versioned dependency on libxml2 - Causes runtime warnings 2015-08-31
#504099   gnu-fdisk gnu-fdisk: fails to display GPT partition properly 2013-06-29
#479096   libacpi libacpi0: getting battery status broken by missing support for new sysfs names 2016-03-14
#412185 [+]   atftpd Upgrade overwrites /etc/default/atftpd, inetd.conf 2016-07-21
#330695 [C|+|P]   libldap-2.4-2 libldap2: /etc/ldap/ldap.conf breaks multiarch and on soname change 2016-05-14
#128745 [+]   libstroke0-dev libstroke0-dev: aclocal is confused by libstroke .m4 files 2016-07-05

Generated in 1.041 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental from bugs 
where id in (select id from bugs_rt_affects_oldstable) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
AND (severity >= 'serious')
order by id desc