Comment 6 for bug 618372

On staging thats still bad.
Without the copy-paste noise:

SELECT COUNT(
DISTINCT DistributionSourcePackageCache.id)
 FROM
 BinaryPackageRelease
 JOIN BinaryPackageBuild
 ON BinaryPackageBuild.id = BinaryPackageRelease.build
 JOIN DistroArchSeries
 ON DistroArchSeries.id = BinaryPackageBuild.distro_arch_series
 JOIN DistroSeries ON DistroSeries.id = DistroArchSeries.distroseries
 JOIN SourcePackageRelease
 ON SourcePackageRelease.id = BinaryPackageBuild.source_package_release
 JOIN DistributionSourcePackageCache
 ON DistributionSourcePackageCache.sourcepackagename
 = SourcePackageRelease.sourcepackagename
 WHERE
 DistroSeries.distribution = 1
 AND DistroSeries.releasestatus != 6
 AND DistributionSourcePackageCache.archive IN (1, 534)
 AND BinaryPackageRelease.binarypackagename = (
 SELECT id FROM BinaryPackageName WHERE name='mplayer');
Time: 6831.607 ms