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

  • flitsfoto-B5H3-IoN-b9E4tr9OrFarmWfWrP5pxuN8AgYw45ABAnqqDrmjSqIc-KKoAQ9Bu_k.jpeg
  • flitsfoto-mjuWdZ1wBk6gJbu9rP7Bu6bETxZplWXFUoEJIA_HfMF0i0MQfgF_y5024mEsOBfH.jpeg
  • Kiffin-10th-hole-2017-05-small.jpg
  • Kiffin-10th-hole-2017-05.jpg
  • ember-rails-and-json-api.png
  • screenshot-www.golf.nl-2017-05-04-15-38-01.png
  • putting-mat.png
  • finished-just-in-time.png
  • Tenerife-flight-path.png
  • listen-to-me-marlon.jpg
  • sneeuwval.jpg
  • frozen-crystals.png

Recent Comments

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

Golf Handicap

Information

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 2288 entries and as many as 1877 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.