SHOW:
|
|
- or go back to the newest paste.
| 1 | postgres=# SELECT COUNT(DISTINCT s.id) | |
| 2 | postgres-# FROM submissions s | |
| 3 | postgres-# JOIN comments c ON s.id = c.link_id | |
| 4 | postgres-# WHERE c.body ~* '\y(list of words from https://github.com/LDNOOBW/List-of-Dirty-Naughty-Obscene-and-Otherwise-Bad-Words/blob/master/en)\y' | |
| 5 | - | postgres-# WHERE c.body ~* '\y(list of words from https://github.com/LDNOOBW/List-of-Dirty-Naughty-Obscene-and-Otherwise-Bad-Words/blob/master/en)\y'; |
| 5 | + | postgres-$ OR s.self_text ~* '\y(same list as above)\y'; |
| 6 | count | |
| 7 | -------- | |
| 8 | 254682 | |
| 9 | (1 row) | |
| 10 | ||
| 11 | postgres=# select count(DISTINCT s.id) from submissions s; | |
| 12 | count | |
| 13 | -------- | |
| 14 | 850977 | |
| 15 | (1 row) |
