list of sources that have hurd binaries uploaded before 2012-04-30 13:20 UTC

last update: Sat, 18 May 2013 03:17:02 +0000


  select suite.suite_name, s.source, s.version
  from source s
    join src_associations sa on s.id = sa.source
    join suite on sa.suite = suite.id
  where
  s.id in (select distinct source from binaries where architecture=4 and created <= '2012-04-30 13:20 UTC')
  and s.id not in (select distinct source from binaries where architecture=4 and created > '2012-04-30 13:20 UTC')
  and suite.suite_name in ('unstable', 'experimental')
  order by suite.suite_name desc, s.source, s.version;

 suite_name |            source             |      version       
------------+-------------------------------+--------------------
 unstable   | atlas                         | 3.8.3-29
 unstable   | autogen                       | 1:5.10-1.1
 unstable   | emacs23                       | 23.2+1-7
 unstable   | evolution                     | 3.2.2-1
 unstable   | gdb                           | 7.4really-1
 unstable   | gnome-system-monitor          | 3.2.1-1
 unstable   | libmemcached                  | 1.0.5-2
 unstable   | libpthread-stubs              | 0.3-3
 unstable   | telepathy-gabble              | 0.14.1-1
 unstable   | telepathy-salut               | 0.6.0-1
 unstable   | xosview                       | 1.9.2-2
 unstable   | xserver-xorg-video-openchrome | 1:0.2.904+svn920-1
(12 rows)