| Copybara | 854996b | 2021-09-07 19:36:02 +0000 | [diff] [blame^] | 1 | select |
| 2 | IF(v.is_spam, "spam", "ham"), |
| 3 | "", |
| 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 Comment c on c.id = v.comment_id |
| 10 | join CommentContent cc on cc.comment_id = c.id |
| 11 | join Project p on p.project_id = c.project_id |
| 12 | join Issue i on i.id=c.issue_id |
| 13 | join User u on u.user_id = c.commenter_id |
| 14 | join User r on r.user_id = v.user_id |
| 15 | where |
| 16 | v.reason='manual' and v.overruled = 0; |