| Copybara | 854996b | 2021-09-07 19:36:02 +0000 | [diff] [blame] | 1 | select |
| 2 | IF(v.is_spam, "spam", "ham"), |
| 3 | REPLACE(s.summary, '\n', '\r'), |
| 4 | REPLACE(cc.content, '\n', '\r'), |
| 5 | u.email, |
| 6 | CONCAT("https://bugs.chromium.org/p/", p.project_name, "/issues/detail?id=", i.local_id), |
| 7 | r.email |
| 8 | from SpamVerdict v |
| 9 | join Issue i on i.id = v.issue_id |
| 10 | join Comment c on c.issue_id = i.id |
| 11 | join CommentContent cc on cc.comment_id = c.id |
| 12 | join IssueSummary s on s.issue_id = i.id |
| 13 | join Project p on p.project_id = i.project_id |
| 14 | join User u on u.user_id = c.commenter_id |
| 15 | join User r on r.user_id = v.user_id |
| 16 | where |
| 17 | v.reason='manual' and v.overruled = 0; |