+ create temp table suite_binaries (
+ id integer primary key,
+ package text,
+ source integer,
+ file integer);
+ insert into suite_binaries
+ select b.id, b.package, b.source, b.file
+ from binaries b WHERE b.id in
+ (SELECT bin FROM bin_associations WHERE suite = :suite_id)
+ AND b.architecture in (:arch_id, :arch_all_id);