On 9/17/19 4:27 PM, Olaf Simons wrote:
Exactly, perfect - and good script to know...
thanks,
Olaf
Another example, using the SPARQL endpoint at:
http://wikidata.demo.openlinksw.com/sparql :
[1] Editor Page --
https://tinyurl.com/yytx7ad9
[2] Results Page --
https://tinyurl.com/y342mewo
Tweaked query:
SELECT ?Masonic_Lodge ?Masonic_LodgeTitle (sample(?Masonic_LodgeTitle)
as ?wpTitle) WHERE {
?Masonic_Lodge wdt:P31 wd:Q1454597.
OPTIONAL {
?article schema:about ?Masonic_Lodge ;
schema:name ?Masonic_LodgeTitle
}
FILTER (LANG(?Masonic_LodgeTitle) = "en")
} GROUP BY ?Masonic_Lodge ?Masonic_LodgeTitle
Kingsley
Thomas Douillard
<thomas.douillard(a)gmail.com> hat am 17. September 2019 um 22:15 geschrieben:
Is it what you need ?
<https://query.wikidata.org/#SELECT%20%3FMasonic_Lodge%20%3FMasonic_LodgeLabel%20%28sample%28%3FMasonic_LodgeTitle%29%20as%20%3FwpTitle%29%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%3FMasonic_Lodge%20wdt%3AP31%20wd%3AQ1454597.%0A%20%20OPTIONAL%20%7B%20%20%0A%20%20%20%20%3Farticle%20schema%3Aabout%20%3FMasonic_Lodge%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3Aname%20%3FMasonic_LodgeTitle%0A%20%20%7D%0A%7D%20group%20by%20%3FMasonic_Lodge%20%3FMasonic_LodgeLabel%20>
Le mar. 17 sept. 2019 à 22:03, Olaf Simons <olaf.simons(a)pierre-marteau.com>
a écrit :
Hi,
I am trying to bring some light into this query:
https://w.wiki/8Xv
Many of the listings have no labels in any language - is there a simple
way to get the Wikipedia-title in whatever wp with the q-Number?
cheers
Olaf
Dr. Olaf Simons
Forschungszentrum Gotha der Universität Erfurt
Schloss Friedenstein, Pagenhaus
99867 Gotha
Büro: +49-361-737-1722
Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata Dr. Olaf Simons
Forschungszentrum Gotha der Universität Erfurt
Schloss Friedenstein, Pagenhaus
99867 Gotha
Büro: +49-361-737-1722
Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
--
Regards,
Kingsley Idehen
Founder & CEO
OpenLink Software
Home Page:
http://www.openlinksw.com
Community Support:
https://community.openlinksw.com
Weblogs (Blogs):
Company Blog:
https://medium.com/openlink-software-blog
Virtuoso Blog:
https://medium.com/virtuoso-blog
Data Access Drivers Blog:
https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers
Personal Weblogs (Blogs):
Medium Blog:
https://medium.com/@kidehen
Legacy Blogs:
http://www.openlinksw.com/blog/~kidehen/
http://kidehen.blogspot.com
Profile Pages:
Pinterest:
https://www.pinterest.com/kidehen/
Quora:
https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter:
https://twitter.com/kidehen
Google+:
https://plus.google.com/+KingsleyIdehen/about
LinkedIn:
http://www.linkedin.com/in/kidehen
Web Identities (WebID):
Personal:
http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
:
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this