Comment 1 for bug 1081853

An index on BinaryPackageBuild(source_package_release, distro_arch_series) would improve this a little, but there's no really efficient way today to do what the query wants: get the latest build for a particular (SPN, DAS).