-
have_posts()) : // Custom recent posts for Simplr ?>
- get_results("SELECT comment_author, comment_author_url, comment_ID, comment_post_ID, SUBSTRING(comment_content,1,65) AS comment_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 5"); ?>
-
- comment_post_ID) . '#comment-' . $comment->comment_ID . '\';">' . sprintf(__(' %2$s ... On %3$s'),
get_comment_author_link(),
strip_tags($comment->comment_excerpt),
'' . get_the_title($comment->comment_post_ID) . '') . '
';
endforeach; endif; ?>