Wikipedia talk:WikiProject Spam/LinkReports/xyz

db dump of subdomains
I just dumped the subdomains. It is too much for my buffer.

Note: 'example.org' would in my db be stored as 'org.example.' (TLD first, then domainname) for query-speed reasons. Also, I strip off 'www' and 'www3' and similar subdomain usage, so both 'example.org' and 'www.example.org' are stored as domain 'org.example.', again for speed reasons.

It may be informative to ram this through a script to invert the domains again and stuff them into LinkSummary templates.

Feel free to parse this list to make it readable. --Dirk Beetstra T C 08:25, 28 May 2020 (UTC)

full list
(this may have missed a couple, this is all languages)



(in total there should be 3435 rows). --Dirk Beetstra T C 08:25, 28 May 2020 (UTC)

en only
MariaDB [s51230__linkwatcher]> select distinct domain from linkwatcher_linklog where domain like 'xyz.%' and wikidomain='w' and lang='en';

1500 - 2000


(1774 rows in db) --Dirk Beetstra T  C 08:25, 28 May 2020 (UTC)