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).

Random entries

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

Recent Assets

  • 2023-09-24-jong-tegen-oud-1.jpg
  • 2023-09-24-jong-tegen-oud-2.jpg
  • just-call-me-fred.png
  • foggy-morning.png
  • oma-2023-07-27.jpg
  • i-almost-died.png
  • chipping-from-twenty-meters.png
  • de-koepel.png
  • screenshot-www.udemy.com-2023.05.18-10_02_39.png
  • screenshot-www.golf.nl-2023.05.08-09_57_30.png
  • IMG-20230423-WA0000.jpg
  • me-and-my-radio-paradise-hat.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 2498 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.

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

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

My father passed away 10-20-2000 ago.

My mother passed away 3-27-2018 ago.

Started Gishtech 04-25-2016 ago.