1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

Find Your Most-Commented Blog Categories in Wordpress?

Discussion in 'SQL - Questions and Answers' started by ben, May 19, 2006.

  1. ben Administrator

    Dialect: MySQL
    How can I find out which blogging categories are the most commented?
    ben, May 19, 2006
    #1

  2. ben Administrator

    Dialect: MySQL
    This question was posted on [a href="http://www.openwin.org/mike/index.php/archives/2006/05/find-your-most-commented-blog-categories/trackback/"]Mike Hillyer's blog[/a], which he kindly allowed to be posted here.

    SQL:

    
SELECT wp_categories.cat_name, COUNT(wp_comments.comment_id) 
    
FROM wp_categories 
    
LEFT JOIN wp_post2cat ON wp_categories.cat_id = wp_post2cat.category_id 
    
LEFT JOIN wp_comments ON wp_post2cat.post_id = wp_comments.comment_post_id
    
WHERE comment_approved != ’spam’
    
GROUP BY wp_categories.cat_id
    
ORDER BY 2 DESC


    +------------------------------------------+-------------------------------+
    | cat_name | COUNT(wp_comments.comment_id) |
    +------------------------------------------+-------------------------------+
    | MySQL | 307 |
    | Visual Basic 6 | 236 |
    | General | 119 |
    | Open Source | 43 |
    | Rants | 42 |
    | Crystal Reports | 40 |
    | News | 39 |
    | Gadgets | 26 |
    | Windows | 24 |
    | PHP | 21 |
    | 2006 MySQL User's Conference & Expo | 13 |
    | VB.NET | 12 |
    | 2004 MySQL User's Conference & Expo | 10 |
    | Reviews | 7 |
    | 2005 MySQL User's Conference & Expo | 6 |
    | Photography | 5 |
    | MySQL Tip of the Week | 4 |
    | Hardware | 3 |
    | Money | 2 |
    +------------------------------------------+-------------------------------+
    19 rows in set (0.16 sec)
    ben, May 19, 2006
    #2

  3. LnddMiles New Member

    Leonard D. Miles

    Dialect: ANY
    Great post! I’ll subscribe right now wth my feedreader software!
    LnddMiles, Jul 21, 2009
    #3

  4. BaakoSmith New Member

    Seeking a beatiful Wordpress theme??

    Dialect: ANY
    Gday,

    Have you ever think about starting your own blog? There are many great platforms, but by far the best is Wordpress. It is fast to set up, however the themes just never fit my needs. I looked for a simple solution to this problem and realized that there wasn't one. I then had a template custom made for my needs and was so happy with the outcome. I then decided to build a website that would show the world how to easily hire an expert in wordpress design.


    Wordpress Theme
    BaakoSmith, Aug 23, 2009
    #4

  5. Phoenixlee New Member

    Great post!Thank you for all the things learned from here and congratulations for the good work.
    Phoenixlee, Mar 29, 2012
    #5

Share This Page