1 CREATE VIEW user_mention_mview AS
6 comment_aggregates_mview ca
10 um.id AS user_mention_id,
22 ac.banned_from_community,
29 coalesce(cl.score, 0) AS my_vote,
37 AND cs.comment_id = ac.id) AS saved,
41 CROSS JOIN all_comment ac
42 LEFT JOIN comment_like cl ON u.id = cl.user_id
43 AND ac.id = cl.comment_id
44 LEFT JOIN user_mention um ON um.comment_id = ac.id
48 um.id AS user_mention_id,
60 ac.banned_from_community,
72 LEFT JOIN user_mention um ON um.comment_id = ac.id;