indi.ca

The MySQL plumbing

Kottu has actually been keeping a record of the top posts ever for a few years now. So there is a Top 100 of sorts, based on clicks out of Kottu. There are 45,000 links dating from May 2007. So about two years of data. Some of the top are just blogs (not posts), like Dom’s blog, or RD’s. There’s still a big enough list. I’ve included some here, and then you can view the Google Spreadsheet here. Note that this is only 1000 out of 45,000, just cause I can’t upload the lot. If anyone wants the whole set or some other output can do. This, of course, isn’t the best posts. If anything it’s the best titles. But it is some data for people, like Cerno, if they’re going about making a collection of the Top 100 Sri Lankan blog posts.

1 http://londonlanka.blogspot.com/ 2093
2 http://divine3.blogspot.com/ 1404
3 http://cerno.wordpress.com 1206
4 http://defencenet.blogspot.com/ 1145
5 http://www.groundviews.org 1125
6 http://dominicsansoni.blogspot.com/ 984
7 http://agradevaduta.wordpress.com/2008/02/26/the-santa-claus-solution/ 980
8 http://www.indi.ca 907
9 http://sosnazzy.blogspot.com/ 790
10 http://themissingsandwich.wordpress.com 750
11 http://www.vikalpa.org/archives/192 699
12 http://agradevaduta.wordpress.com/2008/02/13/suicidal-nation/ 690
13 http://javajones.wordpress.com 672
14 http://www.kanabona.com:80/www 671
15 http://www.lirneasia.net 653
16 http://whisperings.wordpress.com 619
17 http://blacklullaby.wordpress.com 605
18 http://www.hilalscricket.com/ 577
19 http://landlikenoother.blogspot.com/ 569
20 http://chaarmax.blogspot.com/2006/11/raja-fm-clips.html 540
21 http://www.tamilnet.tv/index.php?blog=1 540
22 http://www.tamilnet.tv/index.php/thai-pongal?blog=1 530
23 http://udurawana.com/jokes/blog1.php 524
24 http://dinidudealwis.com 521
25 http://bailabeat.blogspot.com/ 516
26 http://lirneasia.net/2008/08/sri-lanka-pornography-regulatory-commission 512
27 http://pakayas.blogspot.com/ 508
28 http://nazreen.wordpress.com 505
29 http://spicyfoodgood.wordpress.com 504
30 http://ict4peace.wordpress.com 504
31 http://mahasen.blogspot.com/ 482
32 http://alefiyaakbarally.blogspot.com/ 481
33 http://sachini-perera.blogspot.com/ 460
34 http://buddhikaprasanna.wordpress.com 459
35 http://sachini-perera.blogspot.com/2008/03/heart-fm-or-sri-lanka-going-bollywood.html 458
36 http://paan-waati.blogspot.com/ 457
37 http://www.vikalpa.org 443
38 http://chathuranga.blogspot.com/ 438
39 http://electra.blogsome.com 436
40 http://where-will-it-go-we-dont-know.blogspot.com/ 430
41 http://ravana.wordpress.com/2007/06/01/why-i-want-to-stay-in-sri-lanka/ 421
42 http://agradevaduta.wordpress.com/2008/02/18/how-true-is-the-truth-in-wine/ 412
43 http://chitrangi.wordpress.com 406
44 http://thinkfreed.blogspot.com/ 405
45 http://llibertarian.blogspot.com/ 405
46 http://timeseye.blogspot.com/ 398
47 http://tvradiosrilanka.blogspot.com/ 395
48 http://www.indi.ca/2007/06/rajapakses-must-stop-breeding/ 392
49 http://feeds.hilalscricket.com/~r/LankaCricket/~3/375742463/aney-yako-giant-screen-r-premadasa.html 392
50 http://childoftwentyfive.blogsome.com 391
51 http://transcurrents.com/tamiliana 384
52 http://landlikenoother.blogspot.com/2007/06/how-many-sinhalese-assaulted-you.html 383
53 http://www.indi.ca/2007/10/national-insecurity/ 378
54 http://www.indi.ca/2007/09/malaka-silva-should-face-justice/ 376
55 http://themadcatwoman.blogspot.com/ 372
56 http://www.my-halflife.com/ 371
57 http://bandaragama.wordpress.com 371
58 http://daytripper.wordpress.com 369
59 http://themissingsandwich.wordpress.com/2008/09/02/lady-cop/ 369
60 http://amaruwan.blogspot.com/ 365
61 http://www.indi.ca/2007/06/shame/ 363
62 http://www.indi.ca/2008/01/a-personal-post-mortem/ 363
63 http://rameshdesilva.blogspot.com/ 362
64 http://pleasureprinciple.wordpress.com/2008/08/31/eight-the-thing-about-blow-jobs/ 360
65 http://www.indi.ca/2007/05/the-expat-diaries/ 358
66 http://www.indi.ca/2007/12/suicidal-tendencies/ 357
67 http://www.tamilnet.tv/index.php/eelam-event?blog=1 357
68 http://santhoshidays.blogspot.com/ 356
69 http://www.educationforum.lk 355
70 http://www.indi.ca/2007/07/sarong-so-right/ 353
71 http://sachini-perera.blogspot.com/2008/01/diary-from-galle-literary-festival-day.html 353
72 http://narengunasekera.blogspot.com/ 352
73 http://www.indi.ca/2008/01/foreign-agents/ 350
74 http://thinkfreed.blogspot.com/2008/02/got-new-tattoo-yesterday-number-7-and.html 350
75 http://www.indi.ca/2007/07/mahinda-on-facebook-mervyn-on-nation/ 349
76 http://mahavilachchiya.wordpress.com 348
77 http://www.indi.ca/2007/07/opposition-to-rallies/ 346
78 http://lankarising.blogspot.com/ 346
79 http://poetlost.wordpress.com 344
80 http://www.indi.ca/2007/08/none-of-the-above/ 342
81 http://ravana.wordpress.com 339
82 http://www.indi.ca/2007/11/crossovers-corrupt-parliament/ 338
83 http://oshadeesiyaguna.blogspot.com/ 337
84 http://wwwthedarkasylum.blogspot.com/ 337
85 http://defencenet.blogspot.com/2007/06/ltte-launches-massive-counterattack.html 336
86 http://www.indi.ca/2007/06/morning-in-the-life/ 336
87 http://dialogtv.blogspot.com/ 335
88 http://deaned.blogspot.com/search/label/Public 334
89 http://ravana.wordpress.com/2007/06/22/abductions-condoms-and-gotabhaya-rajapaksa/ 334
90 http://blog-is-everything.blogspot.com/2008/07/pioneer-develops-400gb-blue-laser-disc.html 333
91 http://blacklightarrow.wordpress.com/2008/02/07/lets-put-a-stop-to-the-galle-literary-festival/ 331
92 http://agradevaduta.blogspot.com/2007/05/wordpress-vs-blogger-why-you-should.html 329
93 http://webalochana.blogspot.com/ 328
94 http://mockmenot.blogspot.com/ 324
95 http://beyondborders.wordpress.com 320
96 http://www.indi.ca/2007/06/stop-being-terrorized/ 318
97 http://www.indi.ca/2007/08/door-to-door/ 318
98 http://kalharie.blogspot.com/2007/05/how-many-of-you-out-there-support-ltte.html 317
99 http://blacklullaby.wordpress.com/2008/05/04/breaking-the-silence-a-story-told-on-my-behalf/ 316
100 http://www.rockfuse.com/blog 315