clemensw
7 years agoGuide
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 startpage. Do you have any recommendations how we can implement this?
thank you, best regards,
Clemens
clemensw- You need to add conversation.style as well.
SELECT * FROM messages where conversation.style='blog' ORDER BY metrics.views DESC limit 3