Bureaucrats, emailconfirmed, Administrators
1,151
edits
User:Kghbln/queries: Difference between revisions
→online and using the Wikibase Local Media extension
(add) |
|||
| Line 95: | Line 95: | ||
SELECT ?item ?itemLabel ?url ?onlineLabel ?extension ?extensionLabel | SELECT ?item ?itemLabel ?url ?onlineLabel ?extension ?extensionLabel | ||
WHERE { | WHERE { | ||
?item wdt:P1 ?url . | ?item wdt:P1 ?url . | ||
?item wdt:P13 ?online. | ?item wdt:P13 ?online. | ||
| Line 104: | Line 103: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
; query result | ; query result | ||
[https://tinyurl.com/ | [https://tinyurl.com/2bjomsku tinyurl.com - short URL] / [https://wikibase.world/query/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fwikibase.world%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fwikibase.world%2Fentity%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Furl%20%3FonlineLabel%20%3Fextension%20%3FextensionLabel%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP1%20%3Furl%20.%0A%20%20%3Fitem%20wdt%3AP13%20%3Fonline.%0A%20%20%3Fitem%20wdt%3AP14%20%3Fextension.%0A%20%20FILTER%28%3Fextension%20%3D%20wd%3AQ215%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D - long URL] | ||