Hoi,
This is an inquiry from my friend in academia, researching about Wikipedia.
He would like to know whether there's a way to acquire a list of templates
including external links. Here are some examples including external links.
https://ja.wikipedia.org/wiki/Template:JOI/doc
https://ja.wikipedia.org/wiki/Template:Twitter/doc
Such links are stored in externallinks.sql.gz, in an expanded form.
When you want to check increase/decrease of linked domains in chronological
order through edit history, you have to check pages-meta-history1.xml etc.
In a such case, traditional links and links by templates are mixed,
Therefore, the latter ones (links by templates) should be expanded to
traditional link forms.
Sorry if what I am saying does not make sense.
Thanks in advance,
--Takashi Ota [[U:Takot]]