Skip to content

Instantly share code, notes, and snippets.

@fser

fser/spamers.txt

Created January 29, 2016 15:34
Show Gist options
  • Save fser/bc98e1e56f0a5cf6ad96 to your computer and use it in GitHub Desktop.
Save fser/bc98e1e56f0a5cf6ad96 to your computer and use it in GitHub Desktop.
Download ZIP
Top spam hostname on my website
Raw
spamers.txt
mysql> select count(*) as c ,hostname from comment group by hostname having c > 20;
+------+----------------+
| c | hostname |
+------+----------------+
| 169 | 107.150.40.162 |
| 354 | 107.150.40.163 |
| 2199 | 142.54.172.154 |
| 722 | 142.54.172.155 |
| 26 | 142.54.172.156 |
| 385 | 142.54.172.157 |
| 1137 | 198.204.252.82 |
| 188 | 198.204.252.84 |
| 378 | 198.204.252.85 |
| 684 | 63.141.249.10 |
| 68 | 63.141.249.12 |
| 754 | 63.141.249.13 |
| 3027 | 66.117.8.34 |
| 679 | 69.30.254.172 |
| 220 | 74.91.23.52 |
+------+----------------+
15 rows in set (0.02 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment