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]]