query-80d092be5b261b3a5a92c6a63135b06b

rq turtle/ttl

: The query do run in WDQS, but it is really a bad query. It fetches the same population data twice and then discards the duplicate values in a filter with a condition that always evaluates to false. Then it makes some totally superflously conditional binds. I have no idea why these complications are in query, but whatever was intended, doesn't work. There are only 39 results (municipalities of Cyprus) so the query runs in 2 seconds, but this simplified query gives the exact same results and runs three times as fast (less than one second): Data Gamer@ 16:00, 25 January 2021 (UTC) play Data GamerOk, thanks. I will just stop using wikidata list. 14:47, 25 January 2021 (UTC)) talk (Tagishsimon: In which case it's the borked Listeria problem. The query runs fine in WDQS. Magnus is not hurrying to fix the issues, so no ETA for a fix. --Data Gamer@ 14:23, 25 January 2021 (UTC) play Data Gamer: I have made a change and still the same problems. Tagishsimon@ 14:10, 25 January 2021 (UTC)) talk (Tagishsimon - but on the other, are you able to point to any data in the current Listeria report that has been amended on wikidata, such that Listeria should be updating the page? afaik Listeria will not update the pages if no changes. Running the report manualy gives an 'ok but I've not updated the page' message, which is ambiguous. --Listeria is not very well these day: On the one hand, Data Gamer@ 18:35, 25 January 2021 (UTC) play Data Gamer: Thanks. But wikidata list still have the same problems. Dipsacus fullonum@

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?area ?population ?pit
WHERE
{
  ?item wdt:P31 wd:Q16739079 .

  optional {  ?item p:P1082 [ ps:P1082 ?population; 
                              pq:P585 ?pit; 
                              wikibase:rank wikibase:PreferredRank ] 
           }
  optional {  ?item wdt:P2046 ?a . 
              BIND(REPLACE(STR(?a),"\\.",",") AS ?area) 
           }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/01