Как вывести Все страницы сайта с последним комментарием на сайте WordPress

<?php
global $wpdb;

// Считаем общее количество опубликованных записей с хотя бы одним одобренным комментарием
$total_commented_posts = $wpdb->get_var( "
    SELECT COUNT(DISTINCT c.comment_post_ID)
    FROM {$wpdb->comments} c
    INNER JOIN {$wpdb->posts} p ON c.comment_post_ID = p.ID
    WHERE c.comment_approved = '1'
      AND p.post_status = 'publish'
" );

echo '<p style="font-weight: bold; color: #333; margin: 0 0 20px; font-size: 16px;">Всего страниц с комментариями: ' . (int) $total_commented_posts . '</p>';
?>

<div class="com">
<?php
$commented_posts = $wpdb->get_results( "
    SELECT 
        c.comment_post_ID,
        MAX(c.comment_date_gmt) as last_comment_date
    FROM {$wpdb->comments} c
    WHERE c.comment_approved = '1'
    GROUP BY c.comment_post_ID
    ORDER BY last_comment_date DESC
" );

foreach ( $commented_posts as $item ) {
    $post_id = $item->comment_post_ID;
    $post    = get_post( $post_id );

    if ( ! $post || 'publish' !== $post->post_status ) {
        continue;
    }

    // Метка
    if ( 'product' === $post->post_type ) {
        $label = 'Каталог';
    } elseif ( 'knowledgebase' === $post->post_type ) {
        $label = 'База знаний';
    } else {
        $label = 'Блог';
    }

    // Последний комментарий
    $comment = $wpdb->get_row( $wpdb->prepare( "
        SELECT comment_author, comment_content, comment_date_gmt
        FROM {$wpdb->comments}
        WHERE comment_post_ID = %d
          AND comment_approved = '1'
        ORDER BY comment_date_gmt DESC
        LIMIT 1
    ", $post_id ) );

    if ( ! $comment ) {
        continue;
    }

    $title   = esc_html( $post->post_title );
    $url     = get_permalink( $post_id );
    $author  = esc_html( $comment->comment_author );
    $text    = esc_html( wp_trim_words( $comment->comment_content, 30, '…' ) );
    $date    = mysql2date( 'j F Y', $comment->comment_date_gmt );

    echo '<div class="co">';
    echo '  <span class="co-label">' . esc_html( $label ) . '</span>';
    echo '  <span class="co-date">' . esc_html( $date ) . '</span>';
    echo '  <a href="' . esc_url( $url ) . '" target="_blank" class="co-title">' . $title . '</a>';
    echo '  <span class="co-author">' . $author . '</span>';
    echo '  <span class="co-t">' . $text . '</span>';
    echo '</div>';
}
?>
</div>