Le mer. 22 janv. 2020 à 11:36, Olaf Simons <olaf.simons@pierre-marteau.com> a écrit :

and I gave a mutilated link again... This is my search:

https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fplace%20wdt%3AP2%20wd%3AQ8.%0A%7D

now most of these places have a Wikidata reference, which you find in the section of Wikimedia-related projects (at the end or to the right, where you can link to Wikipedias).

https://database.factgrid.de/wiki/Item:Q10279

the Wikidata link is under "wikidatawiki"

I am wondering how I can have these Wikidata Q-numbers in a column. (I am just preparing a new input from Wikidata and want to make sure I do not create double records - identical Wikidata-numbers are the indicator that we already have the item...)

best,
Olaf

I'm confused: what is the difference between your wish and the query a gave you? (because my query do have the « Wikidata Q-numbers in a column. »)

I've added a filter to have only the Wikidata links (my previous query gave all the links, wikidata or otherwise) : https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Flink%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fplace%20wdt%3AP2%20wd%3AQ8.%0A%20%20%3Flink%20schema%3Aabout%20%3Fplace%20%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fwww.wikidata.org%2F%3E%20.%0A%7D

Cheers,

~nicolas