Comment 2 for bug 618372

Timing is on.
lpmain_staging=> SELECT COUNT(*) FROM (SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdescriptions, DistributionSourcePackageCache.binpkgnames, DistributionSourcePackageCache.binpkgsummaries, DistributionSourcePackageCache.changelog, DistributionSourcePackageCache.distribution, DistributionSourcePackageCache.id, DistributionSourcePackageCache.name, DistributionSourcePackageCache.sourcepackagename FROM BinaryPackageBuild, BinaryPackageName, BinaryPackageRelease, DistributionSourcePackageCache, DistroArchSeries, DistroSeries, SourcePackageName, SourcePackageRelease WHERE DistroSeries.distribution = 1 AND DistroSeries.releasestatus != 6 AND BinaryPackageRelease.binarypackagename = BinaryPackageName.id AND DistroArchSeries.distroseries = DistroSeries.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND BinaryPackageRelease.build = BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = SourcePackageName.id AND DistributionSourcePackageCache.sourcepackagename = SourcePackageName.id AND DistributionSourcePackageCache.archive IN (1, 534) AND BinaryPackageName.name = 'mplayer') AS "_tmp";
 count
-------
     1
(1 row)

Time: 23046.859 ms