Forum Discussion

clemensw's avatar
7 years ago

How to show popular blog article (most views)?

Dear Community, are there any components available to show the most popular articles / blogs / posts based on views or clicks? We’d like to show the top 3 (most clicked) blog articles on our startp...
  • TariqHussain's avatar
    TariqHussain
    7 years ago

    clemensw- You need to add conversation.style as well.

    SELECT * FROM messages where conversation.style='blog' ORDER BY metrics.views DESC limit 3