Return six solutions for a given category or board, for the last 30 days, ordered by number of views

Hi VarunGrazitti,

Used below code given by you :

SELECT * FROM messages WHERE category.id IN ('CATEGORY_ID') AND is_solution = true ORDER BY metrics.views DESC LIMIT 6

It gives six solutions in that category ordered by no. of views.

Suppose, I want only one solution per topic.

That meance if a post has multiple solutions,I want only a single latest solution.

I think we have to use Distinct topic.id for this.

Any idea about how to implement it.

Thank you.

Regards,

Vishwajeet