Talk:Wikidata Query Service/Archive 1

More in Wikidata
See also suggestions at https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/suggestions

Duplicates and missing rows.
I am getting duplicates and missing rows. The duplicates seem to arise when the a value has been edited in the references. I do not know why the row is missing.

An example of a duplicate with the below SPARQL is "wd:Q21076992 * En røv bag øret" and the missing one is "wd:Q21083886 * Beton - historier fra skurvognen" from. I am also getting duplicate elements, e.g., "Ove Dahl, Ove Dahl (politi)". This seems also to be related to editing the value.

&mdash; Fnielsen (talk) 22:16, 15 October 2015 (UTC)
 * This issue has now been phabricated: https://phabricator.wikimedia.org/T116622 &mdash; Fnielsen (talk) 17:53, 26 October 2015 (UTC)

Scratch pad
A scratch pad beside the query box would be really convenient for quickly storing queries. The pgAdmin tool for managing Postgresql databases has had this feature for years (http://www.pgadmin.org/docs/1.6/images/query.png). The main use case is when people are experimenting with queries, they often need a temporary place (ends up being a text file) to store and compare variations of a query. This feature is an effective and "low-tech" alternative to providing multiple tabs for running queries.

Rename page and subpages
Should this page and subpages be titled 'Wikidata Query Service' ? John Vandenberg (talk) 02:37, 6 January 2016 (UTC)

Exceptions and timeouts using wikidata query service
Hi there,

there might be a problem with the current wikidata query service.

I try to write a tool, which can answer questions with given answer candidates. To accomplish this I match the children of a parsed entity from the question and match the found candidates with the given.

One way which is realy fast and effective is using queries like these:

But currently I am receiving timeouts or exceptions
 * This seems to be fine now. --Smalyshev (WMF) (talk) 18:43, 16 March 2016 (UTC)

"Execute" shortcut
Can we have a keyboard shortcut for the "Execute" button, please? --Magnus Manske (talk) 12:34, 9 March 2016 (UTC)

"Error:"
This one gives a blank error. Query via WDQ2SPARQL, converted from CLAIM[131:(TREE[1198][150][131])] AND CLAIM[31:(TREE[473972][][279])]. --Magnus Manske (talk) 18:39, 10 March 2016 (UTC)
 * I think that is the same as T127014 added as another example there. - Jan Zerebecki 14:32, 11 March 2016 (UTC)
 * Yes, there's something fishy there, I'm looking into it. Smalyshev (WMF) (talk) 18:43, 16 March 2016 (UTC)

Old short links are broken
Something seems to have happened recently that broke old short URLs, such as tinyurl.com/htb92er. You can see the query in the final URL, but it doesn't appear in the box, and can't be executed. Cheers, Bovlb (talk) 20:55, 22 March 2016 (UTC)
 * Which browser are you using? --Lydia Pintscher (WMDE) (talk) 15:58, 23 March 2016 (UTC)
 * That's an excellent question, so I did some testing. I observe this problem using Google Chrome Version 49.0.2623.87 (64-bit) on MacOS, and also using an unknown version of Google Chrome on Windows.  I do not observe it in Safari 8.0.7 or Firefox 35.0.1.  This used to work fine in Google Chrome, and I'm not aware that I've updated since it was working.  The expanded URL is  which also fails on Google Chrome.  I also observe the same behaviour using the new short link mechanism.  Looking in the JavaScript console, I see this error;

App.js:126 Uncaught TypeError: this._editor.registerCallback is not a function
 * UPDATE: As I did more testing, the problem disappeared, and old links started working in Chrome. Did you update the site?  Now the only console message I see is the relatively benign:

modernizr-2.8.3-respond-1.4.2.min.js:4 Mixed Content: The page at 'https://query.wikidata.org/#SELECT%20%3Fx%20%3FxLabel%20(MIN(%3Fdate)%20AS%…20%7D%0A%7D%20GROUP%20BY%20%3Fx%20%3FxLabel%20ORDER%20BY%20DESC(%3Fmindate)' was loaded over HTTPS, but requested an insecure font 'http://themes.googleusercontent.com/static/fonts/inconsolata/v5/BjAYBlHtW3CJxDcjzrnZCIbN6UDyHWBl620a-IRfuBk.woff'. This request has been blocked; the content must be served over HTTPS.
 * Cheers, Bovlb (talk) 16:16, 23 March 2016 (UTC)


 * It seems your browser cache had an old version of Editor.js which broke App.js

✅ (caching problem)

Query Logs
Hello,

would it be possible to get query logs of Wikidata (https://query.wikidata.org/)? I'd love to have them for my research project. Thanks a lot!

Fadirra (talk) 13:54, 31 March 2016 (UTC)

Missing ps/pq
It appears that the ps and pq prefixes are automatically added in the web interface, but not in https://query.wikidata.org/sparql?format=json&query= The automatic prefixes should be consistent. --Magnus Manske (talk) 20:28, 12 April 2016 (UTC)

WDQ2SPARQL query timeout
So I have a deceptively simple WDQ query: CLAIM[1435:(TREE[916475][][279])] AND CLAIM[131:(TREE[12526][][131])] which WDQ2SPARQL converts to SELECT ?item WHERE { ?item wdt:P1435 ?sub0. ?sub0 (wdt:P279)* wd:Q916475. ?item wdt:P131 ?sub1. ?sub1 (wdt:P131)* wd:Q12526 } Now, WDQ returns the ~1000 items in about 1 second. However, the SPARQL query (can't link to it, because tinyurl prevents me from saving the page) times out (still returns JSON though?). Is there anything you can do on the SPARQL engine or WDQ2SPARQL to improve this? I would like to retire WDQ sooner rather than later, but as long as auto-conversion essentially breaks functionality in downstream tools, I can't do it. --Magnus Manske (talk) 14:22, 13 April 2016 (UTC)
 * Unlimited path queries are usually the hardest for the engine in my experience. I'll look into what can be done to make it better, maybe use vertex-based search service instead... --Smalyshev (WMF) (talk) 22:19, 16 August 2016 (UTC)

Sardinia (Q1462) is not returned when I query for regions of Italy (Q16110)
This query should return 20 regions but instead only returns 19. Sardinia for some reason is missing. I checked and the relation Q16110 seems to be correctly declared for Sardinia.

This is my query

SELECT * WHERE {?resource wdt:P31 wd:Q16110.}

and this is the result

resource wd:Q1210 wd:Q1216 wd:Q1222 wd:Q1237 wd:Q1243 wd:Q1250 wd:Q1256 wd:Q1263 wd:Q1273 wd:Q1279 wd:Q1280 wd:Q1282 wd:Q1284 wd:Q1438 wd:Q1443 wd:Q1447 wd:Q1452 wd:Q1458 wd:Q1460

FrBailo (talk) 14:40, 13 April 2016 (UTC)
 * It's in wdq: http://wdq.wmflabs.org/api?q=claim[31:16110] --Magnus Manske (talk) 15:01, 13 April 2016 (UTC)
 * Returns 20 now so I assume it's ok. --Smalyshev (WMF) (talk) 22:21, 16 August 2016 (UTC)

Deleted items showing up in queries??
I've been trying to clean up self-instances (which are never logically justified) - the query is at tinyurl.com/jq5hduf - I cleaned up the ones I could, but the remaining 5 are all deleted items like Q21704990. Why is the query service returning deleted items in responses??? ArthurPSmith (talk) 16:03, 13 April 2016 (UTC)

deleted items show up repeatedly: SPARQL server with old cache/data
i have a problem on a couple of user subpages visible best here (notice all the ListeriaBot edits of size +321/-321). the 3 items Q1499520, Q1792416 and Q2560705 were deleted in April 2016, but -since May- are added and removed again and again.

Magnus explained to me that this is because one of the SPARQL servers has current data, but the other has outdated/old cache data (if i understood it correct, see in German).

Can somebody please fix this issue. Holger1959 (talk) 20:17, 4 August 2016 (UTC)
 * Smalyshev, maybe you can have a look? don't know if you noticed this. Holger1959 (talk) 15:48, 13 August 2016 (UTC)

Should be fine now, please ping me if it is still a problem. --Smalyshev (WMF) (talk) 22:08, 16 August 2016 (UTC)
 * thanks, seems ok now. Holger1959 (talk) 17:43, 1 November 2016 (UTC)

the problem returned, see diff from yesterday and notice that Q1590717 was deleted on 2016-04-30. Holger1959 (talk) 00:34, 3 January 2017 (UTC)
 * Looks like still old deletes not updated... Should be ok now. --Smalyshev (WMF) (talk) 01:50, 5 January 2017 (UTC)

Not properly synced?
SELECT ?item WHERE { ?item wdt:P131 wd:Q2107. ?item wdt:P1435 wd:Q15632117 } (can't link because tinyurl not allowed) should include Q16832586, but doesn't. I tried to purge the item, but no joy. WDQ finds it correctly. Any idea? --Magnus Manske (talk) 14:46, 28 April 2016 (UTC)

Updated data ?
Maybe I'm wrong but it seems that data are for now not updated. Results are different from those of WDQ. Is it an old version? Example: instances of sculpture (or subclass) with image WDQ results – SPARQL results. Is there somewhere a place to have live information about the service? Thanks --Shonagon (talk) 16:52, 28 April 2016 (UTC)
 * It is currently catching up and should be all good again soon. --Lydia Pintscher (WMDE) (talk) 09:37, 2 May 2016 (UTC)

Result on map : reverses lat/lon
Latitude and longitude are set in place of the other one.
 * Yeah there was a switch. Will be fixed tonight. --Lydia Pintscher (WMDE) (talk) 09:34, 2 May 2016 (UTC)

Translation
I cannot find the tool on Translatewiki. Is the UI not internationalized yet? Danmichaelo (talk) 06:53, 2 May 2016 (UTC)
 * It is not there yet. We've got the patch to make it happen but it still needs some manual work. --Lydia Pintscher (WMDE) (talk) 09:35, 2 May 2016 (UTC)

SPARQL endpoint is down?
I am rarely able to run any query for the past 18 hours or so. When I load the website, the status bar at the bottom eventually displays: "Data last updated: [unable to connect]". Is this possibly related to this task:? https://phabricator.wikimedia.org/T133566 —seav (talk) 04:12, 3 May 2016 (UTC)
 * Any idea what happened here? --Lydia Pintscher (WMDE) (talk) 08:41, 3 May 2016 (UTC)
 * Separate bug has been filed in Phabricator: https://phabricator.wikimedia.org/T134238 —seav (talk) 13:37, 3 May 2016 (UTC)

Way to get the precision of time values?
Is there a way to get the precision of time values using this service? —seav (talk) 01:58, 5 May 2016 (UTC)
 * See Wikibase/Indexing/RDF Dump Format. Matěj Suchánek (talk) 16:25, 3 October 2016 (UTC)

502 Bad Gateway
I constantly receive 502 bad gateway from spraql query service. I tried with 3 different browsers and it is still the same. Is the problem related with me or the server?
 * Seems like the server. I haven't been able to query it for some hours now. Danmichaelo (talk) 19:42, 7 May 2016 (UTC)
 * Found T134238. Danmichaelo (talk) 19:50, 7 May 2016 (UTC)

Completion, Plotting OSM relations in the results, instead of a single coordinate
It would be nice with completion on #defaultView:. Also, when doing the example query that returns rivers, it would be nice if there was an option in the Display drop-down that would show their associated OSM relations. Like with. On Wikipedia, clicking the inline map on that page will show the whole route. --Ysangkok (talk) 01:49, 13 May 2016 (UTC)

Blank error and search does not complete
I tried running the following query: PREFIX wdt: 

SELECT ?compound ?name ?smiles WHERE {

?compound wdt:P31 wd:Q11173 ;

rdfs:label ?name.

OPTIONAL {?item wdt:P233 ?smiles}

}

and the query runs, but after a few seconds the text ERROR: appears, but no message is displayed. The query doesn't display a time out and appears to continue running for minutes until I close the browser window. Without the OPTIONAL statement the query will return 156546 results in 8138 ms. I get the same error if I use the OPTIONAL statement looking for other properties eg P234 (inchi). Any ideas on what the error is? Is it my query or a bug? Ideally I would like to get InChIs and SMILES data where they exist for a compound. Thanks --The chemistds (talk) 10:18, 2 June 2016 (UTC)

Handling properties with variable unit types
[Disclaimer: My knowledge of SPARQL and other query languages is almost zero.]

I'm trying to see how well I can generate lists of geographical entities (mountains, lakes, rivers, etc.) sorted by a particular measured physical property: elevation, area, volume, depth, length, width, etc. Here's an example Wikidata Query that actually works (after a fashion):

Once I got to this point I discovered that a lot of the lakes showing up at the top of my list of largest lakes were actually mid-sized lakes in Sweden. After some digging I discovered that some lake volume figures are given in cubic meters and others in cubic kilometers. Clearly these can be converted, so long as I can identify which unit of measurement is being used for each and adjust it as needed. How would I do that? (I tried a lot of times and failed.) This seems to be a pretty broadly applicable requirement as there are lots of properties here that accept values with various types of units.

Also, some items show up more than once. For example, the shows up twice because it is an instance of both an  and a, both of which are subclasses of lake. Is there a way I can rewrite the query so that I don't get duplicate items? Rupert Clayton (talk) 22:59, 7 June 2016 (UTC)

Queries are down at this time: (6th of July 2016 : 7:16 UTC).

Is the number of arguments in a query limited?
Hi, I just wonder whether there is some limitation as to the length of a query. Here is the query: tinyurl.com/zdn4lfl

When I add more fields, the server returns "ERROR: Could not contact server" Is this a feature or a bug? Is it documented somewhere? -- Beat Estermann (talk) 22:13, 16 July 2016 (UTC)

Why don't URIs work in queries?
This works: This doesn't:


 * You need to use different URL for property, wdt: prefix is http://www.wikidata.org/prop/direct/ so full URL is http://www.wikidata.org/prop/direct/P828. See: https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Full_list_of_prefixes --Smalyshev (WMF) (talk) 22:11, 16 August 2016 (UTC)

Add WDQ to SPARQL conversion?
Many of Magnus's tools (eg PetScan) now have a wonderful WDQ2SPARQL feature which can take a standard WDQ query (eg claim[31:5]) and convert it into the correct SPARQL form. Given how relatively easy WDQ is to remember for simple queries, and that this conversion tool works so neatly on PetScan, could it be added as a feature on the Wikidata query service as well? Andrew Gray (talk) 19:44, 2 August 2016 (UTC)
 * You can use http://tools.wmflabs.org/wdq2sparql/ Smalyshev (WMF) (talk) 05:34, 6 August 2018 (UTC)

Add support for bds: to SPARQL endpoint?
Blazegraph supports full text search which can be executed in SPARQL with bsd: predicates. Would it be possible to add support for bsd:?

For example:

This currently results to the following error message:


 * Well, this is because free text index has not been enabled :) We are working on integrating WDQS with our own full-text index solution that is indexing wikidata, see T141813. --Smalyshev (WMF) (talk) 22:13, 16 August 2016 (UTC)

Suggestion: Query formatting function
Hi, Just have to say I love the SPARQL interface. Slick and with very useful functionality!

The only little thing I wish sometimes, is ability to automatically format the query, with nesting, spacing etc.

This is useful sometimes when pasting queries copied from oneliners (such as when they have been embedded in URLs) etc.

Links in query results should be https, not http
The Wikidata query service delivers http links (without TLS encryption) in the query results. Could you please switch to https, or at least use protocol-relative links? Example: go to the query service, select the very first example (“Cats”), and look at the links in the “item” column. Thanks! —MisterSynergy (talk) 10:48, 2 September 2016 (UTC)
 * These are entity identifiers, not links. They need to be fixed and unique for an item, and traditionally most linked data ontologies use http in their URI schemes, almost nobody uses https. This does not mean if you want to use this URI to access the data you have to use http. BTW, what is the problem with identifiers using http URIs? --Smalyshev (WMF) (talk) 19:31, 7 September 2016 (UTC)


 * Thanks for response. The entity identifiers are used as links here, but not fully displayed as such in the GUI (they are listed as "wd:Qxxxx"). I am often using public unencrypted wireless networks and try to hide as much traffic as possible with https, and I am also not sure whether anything sensible such as cookies are sent unencrypted if I click on unencrypted links. It would suffice if I could activate https links as an option in the WDQS GUI, in those situations where I am not primarily interested in entity identifiers. --MisterSynergy (talk) 19:42, 7 September 2016 (UTC)

RGB
Do RGB color values only work when they are upper case? Example: --Tobias1984 (talk) 13:09, 3 September 2016 (UTC)

Getting started
I'm unable to find documentation on Wikidata query service that is complete enough to actually write queries. Everything I've found is hit or miss.

As an example, I started out with a query, which is found at Wikidata Property talk:P569 (search for "Wrong calendar and click on "Violations query")

My intent was to add a new requirement, in addition to the date-related requirement, that the item have the property "Country of citizenship" and the value of that property be "Kingdom of Great Britain". So I modified the query by adding this line:

?item p:P27 wd:Q161885.

on a separate line just above the right curly brace.

This query didn't return any results. I couldn't find any documentation that one could read from the point of view of "this is what I want to do, how do I do it?" Any suggestions? Jc3s5h (talk) 23:35, 30 September 2016 (UTC)


 * Jens on my team is currently working on better documentation. Hope to have something to show in a week. --Lydia Pintscher (WMDE) (talk) 11:07, 2 October 2016 (UTC)


 * i'm very interested in such a beginners' guide too. is there a "better documentation" somewhere now? Holger1959 (talk) 00:42, 1 December 2016 (UTC)


 * Check out d:Wikidata:SPARQL query service/Wikidata Query Help. --Lydia Pintscher (WMDE) (talk) 10:20, 1 December 2016 (UTC)

Missing data in query
I'm trying to query cities. Algiers (Q3561) is an instance of capital (Q5119) and city (Q515). But when I make the following query, information about city is lost and result consists only of one entity.

SELECT * {wd:Q3561 wdt:P31 ?class}

https://query.wikidata.org/#SELECT%20%2a%20%7Bwd%3AQ3561%20wdt%3AP31%20%3Fclass%7D

I get the following result: wd:Q5119, but I expect it to be wd:Q515 and wd:Q5119

Is it a bug, or am I doing something wrong? --176.14.69.93 19:38, 1 October 2016 (UTC)


 * See for instance T125558. Matěj Suchánek (talk) 16:21, 3 October 2016 (UTC)

Label service button
Could we have a button that adds the "label service" magic incantation? Maybe before the last "}", or just append otherwise? We can move it around as needed, just copying that thing all the time gets annoying... --Magnus Manske (talk) 13:19, 13 October 2016 (UTC)

New visitors do not see the "Run" button because my query is very long.
When I send lay people to my shiny query, all they see is a wall of text, and nothing to click on. That's because my query has many lines, even though I have compacted the code a lot.

SOLUTION: Make the query area scrollable if the query is more than 20 lines.

What do you think about it? Thanks! Syced (talk) 13:23, 14 October 2016 (UTC)

Knowledge Graph
Hello, please add information on blogger Alexei Pechkurove https://www.wikidata.org/wiki/Q27303908 in the Knowledge Graph
 * This item was deleted as spam. Syced (talk) 08:09, 18 October 2016 (UTC)

number align
it would be useful right align numeric columns or count columns--Edoardo88 (talk) 11:45, 1 November 2016 (UTC)

SPARQL servers use different item order system?
Smalyshev, maybe you can have a look into the following issue:

we have a problem on dewiki with a couple of pages visible best in this example (notice all the ListeriaBot edits of size +/- 0) or here for 2016-10-31/11-01. Some specific items are reordered/rearranged again and again, otherwise nothing is changed. it looks as if the reason is only a slightly different order (alphabetical, per ID, or similar, don't know).

As far i know, ListeriaBot uses SPARQL servers, which may have a bit different cache data (see above). Can you identify a pattern and fix this behaviour please? Holger1959 (talk) 17:43, 1 November 2016 (UTC)
 * In general, items order is not guaranteed unless you explicitly sort them. So it could be the bot gets different order in different queries. I guess it should either ask for some kind of sorting or check that the set of entries did not change despite different order and not change, not sure. --Smalyshev (WMF) (talk) 20:26, 1 November 2016 (UTC)
 * Smalyshev, thank you for the reply. the sorting in our lists is usually done by property, and within a property section by alphabet. is there something special Magnus could add to his bot or to the Wikidata list template? (i don't understand the technics myself) Holger1959 (talk) 21:53, 1 November 2016 (UTC)
 * I am using the PHP Collator class to get proper sorting in the respective language. Not sure why that would "flip" the sort order. Investigating, but if you have any ideas, let me know. Relevant code, and here as well. --Magnus Manske (talk) 11:13, 2 November 2016 (UTC)
 * Update: Have fiddled with the code, I hope it's sorting more stable now, without breaking anything. Let me know please. --Magnus Manske (talk) 10:32, 3 November 2016 (UTC)

Image grid and timeline view not working anymore since display types update?
Before the addition of the (very awesome!) new types of displays, I could select an image grid and a timeline view for a query like this one. Now not anymore - those view options are greyed out ('bubble chart' as well). Is this intentional? Spinster (talk) 18:39, 1 November 2016 (UTC)
 * Yes, sorry, known bug, will be fixed soon. --Smalyshev (WMF) (talk) 20:26, 1 November 2016 (UTC)

Textual representation fails when using VALUES
In my (well initially prepared with help of I don't remember who on #wikidata) query tinyurl.com/jhhq89r (btw, why don't we have a url shortening service specifically for SPAQRL which would allow not to have it blacklisted?) after I used VALUES the textual representation is sure that I am looking for anything. That is rather unfortunate since it is handy in picking needed item without need to look it's entity id up directly on Wikidata, while I used VALUES to define a variable exactly for merging value used in 2 places into one being. --Base (talk) 00:07, 7 November 2016 (UTC)
 * Well it looks I still can use its window to actually look up entities but well still the original thing is a bug. --Base (talk) 00:18, 7 November 2016 (UTC)

Simple query does not work (dewiki project)
this question is related to a comprehensive Wikidata project on dewiki.
 * background: i use Magnus' ListeriaBot for many pages on dewiki, all related to geographical objects in Germany. The goal and usage is broad: better sorting items by federal state>district>municipality, finding wrong classifications, adding missing descriptions/images/Commonscat/etc (example page for one district). this is extremely helpful and my (together with Aeroid's) subpages cover already 11 of 16 federal states of Germany by district/independent city using queries like "all items [P131] located in the administrative territorial entity, including [P150] subdivisions, and sorted by [P31] instance of". Additionally, queries for certain topics are used on associated subpages, eg. "all rivers/mountains/cultural heritage monuments/windmills/etc located in [administrative unit]". This worked fine for months.
 * problem: about 2 weeks ago, queries stopped working for some topics, eg. "all protected areas in a certain administrative unit". ListeriaBot with WDQ displays an error, with SPARQL it displays "no items" and when using query.wikidata.org i see only "Query timeout limit reached".
 * example:
 * see subpage DE-RP (German state of Rhineland-Palatinate)
 * old WDQ definition for ListeriaBot  worked fine for months, stopped working (errors)
 * new SPARQL definition works on DE-SL (German state of Saarland), cf. and following bot edits
 * new SPARQL definition does not work for DE-RP (only difference is the federal state item Q1200 instead of Q1201) and for other related/similar queries:
 * question: what can i do, or how can this issue be fixed? Holger1959 (talk) 16:22, 1 December 2016 (UTC)
 * question: what can i do, or how can this issue be fixed? Holger1959 (talk) 16:22, 1 December 2016 (UTC)

Smalyshev (WMF), could you have a look into this, or tell an other staff member with SPARQL experience to help, please? the users who work on these topics are really lost without Listeria worklist updates and/or without functioning query.wikidata.org. Maybe you know an alternative query to achieve the same result, as it was possible with the WDQ definition given above? (please note that my own understanding of SPARQL, unfortunately, is limited, and none of the other users i asked was able to find a solution.) Holger1959 (talk) 02:03, 8 December 2016 (UTC)
 * The query doesn't seem right but I'm not sure wherer it's me not understanding what it's supposed to do or conversion bug. I think "protected items in specific territory" should be give by this:

but please verify if it's indeed the case and if not, please point me to what's missing. --Smalyshev (WMF) (talk) 21:41, 9 December 2016 (UTC)


 * many thanks for your help! the new query at least works (no timeouts), but the results are incomplete (only ca. 1/5 of items formerly found). i am currently trying to get help by an other german-speaking user who seems to understand SPARQL. will report back here if we find a functioning query scheme.
 * Either way, i still think the results i want to achieve (all objects of type A located in a defined area B, like eg. "all towers somewhere in England"), should only require a simple query. This type of request (or its structure) is rather trivial and very common, isn't it? so i really don't understand why it is so complicated. (in despair) Holger1959 (talk) 06:52, 16 December 2016 (UTC)
 * now MisterSynergy found the solution! it works also for larger federal states with many items, complete results (as before) and without timeouts.
 * i hope this example helps also other users with similar query problems. Holger1959 (talk) 18:34, 16 December 2016 (UTC)
 * The last query does not have P150 check though. Is it not required? --Smalyshev (WMF) (talk) 01:59, 20 December 2016 (UTC)
 * it gives all relevant results without P150 obviously :) and if needed, we can now use a separate query for P150, which works the same. this solved also a couple of similar problematic queries ("Cities in Saxony"). maybe someone can add this hint to T116298? Holger1959 (talk) 00:45, 3 January 2017 (UTC)
 * it gives all relevant results without P150 obviously :) and if needed, we can now use a separate query for P150, which works the same. this solved also a couple of similar problematic queries ("Cities in Saxony"). maybe someone can add this hint to T116298? Holger1959 (talk) 00:45, 3 January 2017 (UTC)

WDQ
What is the reason of abolishing such short and convenient syntax? Earlier I used auto-generated WDQ queries like: http://wdq.wmflabs.org/api?q=claim[2936]&noitems=1. And how should I get the number of items with some claim? Compare: "noclaim[31]" and "SELECT ?item WHERE { OPTIONAL { ?item wdt:P31 ?dummy0 }  FILTER(!bound(?dummy0))}". What is easier to remember? May be to make at least reverse compatibility? --Infovarius (talk) 12:36, 7 December 2016 (UTC)
 * The reason is WDQ and Query Service are two completely different tools, which use completely different codebases and completely different platforms. It's not really feasible to implement WDQ syntax on top of SPARQL graph engine, it's be quite a lot of work for which we just don't have resource. You can however use the translator here: http://tools.wmflabs.org/wdq2sparql/w2s.php to translate from WDQ syntax to SPARQL. --Smalyshev (WMF) (talk) 04:46, 13 December 2016 (UTC)
 * in SPARQL that is better said:

select * {?item a wikibase:Item. filter not exists {?item wdt:P31 []}} --Vladimir Alexiev (talk) 19:28, 13 March 2017 (UTC)
 * Thanks. But I will not remember this, and the translator above (and in PetScan, e.g.) gives me my version... --Infovarius (talk) 16:05, 17 March 2017 (UTC)
 * https://github.com/smalyshev/wdq2sparql/issues/12 --Vladimir Alexiev (talk)
 * Another problem with absence of WDQ. I used to get a list of all films (>250 thousands) by WDQ-quering "claim[31:(TREE[11424][][279])]". Now it seems that I have no any alternative... --Infovarius (talk) 16:06, 17 March 2017 (UTC)
 * This is translated to

Which has equivalent but simpler form

Just tested, both of them run fast and return 244k results --Vladimir Alexiev (talk) 15:02, 23 March 2017 (UTC)

Display URLs with an icon
Excellent tool but if you have hyperlinks in a list/map... then they take to much space. I would like to see a possibility t just show a [https://query.wikidata.org/embed.html#%23%20Query%20Find%20in%20WikiData%20people%20with%20Place%20of%20Burial%20Q252312%20Norra%20Begravningsplatsen%0A%23%20Show%20Wikitree%20ID%2C%20Find%20A%20Grave%20ID%20and%20if%20picture%20of%20the%20grave%20exist%0A%23%20version%202%20Google%20map%20link%0A%23defaultView%3AImageGrid%0Aselect%20distinct%20%20%3Farticle%20%3Fperson%20%3FpersonLabel%20%20%3FpersonDescription%20%20%3Fgraveplot%20%20%20%3Fcoord%20%3FpicGrave%20%3FWikiTree%20%3FFindAGrave%0A%28IRI%28CONCAT%28%22https%3A%2F%2Fwww.google.com%2Fmaps%2F%3Fq%3D%22%2C%20STR%28%3Flat%29%2C%20%22%2C%22%2C%20STR%28%3Flon%29%29%29%20AS%20%3FGoogleMap%29%20%3FSBL%20%7B%0A%7B%0A%09%3Fperson%20wdt%3AP119%20wd%3AQ252312%3B%20%23Place%20of%20burial%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP119%20%5B%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP965%20%3Fgraveplot%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pq%3AP625%20%3Fcoord%3B%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20pqv%3AP625%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AgeoLatitude%20%3Flat%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3AgeoLongitude%20%3Flon%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%5D.%20%20%20%20%20%20%20%20%0A%20%20%20%7B%20%3Fperson%20wdt%3AP3217%20%3FSBLID%20.%7D%20%09%09%09%09%09%09%23%20SBL%0A%20%20%20OPTIONAL%7B%20%3Fperson%20wdt%3AP18%20%3Fpic%20.%7D%20%09%09%09%09%09%23%20If%20we%20have%20an%20illustration%0A%20%20%20OPTIONAL%7B%20%3Fperson%20wdt%3AP1442%20%3FpicGrave%20.%7D%20%09%09%09%23%20If%20we%20have%20a%20picture%20of%20the%20grave%0A%20%20%20BIND%20%28URI%28CONCAT%28%22https%3A%2F%2Fsok.riksarkivet.se%2Fsbl%2FPresentation.aspx%3Fid%3D%22%2C%3FSBLID%29%29%20AS%20%3FSBL%29%0A%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Farticle%20schema%3Aabout%20%3Fperson%20.%0A%20%20%20%20%20%20%3Farticle%20schema%3AinLanguage%20%22sv%22%20.%0A%20%20%20%20%20%20%3Farticle%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fsv.wikipedia.org%2F%3E%20.%0A%20%20%20%20%7D%0A%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Farticle%20schema%3Aabout%20%3Fperson%20.%0A%20%20%20%20%20%20%3Farticle%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20%20%20%3Farticle%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fsv.wikipedia.org%2F%3E%20.%0A%20%20%20%20%7D%0A%0A%20%20%20OPTIONAL%20%7B%20%3Fperson%20wdt%3AP106%20%3Fgroup%20.%7D%20%09%09%09%23%20Occupation%20in%20Layer%0A%0A%7D%20%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%22%2C%22en%22%7D%0A%20%7D%0AOrder%20by%20%3FpersonLabel Example query] displaying gravestones with external links..... - Salgo60 (talk) 13:46, 30 December 2016 (UTC)
 * Wiki icon that is clickable
 * Google map icon that is clickable
 * SBL icon that is clickable
 * Spotify icon

Answers questions
Yes I am have been working with P2949 and now working with P3217 Adding value with references using P3217 that is a source from the Swedish National Archives Its more than excellent but some reports would benefit from not displaying the URL instead an icon
 * ''Do you consider yourself part of the Wikimedia movement?
 * ''What are you using the service for? (e.g. building an interactive timeline of British prime ministers)
 * ''Were you able to get what you needed from the service?

Query parameter for simple json
What is the API parameter for simple JSON. "format=json" gives a standard long format with "results", "bindings", etc. &mdash; Fnielsen (talk) 15:12, 8 February 2017 (UTC)

Optimize regex filter
A regex filter now times out when searching on

I tried a modification, but that also timed out:

This is a not entirely satisfactory workaround:

Is there any other way to change the query? &mdash; Fnielsen (talk) 15:22, 8 February 2017 (UTC)


 * adding  .  gets you a few additional ones. --Esc3300 (talk) 09:54, 26 March 2017 (UTC)


 * Do you think that the hint works? I was under the impression that it does not do much when there is only one triple pattern. If I now execute the first statement I listed, I do not get a time out. I suspect that the time out has been set up or that the engine has been improved. &mdash; Fnielsen (talk) 19:55, 27 March 2017 (UTC)

Why schema:name and skos:prefLabel are missing?
Trying to get names of concentration camps. This returns a bunch of names for Auschwitz: curl -L -Haccept:text/turtle https://www.wikidata.org/entity/Q7341 (more schema:name=skos:prefLabel, fewer skos:altLabel

But this returns only altLabels. No matter whether I use schema:name or skos:prefLabel, it returns none of those: select * { ?x wdt:P31 wd:Q328468; wdt:P625 ?coords. {?x schema:name ?pref} union {?x skos:altLabel ?alt} } --Vladimir Alexiev (talk) 19:25, 13 March 2017 (UTC)

From Wikidata_query_service/User_Manual I grokked that I should use rdfs:label instead of schema:name/skos:prefLabel. What threw me off is that skos:prefLabel and skos:altLabel are both subprops of rdfs:label, so nominally speaking rdfs:label should return both. Oh well, I'll use what is present. --Vladimir Alexiev (talk) 19:49, 13 March 2017 (UTC)

Wikidata Query Short URLs are blocked
When you run a query on Wikidata at https://query.wikidata.org there is a links button with a "Short URL to Result" generator option. But as it produces a tinyurl.com link, you then block it from being saved. Can tinyurl.com be whitelisted for use on User pages? I don't want to have to expand the URL to the full code, or save the tinyurl as plaintext, not a link, to be able to save it. Or can Wikipedia/Wikidata/Wikimedia ensure that all of its INTERNAL tools are able to be used effectively across all sites and not use external services that you block. The-Pope (talk) 15:23, 8 May 2017 (UTC)

Sometimes, broken JSON (latin1 encoding) is emitted when using "Download JSON file"
Steps to reproduce:

SELECT ?label WHERE { wd:Q648745 rdfs:label ?label. }
 * Go to https://query.wikidata.org/
 * Enter the following query:


 * Click run
 * Click the "Download" → "Download JSON file" button
 * Inspect the downloaded file. It is encoded using latin1 and fails to load in any spec-conforming json implementation

I managed to reproduce this using current Chrome and Firefox on Linux.

Ctrl space not working
I tried to control space (in Chrome), and it wasn't working. Is there a breaking bug? Sadads (talk) 23:16, 31 May 2017 (UTC)

Adding simple sameas reasoning
Dear Dev Team, Proposal for language extension for SPARQL.

Here is an example ontology with owl:sameAs statements to rename predicates: https://raw.githubusercontent.com/h4ck3rm1k3/wikidata_varnish/master/enmap.ttl

I would like to add a sparql preprocessor that would take a query like this :

PREFIX wdt:  PREFIX bd:  PREFIX wikibase:  PREFIX wd:  prefix owl:  prefix enmap:  prefix varnish:  prefix objects:  prefix void: 

SELECT ?countryLabel WHERE { OPTIONAL {varnish:done varnish:import enmap:ontology} OPTIONAL {objects:country owl:sameas wd:Q146} ?country enmap:sameas objects:country. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY ?countryLabel

the query would be rewritten to :

PREFIX wdt:  PREFIX bd:  PREFIX wikibase: <http://wikiba.se/ontology#> PREFIX wd: <http://www.wikidata.org/entity/> SELECT ?countryLabel WHERE { ?country wdt:P31 wd:Q6256. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY ?countryLabel

Here is a proof of concept javascript to implement this : https://github.com/h4ck3rm1k3/wikidata-sparql-varnish-brush

The example ontologies are here: https://github.com/h4ck3rm1k3/wikidata_varnish

wdt: should have normalized values
2016 Quantities


 * 1) ^ - because we use them in sorting; labels "sq km" "acre" should be inside
 * 2) we should have an option to use Labeling service to describe values using "hidden labels" back D1gggg (talk) 06:37, 4 July 2017 (UTC)

Probably same remark about values in  D1gggg (talk) 06:42, 4 July 2017 (UTC)

Reindent
When working on a complex query with copy-and-paste moving parts around and adding thinks I often get terrible wrong indented source code. I also copy it to vim/some other editor to use the automaticall re-indentation feature every modern editor has. Are there any plans adding this to the online-editor? -- MichaelSchoenitzer (talk) 15:20, 14 July 2017 (UTC)

Query web interface and REST endpoint yielding different results
Hello, I'm running a simple query, trying to get all nodes with ancestor 'software':

SELECT DISTINCT ?entity {?entity wdt:P31+/wdt:P279+ wd:Q7397.}

Using the web interface, I get "63673 Results in 5111 ms." The json object that results from this query: https://query.wikidata.org/bigdata/namespace/wdq/sparql?format=json&query=SELECT%20DISTINCT%20?entity%20{?entity%20wdt:P31+/wdt:P279+%20wd:Q7397.} gives only 1941. Why is that? Am I missing a point? Cheers, −PetaRZ (talk) 15:42, 19 July 2017 (UTC)
 * Sorry for bothering, I have struggled a lot of time, and just when I posted the question, I've realized that I have "+" signs in my url, which I should have quoted! Really sorry. −PetaRZ (talk) 15:48, 19 July 2017 (UTC)

GeoJson download option
I'm often creating lists of items with Geographical coordinates (P625). What I would like is the option to Download results in GeoJSON. This would make it much easier to load the downloaded files into programs like JOSM.

Caching of rand queries
Suggestion: Do not cache queries that contain s/\brand\s*\(\)/i The results are expected to be different each time, that's the whole point of using rand. Getting the same "random" result set during the caching period is not nice. --Magnus Manske (talk) 10:52, 21 August 2017 (UTC)

Extremely simple query times out
The following query, which simply attempts to count all humans, regularly times out. Unexpectedly though, if I add some filters the query magically works. It looks like the system has problems when the dataset reaches a certain size, but shouldn't "count" just count instances, not save them? Any way to optimize this query to make it work without repeating it several times with binary filtering?


 * You have  in your query but make no actual use of it. Delete it and you should get ~3.5M results. Matěj Suchánek (talk) 14:22, 27 August 2017 (UTC)
 * Thank you! Redgolpe (talk) 16:55, 27 August 2017 (UTC)
 * Note also while the query is simple, the set of results is huge. You are going through 3.5M items (with SERVICE clause). This may be slow. Smalyshev (WMF) (talk) 17:44, 18 September 2017 (UTC)

Firefox, query.wikidata.org and long url under HTTP/2
Mozilla has an open issue about query.wikidata.org and long url See https://bugzilla.mozilla.org/show_bug.cgi?id=1402269

This seems to be a server-side issue. As soon as Firefox send the request (and the SETTINGS frames are exchanged and ack'd):

2017-09-26 21:02:54.814765 UTC - [Socket Thread]: I/nsHttp Http2Session::RecvGoAway 0x10a798000 GOAWAY Last-Good-ID 0xF status 0xB live streams=1

It could be due to nginx or varnish being used in front of query.

Query "Cities in Japan" does not include major cities like Tokyo, Kyoto, Hiroshima..
Hello,

I want to showcase some data visualizations on my website and use a dataset from wikidata, showing the number of cities with more than a million inhabitants from countries worldwide. I used the follogwing query:

The number of results was suspiciously small and I noticed that some important cities like Tokyo are missing (although Tokyo, for example, has both the P17 and P1082 properties).

When I just look for cities in Japan, with this query:

again, cities like Tokyo, Osaka, Kyoto or Hiroshima are missing.

Even with this most basic query: {{SPARQL|query= SELECT DISTINCT ?city ?cityLabel WHERE { ?city wdt:P31 wd:Q515. ?city wdt:P17 wd:Q17. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }} If such important cities are left out, my first query is quite pointless.

I couldn´t find out why these cities are missing and what I have to change in my query in order to let them appear and would very much appreciate some clarification or further information.

Thanks a lot in advance!


 * Tokyo is not declared a city and this will probably be the case with the other cities. You can try modifying the predicate to . Matěj Suchánek (talk) 16:14, 7 October 2017 (UTC)
 * Thank you, Matěj Suchánek! That works well. --Dkasai (talk) 18:25, 9 October 2017 (UTC)

How to add another endpoint for the WQS federation
Hi all, and I would like to know how to add another potential endpoint, the  in the Wikidata query service endpoint federation. Is there anyone who can answer us? Thank you very much. --Sannita (talk) 14:59, 7 October 2017 (UTC)
 * See d:Wikidata:SPARQL federation input. Matěj Suchánek (talk) 16:15, 7 October 2017 (UTC)

Can it have its own URL shortener?
The "Link > short URL" option generates a tinyurl short-link, which is blacklisted by most WMF sites, even on talk pages. Can the Wikidata query service have its own URL shortener so that the short URL can be shared in discussions? Deryck C.Meta 23:26, 8 October 2017 (UTC)
 * See T112715. Matěj Suchánek (talk) 18:30, 11 October 2017 (UTC)

Brings my browser down but doesn't give any results
I tried to follow some youtube videos on how to use sparql. With the following (i thought very easy) example, the query runs for hours until firefox or chrome crashes: SELECT ?person ?personLabel ?birthPlace WHERE { ?person wdt:P69 wd:Q447354. ?preson wdt:P21 wd:Q6581072. ?person wdt:P19 ?birthPlace. Service wikibase:label { bd:serviceParam wikibase:language "de". } } Also on every change the window bounces forth and back.

kinda crap. Ogmios (talk) 14:41, 3 December 2017 (UTC)
 * You've got a typo there:  →  . Matěj Suchánek (talk) 09:49, 30 December 2017 (UTC)

minor typo in Dutch query helper
Hi all,

There is a very minor typo in the Dutch version of the Query helper for the query service. It reads 'fliteren', which is a -however cute- non-existent word in Dutch language, instead of 'filteren', which is the Dutch word for to filter. Not a big priority off course, but just to let you know. Keep up the good work! Mtmlan84 (talk) 08:16, 12 December 2017 (UTC)
 * ^ Would you verify and fix at Wdqs-ve-filter/nl? Matěj Suchánek (talk) 09:51, 30 December 2017 (UTC)

Export results to clipboard
I normally do some post-processing of query results in spreadsheet. Is it possible to "export" to clipboard (via  all results in tab-delimited format? --Ghuron (talk) 12:25, 28 December 2017 (UTC)


 * If you select the table contents with the mouse and copy them, both Firefox and Chromium seem to separate them with tabs by default when pasting in a plain-text context. In Firefox, you can also hold Ctrl to select full table cells, rows or columns. (Note: you might run into T185838 for a few more days, but the fix should be deployed soon – in the meantime, you can work around it by selecting Copy from the context menu instead of using Ctrl + C  .) --Lucas Werkmeister (WMDE) (talk) 09:59, 5 February 2018 (UTC)
 * it works, but limited to 1000 rows (max number of items displayed per page) --Ghuron (talk) 20:04, 5 February 2018 (UTC)
 * Wouldn’t it be better to just download the query results in that case? We have <abbr title="tab-separated values">TSV download formats already, so you should be able to use those in your spreadsheet software. --Lucas Werkmeister (WMDE) (talk) 14:56, 6 February 2018 (UTC)
 * yes, that's how I do it today. But that's impose a few additional steps (especially when working with google sheet) --Ghuron (talk) 06:17, 7 February 2018 (UTC)

Timeout with instances of Q1344963
Am I doing something wrong with P6583? Is it unreasonable to search "participants of" ~6800 instances of Q1344963? --Nemo 19:21, 14 January 2018 (UTC)

Tag cloud?
How about a tag cloud view? --Shisma (talk) 09:25, 27 January 2018 (UTC)

Tiny URLs not secure
The query service's short URLs, using TinyURL, are http by default. Can we make the default https? Andy Mabbett ( Pigsonthewing ); Talk to Andy; Andy's edits 18:43, 29 January 2018 (UTC)
 * Thanks for mentioning it. We are aware that tinyURL is not the best option, for other reasons than security. A project to create a URL shortener for the Wikimedia projects is onwards. Lea Lacroix (WMDE) (talk) 09:01, 5 February 2018 (UTC)
 * We still(!) don't have a dedicated URL shortener; and our TinyURLs are still insecure. Andy Mabbett ( Pigsonthewing ); Talk to Andy; Andy's edits 15:59, 28 November 2018 (UTC)

Download result in RDF-native format (when using CONSTRUCT or DESCRIBE)
Hi, I have created some query to extract a little subgraph of Wikidata using CONSTRUCT, but I can't see any option to get the result in RDF-native format like RDF/XML, Turtle, JSON-LD or so. I have also tried to use WDQS remotely as an API, in JavaScript's AJAX I have set headers to, it has not fired any error, but returned only the prefix definitions in Turtle syntax. So is there some way to get the RDF graph, not its tabular representation (as can be seen in the WDQS GUI)? Thanks --YjM (talk) 23:51, 1 February 2018 (UTC)


 * For a simple test query,  (default format: RDF XML) and   (Turtle) both seem to work for me. Or am I missing something? --Lucas Werkmeister (WMDE) (talk) 09:47, 5 February 2018 (UTC)
 * It gave me some hard time to make curl running on Windows, but in the end.. at least something works, thanks! Strange, that when I tried to use the API  in AJAX, it didn't worked the same (as stated above). But what I mentioned in the first place: in the GUI at , under the Download menu (after the execution of the query), there is no suitable option (only JSON/CSV/TSV or image). I think, that some people would appreciate some option like Turtle or RDF/XML there. --YjM (talk) 21:36, 5 February 2018 (UTC)
 * Well, this additional download option would only be available for two of four possible query forms, and I think  is by far the most common query form on the query service, so I’m not sure if it’s worth the extra development effort to be honest… do you know if there are many people who integrate the query service with other RDF technologies? I feel like most people use the query service to get results for their queries in some format and then use them in their own fashion, without caring too much about RDF. --Lucas Werkmeister (WMDE) (talk) 15:02, 6 February 2018 (UTC)
 * Sorry for the very late answer, I have forgotten to reply.. Anyway, I have no idea if there are some other people who might be interested in such new feature. Not many I guess, as I am the first one who has complaint about it :-) --YjM (talk) 21:22, 26 April 2018 (UTC)

Adding a Shortcut to the "Examples" menu
For writing documentation, and sharing the query service with other people, it's occasionally useful to want to link to the "Examples" menu, instead of having to write instructions to find it. Would it be possible to add a unique url for that menu? Sadads (talk) 17:56, 5 February 2018 (UTC)

Adding Auto Execute option parameter in link URL
In the following table, top and bottom lines are already implemented features. What I’d like you to consider is the middle line feature. When linking to SPARQL query from outside of Wikdiata, "Auto Execute" feature would be very helpful from outreach perspective. --Was a bee (talk) 07:52, 24 February 2018 (UTC)

Labels of properties not available in the query service
The labels of properties are not available in the query service.

e.g. The following query fail in retrieving the property labels : "Give me the most common properties and their labels used on instances of Museums or a subclass of Museum" :

SELECT ?p ?count ?pLabel WHERE { {  SELECT ?p (COUNT(?o) AS ?count) WHERE { # instances de sous-classes de Musées ?item (wdt:P31/wdt:P279*) wd:Q33506. ?item ?p ?o. }   GROUP BY ?p } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }     } ORDER BY DESC(?count)

this also shows that no triples are available on a property :

SELECT ?p ?o WHERE { <http://www.wikidata.org/prop/P17> ?p ?o. }

(returns only one triple that says rdf:type owl:ObjectProperty).

Having property labels is a must to start "discovering" the data model. Can they be loaded in the query service ? is there another way to fetch them ? Thanks
 * Properties (as entities in Wikibase) and property predicates are different things. As such, you can not retrieve label from a predicate. You can use this query:
 * in order to find the labels. Label service could probably do some data transformation for property URIs, it should be possible, but currently this capability does not exist. If you think it'd be useful please add Phabricator task for it. Smalyshev (WMF) (talk) 00:38, 1 March 2018 (UTC)
 * in order to find the labels. Label service could probably do some data transformation for property URIs, it should be possible, but currently this capability does not exist. If you think it'd be useful please add Phabricator task for it. Smalyshev (WMF) (talk) 00:38, 1 March 2018 (UTC)

How to pick only certain entities in WDQS
Hi there,

I have a SPARQL query:

...which works just fine, but there are both Items and Properties in the results. I am not interested in Ps and would like to only pick the Items in the result. Something like:

But it does not work (tried several variants of it, non of it worked. Also googled the web and crawled the WD help and found no answer...). Is there some way to do it? Thanks! --YjM (talk) 21:28, 26 April 2018 (UTC)

Oddly enough, I have convinced the WDQS to pick only Properties from the result:

...so, even though it is not generally applicable (imagine having also Lexemes in the result), I thought I will work around it with, but it returns

"Query is malformed: Encountered " "not exists" "NOT EXISTS "" at line 8, column 9."

and so on. Update: This was caused by a forgotten "FILTER" keyword, so a mistake on my side. This way is also possible.

So after a while, the only functional workaround which (I hope!) gives the desired resultset is following:

Is some of this behaviour actually intentional? --YjM (talk) 22:09, 26 April 2018 (UTC)
 * Per Wikibase/Indexing/RDF Dump Format:
 * Types ( or  ) for ,  ,   are currently omitted for performance reasons.
 * My workarounds:  (or  ) for (non)-items,   (or  ) for (non)-properties. Matěj Suchánek (talk) 07:23, 27 April 2018 (UTC)
 * Thanks Matěj for clarification! --YjM (talk) 12:00, 27 April 2018 (UTC)

Can't click next page button in result
I can't click next page buttons at the bottom-right in result page. For example, open this page and scroll down to the bottom of the result. Then "2044 results in 2854 ms" overlay prohibits clicking next page button. (Does this explanation make sense?) I've encountered this phenomenon in Chrome and IE.--Was a bee (talk) 12:11, 4 August 2018 (UTC)
 * Looks like it's fixed now. Smalyshev (WMF) (talk) 00:20, 7 August 2018 (UTC)
 * Oh, that's so nice. Thanks! --Was a bee (talk) 12:36, 8 August 2018 (UTC)

Add code snippet (besides prefixes)
Approximately 50% of time I'm opening monstrous d:Wikidata:SPARQL_query_service/queries/examples because I want to add SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]" } to my query. It would be nice to have a button "Add code snippet" that acts like "Add prefix" but not only for prefixes --Ghuron (talk) 09:23, 29 November 2018 (UTC)
 * You can type "SERVICE" and then press CTRL-Space and code completion will offer you choices to fill the rest. Smalyshev (WMF) (talk) 23:55, 5 December 2018 (UTC)
 * Doesn't seem to work for me, see screenshot when I'm pressing CTRL-Space. It's chromeos 70.0.3538.110, ru/en keyboard switcher is turned on --Ghuron (talk) 04:15, 6 December 2018 (UTC)
 * Don't type the space after SERVICE, just the word and then press CTRL-Space. Also, if may be that on your system CTRL-Space is overridden by some other application. Unfortunately, it's not yet configurable, see T210679. Smalyshev (WMF) (talk) 04:21, 6 December 2018 (UTC)
 * same thing w/o space. Chromium seems to allow app to consume this shortcut first, see here --Ghuron (talk) 04:28, 6 December 2018 (UTC)
 * I've added Alt-Enter and Ctrl-Alt-Space to the list of autocomplete shortcuts, please see if it works better for you Smalyshev (WMF) (talk) 01:05, 11 December 2018 (UTC)
 * Both works for chromeos --Ghuron (talk) 04:40, 11 December 2018 (UTC)

Error: "414 Request-URI Too Large"
I'm trying to run a query using the graphical interface that was working fine the other day. When I try to run it, I get back an "Unknown error" with the following HTML source displayed: 414 Request-URI Too Large 414 Request-URI Too Large nginx/1.13.6 I am fully aware that large queries should use a POST request with the query in the body rather than the URL, but the GUI used to handle this transparently, and needs to if it is to be used for large queries. Like I said the query I'm attempting to run was working earlier. --NoInkling (talk) 02:17, 9 January 2019 (UTC)


 * I cut as much as I could out of the query, now I'm getting  in both the GUI and a manual request. There's something weird going on. --NoInkling (talk) 03:19, 9 January 2019 (UTC)
 * Yes, it probably needs to be POST if it's long. If the GUI doesn't handle it please submit Phabricator issue with the query (or at least post the query somewhere so somebody else could submit it). Smalyshev (WMF) (talk) 05:53, 12 January 2019 (UTC)
 * I opened an issue on Phabricator. --NoInkling (talk) 05:54, 20 February 2019 (UTC)

Simple API SPARQL query fails - cache problem?
Hello. I want to find items based on the value of P225, for which I use a SPARQL API query, but I am plagued by what seem to be caching problems. If I execute the following URL (with Windows and Firefox): "https://query.wikidata.org/bigdata/namespace/wdq/sparql?query=select+%3Fx+%3FxLabel+where+%7B%3Fx+wdt%3AP225+%22Psalliota%22.+SERVICE+wikibase%3Alabel+%7B+bd%3AserviceParam+wikibase%3Alanguage+%22en%22.+%7D%7D", that is, a search for P225 = "Psalliota", I get back the following file, indicating that nothing has been found:

<?xml version='1.0' encoding='UTF-8'?> <sparql xmlns='http://www.w3.org/2005/sparql-results#'> <variable name='x'/> <variable name='xLabel'/>

But the item is there, it is Q61885451. If I execute the equivalent query with a similar old item "Agaricus": "https://query.wikidata.org/bigdata/namespace/wdq/sparql?query=select+%3Fx+%3FxLabel+where+%7B%3Fx+wdt%3AP225+%22Agaricus%22.+SERVICE+wikibase%3Alabel+%7B+bd%3AserviceParam+wikibase%3Alanguage+%22en%22.+%7D%7D", it works fine giving the following:

<?xml version='1.0' encoding='UTF-8'?> <sparql xmlns='http://www.w3.org/2005/sparql-results#'> <variable name='x'/> <variable name='xLabel'/> <binding name='x'> http://www.wikidata.org/entity/Q390456 <binding name='xLabel'> <literal xml:lang='en'>Agaricus

In other similar cases the query typically starts working after a few minutes, but I made "Psalliota" hours ago and I still cannot query for it.

Please could someone tell me how I can investigate this problem? Strobilomyces (talk) 17:44, 26 February 2019 (UTC)
 * Look at the little icon in the lower right of the WDQS screen just below the edit box - it looks like two curved arrows making a circle? Right now when I go there it's indicating red - suggested a long lag time. And hovering over it shows that WDQS is about 5 hours out of date. I have no idea why, but it's been way behind all day today. I just checked Phabricator and don't see anything on this. Anybody paying attention here??? ArthurPSmith (talk) 19:16, 26 February 2019 (UTC)
 * @User:ArthurPSmith: Thanks a lot for this answer, which makes my problem much clearer. There seem to be various servers which were updated at different times - at present either one hour ago or 3 hours ago. Strobilomyces (talk) 09:48, 27 February 2019 (UTC)
 * I would like to ask some more questions. Is the server update process of WDQS documented somewhere?  Is there some other way of finding an item based on the value of a property, apart from WDQS?  Could I pre-create my own items in advance and then instead of creating a new item, update the properties of a pre-allocated item to get around the problem?Strobilomyces (talk) 17:21, 27 February 2019 (UTC)
 * yes, we know about the lag (already fixed) but we can't usually fix it instantly. In most cases it is caused by traffic spike. Usually it is back to normal within an hour, sometimes (like today) it's not. It's ok to ping me or anybody from Search Platform team on IRC but usually we'd already know (unless we are offline for some reason) about the long lags. Smalyshev (WMF) (talk) 07:45, 28 February 2019 (UTC)
 * WDQS is documented extensively on mediawiki and wikitech but I am not sure which exactly information you're looking for. You certainly also can use Wikibase API to look up the data about specific items. Smalyshev (WMF) (talk) 07:45, 28 February 2019 (UTC)
 * Thanks for your answer. Well, I was looking for information about how to influence the update system of the query system, but I suppose that just means contacting someone through this page.  When you say "specific items", I think you mean "items where you already know the Q number".  But one reason that I need to use the query service is that I want to search for an item which I have already created (using "QuickStatements"), preferably using a property.  But I think none of the functions of the Wikibase API allow to do this.  Strobilomyces (talk) 19:11, 28 February 2019 (UTC)
 * on that last point of yours, AIUI the lag is "all changes" not "new items being added", so edits which update an existing item will be caught in the lag as well - whether or not they're newly created shouldn't significantly affect things. Andrew Gray (talk) 17:07, 28 February 2019 (UTC)
 * Well, my first problem shows up when I create items (which I do using QuickStatements), because in that case I don't know their Q numbers. But I think that it is true that I cannot get very much further without querying those items again, so you are right, it does not make much difference.    Strobilomyces (talk) 19:11, 28 February 2019 (UTC)

Feature Request?
It's only me or does anybody else miss an option to save one's own painfully developed queries? Without copying the URL or the raw query code at some local or wiki place all work usually is lost. Or do I overlook something? --Elya (talk) 20:35, 3 May 2019 (UTC)
 * You could just bookmark it (or use short URL button and copy it). WDQS servers do not have any permanent non-SPARQL storage so they can't really save queries, but since it's part of the URL, they can be saved anywhere like in bookmarks. Smalyshev (WMF) (talk) 07:21, 8 May 2019 (UTC)

Query timeout limit for important query reached
See here. --jobu0101 (talk) 22:00, 10 August 2019 (UTC)

The population for Orange Free State is incorrect
I am not sure if this is the correct place to report an error in Wikidata, thus if not, please be so kind as to refer me to the correct forum. I would have tried to correct this if I knew how to do it, and if I was expert in Russian, which I'm not. I thus request that the editors of Wikidata refer this issue to someone that is better qualified and more capable of fixing the problem.

Thank you for your attention.

Here is my error report

I have executed one of the sample queries in the SPARQL tutorial (The example I am referring to)

I noticed that the resulting population record for "Orange Free State" is incorrect:

wd:Q218023 	Orange Free State 	207503189

I am not sure what the correct value is, but the Wikipedia page lists a value of 100,000 in 1875, the value above (207503189) is linked to a reference in the Russian Wikipedia, for the year 1890. It is incorrect. The Orange Free State was incorporated as a province, simply named the Free State, into what eventually became South Africa. The population of the Free State in modern South Africa is estimated as 2,866,678 ([|List of South African provinces by population]. It is simply impossible that more than 200 million people could have migrated to and then out of that area in the course of 143 years.

Use of tinyurl
Kind of silly that tinyurl is the URL shortener when that domain is blocked from the English Wikipedia, so we effectively can't even share the links on-wiki. Would it be possible to use a different domain instead? czar 12:02, 18 June 2018 (UTC)

Save queries in account
I'd like the ability to save queries in my account both publicly and private. Also it should be possible to name, describe and tag them. So people will be able to find more queries in the Examples section. --Loominade (talk) 07:47, 22 August 2018 (UTC)

searching highest mountains is mixing up units (meters vs. feet)
searching highest mountains is mixing up meters and feet values (many US mountains are above 8000 ft, and therefore seem to be the highest on planet) searching the highest mountains does not mean searching the highest number (if I measure my house in millimeters, it is larger than any mountain on earth). (even more useless by the fact, that outside of USA nobody is using feet, but only meters)

tinyurl.com ydczydek ?subj wdt:P2044 ?elev	filter(?elev > 8500).

I derived this from help examples. If there is a better query, then examples should be improved. If not, then please extend the search engine to handle this. This applies to anything, that has different units (area, height, elevation, time/age, date, price/money(at least roughly possible, as via e.g. google convert), etc).

--Aleks-ger (talk) 13:17, 2 November 2018 (UTC)

input box for "But not Include" in Query Helper
I think if we add an option in Query Helper GUI to exclude the results, that can be helpful. something to add this code:

FILTER NOT EXISTS { ?item wdt:P31 wd:Q19832712. }

--Hariva (talk) 19:32, 9 November 2018 (UTC)

Example query cannot run
All museums (including subclass of museum) in Washington, D.C. with coordinates It cannot return the result because of the timeout problem.

Not all entries are showing up
When I search for all countries in WikiData using WikiData query service, certain countries like Sweden and Denmark do now show up. They used to do that, and they seem to be annotated correctly.


 * This is because preferred type for is . If you want to see all types, use   instead of  . Smalyshev (WMF) (talk) 07:50, 21 December 2018 (UTC)

Query Service: Jumping Frames
Hi, query service is a very great tool. But could you please fix the bug with the jumping windows. Its extremely disturbing when they are resizing to zero and back to normal after every little change. Ogmios (talk) 15:54, 16 February 2019 (UTC)

Abfragehelfer ist leer
Das Fenster Abfragehelfer bleibt komplett leer.91.221.58.20 14:56, 18 February 2019 (UTC)

Is there a way to add UTF-8 BOM to exported tsv file?
It would help to work with those files in various processing tools --Ghuron (talk) 07:50, 25 February 2019 (UTC)

Run selected query
MS SQL Server Query Analyser had very useful feature - when you click "Run query" button, it tries to run only query from selected text, not everything. This way you can have several queries in 1 window, which is very useful if you do data exploration. If nothing is selected, "Run query" works exactly like today --Ghuron (talk) 12:17, 11 March 2019 (UTC)

Weird Pxxx units have been showing up lately
For a query such as

CONSTRUCT {?s ?p ?o.} WHERE { VALUES ?s {wdv:1b133cdd8e6d4ab769bf119d89ebe63e} ?s ?p ?o.}

there are both entity-based units (Q7727) and weird property-based units (P7727) being returned. If one attempts to edit the original value (see P2047 for Q1004531), there's no indication where the property-based unit is coming from. Graph error? Something else? This is not an isolated case.

Both Examples Tried Failed
Interested in this I tried two examples from the examples folder. First gave a Javascript error. Second gave some results but also a timeout reached error. Not great examples if they don't work (or the service has a lot of issues); not sure which but its rather offputting!

R code fix
R code fails it needs argument for agent wrong code is

SPARQL(endpoint,query)

correct code is

SPARQL(endpoint,query,curl_args=list(useragent=R.version.string))

see https://stackoverflow.com/questions/58560369/r-sparql-wikidata-opening-and-ending-tag-mismatch

who is in charge of the code tab and the suggestion?

The graph graph
The "Graph" results display should probably be called "network", which is the more commons parlance for an edges-and-nodes visualisation. This is especially the case as one of the other display options is "Graph builder".

Additionally, there are two features for the network display that may be easy to implement, but very valuable: T.Shafee(Evo&#65120;Evo)talk 06:42, 18 November 2019 (UTC)
 * When two nodes point to each other, make single two-headed arrow rather than two single-headed arrows (example)
 * Allow edges to be coloured by the type of property relationship that they represent, just like nodes can be (example)

Default Maps representation vs http://graves.wiki/
The default maps representation on the query service struggles when multiple results are spatially close or fully overlap (example query). Implementing an interface more like http://graves.wiki/ (GitHub source by User:Yarl) would massively improve usability! T.Shafee(Evo&#65120;Evo)talk 05:54, 20 November 2019 (UTC)


 * You can achieve a similar effect (query) with a custom result view option. --Lucas Werkmeister (WMDE) (talk) 12:08, 22 November 2019 (UTC)
 * Thank you so much for that! A few questions about it:
 * Is there a way to make that the default view for maps normally?
 * Is there a way to make it compatible with the layers? The numbers currently don't change when the layers are turned on and off (clearer example).
 * Also, it'd be amazing to have the remaining single points a little larger if possible.
 * T.Shafee(Evo&#65120;Evo)talk 02:46, 23 November 2019 (UTC)
 * 2) I haven’t yet found a way to make the interaction of markercluster and layers work (it’s broken in several ways); 1) not before 2 is fixed; 3) hm, where would that be necessary? It’s supposed to mirror the size of the marker dots without markercluster enabled. --Lucas Werkmeister (WMDE) (talk) 16:26, 25 November 2019 (UTC)
 * Thanks for the info. Hopefully the layers compatibility proves possible eventually. I found the point size made the singletons easy to miss (especially in some colours). It could be useful to have the singletons double size whenever there is at least one cluster shown, but going back to normal size once zoomed enough that no clusters are show. I really love the polygon outline drawn for each cluster upon mouseover though! T.Shafee(Evo&#65120;Evo)talk 01:03, 26 November 2019 (UTC)

Property path with repetition count
I don't seem to be able to use the "elt{n,m}" form of property paths. This query

works fine but the following:

produces the error {{tq|Query is malformed: Encountered " "{" "{ "" at line 1, column 42.}}. Is this supposed to be supported? Cheers, Bovlb (talk) 16:39, 23 November 2019 (UTC)
 * I cannot find anything about this in SPARQL. --Matěj Suchánek (talk) 12:33, 24 November 2019 (UTC)
 * Hmm. Interesting.  It was in the working draft, but somehow didn't make it into the following recommendation.   Curiously, that syntax is supported by Apache Jena.  Looking closely at their documentation, it is described as an "ARQ extension".  I guess that answers my question.  Thanks! Bovlb (talk) 16:20, 24 November 2019 (UTC)

sdcquery.wmflabs.org
https://sdcquery.wmflabs.org/ has help page with "Give Feedback" linking to here. Is this the right place to be asking about that service? --Jarekt (talk) 02:54, 16 December 2019 (UTC)

osmID with wikidata link not being reported in query
In the query https://w.wiki/EX3, the osmlink for wikidata item is not being reported, though it is linked for the  mandal qid wd:Q7918199 (see the sophox query (http://sophox.org)  below)

--Arjunaraoc (talk) 09:51, 27 December 2019 (UTC)
 * Link for the issue on openstreetmap wiki https://wiki.openstreetmap.org/wiki/Talk:Sophox_Editor#osmID_with_wikidata_link_not_being_reported_in_query --Arjunaraoc (talk) 10:08, 27 December 2019 (UTC)
 * is linked from relation/10219506, but has no  tag, if you want both the name and the openstreetmap relation to be individually optional, you should do it with surrounding both individually with an optional clause:
 * --CamelCaseNick (talk) 00:39, 17 January 2020 (UTC)
 * Thanks CamelCaseNick, Looks like I missed adding name:te here. --Arjunaraoc (talk) 04:00, 17 January 2020 (UTC)

Getting french cities from their geoname ID doesn't work. Other countries, yes.
Getting french cities from their geoname ID doesn't work. Other countries, seem yes.

Try it

Also, some GeoNamesIDs on wikidata's city pages simply don't correspond to the ones given by geonames.org. For examples: Paris (FR), Venice (IT) Seems strange but maybe there has been an update.

Tooltip for property used as object is incorrect
The tooltip for properties referenced using the 'wd' prefix is wrong.

Steps:


 * 1) Open
 * 2) Hover over 'wd:P276'.

Expected result: name and description of location (P276) in the description.

Actual result: tooltip displays an item that happens to start with "P276".

Screenshot:

Cdo256 (talk) 14:37, 22 September 2020 (UTC)

get rottenId from imdbid is wrong!
SELECT ?rottenId WHERE {           ?item wdt:P345 "tt7294150". ?item wdt:P1258 ?rottenId }

return m/the_eight_hundred_heroes bug the right one is：m/the_eight_hundred

Example for longest river is incorrect
Just to feedback that the example of longest river does not take into account of Unit of length, some length are in Km, some are in meter. see the code comment

SELECT ?item ?itemLabel ?length ?pic ?location WHERE { ?item wdt:P31/wdt:P279* wd:Q4022. ?item wdt:P2043 ?length. ?item wdt:P18 ?pic. #IF this is taken away, it will return the result of Q95676337	with length 20202.373	but in meter ?item wdt:P625 ?location SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?length) ?itemLabel LIMIT 50
 * 1) Longest rivers