Xarn fan club thread

Basically, this thread is to celebrate Xarn.
Xarn's blag: http://cairnarvon.rotahall.org/
Haskell II: http://www.youtube.com/watch?v=CWPDZblqP7M

His blog is down at the moment, ``MySQL is a piece of shit''
Here here.

>>39
SELECT "http://dis.4chan.org/read/prog/" || thrid as URL FROM (SELECT thrid, count(thrid) as post_count FROM posts GROUP BY thrid) WHERE post_count > 1000

Unfortunately, it seems to return only one result. I suspect this is because of threads having posts deleted. For example, see http://dis.4chan.org/read/prog/1204983387/958. It would be far simpler to search http://dis.4chan.org/prog/subject.txt. (Maybe you could use progscrape to do that.)