Page MenuHomePhabricator
Paste P6900

MassMessage to all village pumps
ActivePublic

Authored by Lucas_Werkmeister_WMDE on Mar 27 2018, 10:18 AM.
Tags
None
Referenced Files
F16211471: MassMessage to all village pumps
Mar 27 2018, 10:18 AM
Subscribers
None
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).
}