What you probably want is the news-aggregator package, or actually the modifications to news-aggregator that Simon Carstensen and I have been doing. (It hasn't been released yet because we haven't had time to do proper upgrade scripts.) news-aggregator has a scheduled job that will download RSS files, and frontend pages that will display them in an aggregated format similar to what Radio UserLand presents. You can see a demo at
http://guan.dev.lucmo.com/na/ ("Lucmo" is our codename).
The news_aggregator::aggregator::items_sql proc returns the SQL that the main news aggregator page uses; it's often useful.
I've put a tarball of our package at http://unicast.org/download/news-aggregator.tar.gz . It may or may not work for you, but remember to delete your existing news-aggregator first; we've changed the data model dramatically.
