Возможно это тебе поможет
{exp:query limit="10" sql="SELECT exp_comments.weblog_id AS www, url_title, name, comment_id, comment_date, comment AS ccc, title AS ttt
FROM exp_comments, exp_weblog_titles
WHERE exp_comments.entry_id = exp_weblog_titles.entry_id
AND exp_comments.author_id = '{segment_3}'
ORDER BY comment_id DESC"}
<a href="/news/comments/{url_title}/#comment-{comment_id}">{ttt}</a>
Автор: {name} / {comment_date format='%d.%m.%Y, %H:%i'}
{paginate}
{pagination_links}
{/paginate}