« AvantGo mobile version | Main | visitors with the most comments »
Using the MTSQL plugin, you can easily create a list of the entries on your blog that have the most comments. Use this query.
Formerly, I did this with a PHP hack (scroll up the page of the previous link), but this required a huge index of all entries, which slowed down my rebuilds. So I removed it. Once I discovered the SQL query, I added it back. Much simpler this way.
This tip is built on the following tip(s):
The following tip(s) expand on this tip:
This entry is about display. The ten most recent entries also about this topic are:
easier management of blogrolls and media
clean up troublesome characters from copy-n-paste
RSS feed of trackbacks for entries
creating a Google Sitemap for your blog
more fun with keywords and tags
using keywords and tags to help visitors find related content
cheap and easy way to show "what links here"
View all entries about display.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 |
Subscribe to this blog's feed