SQL statement for selecting the most commented blog posts in WordPress

This is just a simple SQL statement that lists your 10 most commented WordPress articles:
SELECT p.ID, p.post_title, count(comment_ID) AS num_comments FROM wp_posts p, wp_comments c WHERE p.ID=c.comment_post_ID GROUP BY p.ID, p.post_title ORDER BY num_comments DESC LIMIT 0,10;

Über Stefan

Polyglot Clean Code Developer

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax