MassMessage to all village pumps
No One
Actions

Authored By

	Lucas_Werkmeister_WMDE
	Mar 27 2018, 10:18 AM

Size

633 B

Referenced Files

None

Subscribers

None

MassMessage to all village pumps
View Options

	SELECT (GROUP_CONCAT(?wikitext; separator = "\n") AS ?list) WHERE {
	hint:Query hint:optimizer "None".
	?wiki wikibase:wikiGroup "wikipedia".
	?normalSitelink schema:about wd:Q16503;
	schema:isPartOf ?wiki;
	schema:name ?normalName.
	OPTIONAL {
	?technicalSitelink schema:about wd:Q4582194;
	schema:isPartOf ?wiki;
	schema:name ?technicalName.
	}
	BIND(COALESCE(?technicalName, ?normalName) AS ?page).
	BIND(SUBSTR(STR(?wiki), 9, STRLEN(STR(?wiki)) - 9) AS ?site).
	BIND(CONCAT("# {{target\|page=", ?page, "\|site=", ?site, "}}") AS ?wikitext).
	}