> Perhaps this? > > select rc.trove_id, count(*) > from releases r, release_classifiers rc > where r.name=rc.name and r.version=rc.version > and r._pypi_hidden=FALSE > group by rc.trove_id
This did work indeed (although it was slower than when doing the counting in Python...) I found that it was semantically incorrect, as packages that have multiple level-three trove ids should be counted only once. I ended up writing a cache for the browse page that gets regenerated after five minutes (r443). Regards, Martin _______________________________________________ Catalog-sig mailing list [email protected] http://mail.python.org/mailman/listinfo/catalog-sig
