- create temp table suite_binaries (
- id integer,
- 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);