Below is the query which will return you TKB subject by views sorting.
SELECT subject FROM messages WHERE conversation.style='tkb' ORDER BY metrics.views DESC
Here is the documentation https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages#constraints-conversation.style
If you just want to get all the tkbs from Boersenlexikon board. You don't need to add conversation.style either.
SELECT subject FROM messages WHERE board.id='Boersenlexikon' ORDER BY metrics.views DESC
CCornerstone - Can you elaborate more? do you want to use this query inside lithium using Freemarker or you want to access from the third server?
of course, sorry for the unspecific question. the data must be accessed from third parties
