Most comments

| Blogs etc. | 1 Comment

In order to find out which blog entries of mine have the most comments so far, this is the SQL query that can be used:

SELECT mt_comment.comment_entry_id, COUNT(*) AS cnt FROM mt_comment WHERE mt_comment.comment_visible=1 GROUP BY mt_comment.comment_entry_id ORDER BY cnt DESC LIMIT 25;

As you can see over there on the righthand margin under the 'Most comments' section, I have enumerated the top twenty five.

Have a look and tell me what you think.

1 Comment

Turns out that I left something important out, namely that all my comments must first be approved by me before they become visible. Therefore, the query should include where comment_visible is true (added).

Leave a comment

Random entries

Here are some random entries that you might be interested in:

Recent Assets

  • Tenerife-flight-path.png
  • listen-to-me-marlon.jpg
  • sneeuwval.jpg
  • frozen-crystals.png
  • winter-is-coming.png
  • donald-trump.png
  • Rex-indian-headdress.png
  • Liam-future-famous-golfer-2016-10.jpg
  • number-one.png
  • Mom-and-me-2016.png
  • 636101580191153661-Kiffen-0003675-02.jpg
  • the-haskell-road-ro-logic.png

Recent Comments

  • Most comments: Turns out that I left something important out, nam ...
    - Kiffin

Golf Handicap


This personal weblog was started way back on July 21, 2001 which means that it is 7-21-2001 old.

So far this blog contains no less than 2279 entries and as many as 1881 comments.

Important events

Graduated from Stanford 6-5-1979 ago.

Kiffin Rockwell was shot down and killed 9-23-1916 ago.

Believe it or not but I am 10-11-1957 young.

Began well-balanced and healthy life style 1-8-2013 ago.

My father passed away 10-20-2000 ago.

First met Thea in Balestrand, Norway 6-14-1980 ago.