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
CCornerstone - For that, you must need to authenticate using OAuth 2.0 flow to access the API V2.
Here is the documentation for the OAuth 2.0 flow https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=oauth2
