Rather than doing this for all the templates on all the wikis, this could be done centrally in ListeriaBot.

I added the warnings and some tracker categories on Wikidata, see https://www.wikidata.org/w/index.php?title=Template%3AWikidata_list&type=revision&diff=416999396&oldid=410001395

• https://www.wikidata.org/wiki/Category:Wikidata_list_with_wdq_and_sparql filled up a bit, maybe a 100, now already down to 10
• https://www.wikidata.org/wiki/Category:Wikidata_list_with_wdq had about 600 pages in it, did some conversions with a bot and it's now at 63

So it seems like reducing the old usage isn't too hard. Do you have some per wiki statistics @Magnus of wdq usage in lists per wiki? That probably helps to decide if it's worth the effort to do this centrally.

Actually, ListeriaBot automatically replaces "simple" WDQ with SPARQL upon editing. I could extend that to "all WDQ", with exceptions where the converter doesn't work. Some of the SPARQL is badly optimised, however, and will time-out, causing the list to become static (not edited anymore).

WDQ usage (wiki/pages):
wikidatawiki 559 (this one might change massively tomorrow after your updates)
dewiki 95
frwiki 76
enwiki 61
dawiki 25
itwiki 10
ndswiki 10
nlwiki 10
euwiki 9
svwiki 8
elwiki 8
cawiki 6
cywiki 4
ruwiki 4
fiwiki 4
eswiki 3
nowiki 2
commonswiki 2
ptwiki 2
etwiki 1
ltwiki 1

I also noticed that the query converter gives interesting output. Things like not using MINUS. I tend to also make the query a bit easier or better when converting. The number of pages is much lower than I expected on other wiki's. I guess that if you can just produce a list somewhere, we can just empty it out with a couple of volunteers.

It's now in the bot report (last column, linked to the per-wiki lists).

To be safe, maybe you want to add DISTINCT and LIMIT 5000 when converting

Lots queries are in userspace .. users probably don't mind if we improve them to keep working, but in general, I don't think we should attempt to edit them.

We are not aiming to change the visible result (only for the better, perhaps). And when I switch off WDQ support, they should be thankful that their lists keep working.

In T153441#2881880, @Magnus wrote:

We are not aiming to change the visible result (only for the better, perhaps). And when I switch off WDQ support, they should be thankful that their lists keep working.

Exactly! Thanks for the overview. I just counted only 14 not failed WDQ lists.

Sure, but I don't think we necessarily need to do them all without the user ;)

Anyways, I left a short summary on frwiki

something is broken in elwiki .. not sure what. Manual updates gives a message starting with:

Trying to update Χρήστης:Geraki/Θάνατοι_το_2016...
Warning: file_get_contents(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /data/project/listeria/shared.inc on line 93
Warning: file_get_contents(https://elwiki.wikipedia.org/w/api.php?format=json&action=query&meta=siteinfo&siprop=namespaces%7Cnamespacealiases): failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /data/project/listeria/shared.inc on line 93

Aeroid has quite lot in their userspace, notably in dewiki.

elwiki fixed, though the cause remains a mystery. Apparently, the language used is "elwiki", not "el".

Thanks. Somehow it seemed to work in daily bot mode, but not on user update.

@Magnus I think we done enough fixing. Let's start removing it everywhere? I removed it from Pywikibot today in T162585

What's the status here?

The only usage left.

And I can't change that usage because I get caught in some spam filter. Any es admin around?

I think we can close this. There may be some lists left that were already broken before ..

I replaced the last usage on WIkidata, updated the template and documentation on both Wikidata and Enwp. I killed the tracker category. Switch the last eswp list and close this one?

I succeeded to change it - diff, check if the new query (converted via wdq2sparql) is good enough.

In T153441#3410959, @XXN wrote:

I succeeded to change it - diff, check if the new query (converted via wdq2sparql) is good enough.

You need to change the parameter wdq= to sparql= (I can't do it, because I'm not autoconfirmed)

@Mbch331, thanks, done.