I pushed my summer project, named Relishio, live today. Relishio automatically imports posts from a handful of selected blogs to the queued stories pool, and from there, like any other Pligg site, users relish/vote the best posts to the homepage.
SELECT tag,bCount FROM sc_hottags ORDER BY RAND(),bCount DESC, tag
LIMIT 25 in /home/usebetac/public_html/marktag.com/includes/db/mysql.php on line 390