1 create view user_mention_mview as
6 from comment_aggregates_mview ca
11 um.id as user_mention_id,
23 ac.banned_from_community,
30 coalesce(cl.score, 0) as my_vote,
31 (select cs.id::bool from comment_saved cs where u.id = cs.user_id and cs.comment_id = ac.id) as saved,
34 cross join all_comment ac
35 left join comment_like cl on u.id = cl.user_id and ac.id = cl.comment_id
36 left join user_mention um on um.comment_id = ac.id
42 um.id as user_mention_id,
54 ac.banned_from_community,
65 left join user_mention um on um.comment_id = ac.id