list of sources that have hurd binaries uploaded before 2012-04-30 13:20 UTC last update: Fri, 29 Mar 2024 09:17:01 +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 ------------+--------+--------- (0 rows)