1 CREATE VIEW comment_view AS
18 c.creator_id = u.id) AS banned,
23 community_user_ban cb,
26 c.creator_id = cb.user_id
28 AND p.community_id = cb.community_id) AS banned_from_community,
35 c.creator_id = user_.id) AS creator_name,
36 coalesce(sum(cl.score), 0) AS score,
38 CASE WHEN cl.score = 1 THEN
44 CASE WHEN cl.score = - 1 THEN
51 LEFT JOIN comment_like cl ON c.id = cl.comment_id
58 coalesce(cl.score, 0) AS my_vote,
66 AND cs.comment_id = ac.id) AS saved
69 CROSS JOIN all_comment ac
70 LEFT JOIN comment_like cl ON u.id = cl.user_id
71 AND ac.id = cl.comment_id
81 CREATE VIEW reply_view AS
85 c2.creator_id AS sender_id,
86 c.creator_id AS recipient_id
89 INNER JOIN comment c2 ON c.id = c2.parent_id
91 c2.creator_id != c.creator_id
92 -- Do union where post is null
96 c.creator_id AS sender_id,
97 p.creator_id AS recipient_id
103 AND c.parent_id IS NULL
104 AND c.creator_id != p.creator_id
108 closereply.recipient_id
113 closereply.id = cv.id;