View favorites throughout system

[Gavin Funabiki]

Is there a way to view all recent comments that were favorited by others? Information about comments that were favorited by multiple people (and the number of that...)

If it's not something that's currently accessible via the interface, is there some other way of getting that information?

[Sergey Svishchev · Accepted solution]

Start with this SQL:

select c.cru_message from cru_comment c join cru_base_star_model s on c.cru_comment_id = s.cru_int_key1 where s.cru_item_type = 'atlassian-comment';