Kallie

Kallie 

Try this one
For specific post/topic

SELECT metrics.views from messages where id = '777'

 For specific author

SELECT metrics.views from messages where author.id= '7'

Hi Kallie

When you want to output a result from a Freemarker variable use ${...}.

An example you want would be: ${message.subject}

You may also want to add the start to your anchor tag otherwise it is malformed HTML.