Wikibase Registry is now Wikibase World. Learn more on the project talk page.

User:Kghbln/queries: Difference between revisions

From Wikibase World
Jump to navigation Jump to search
(add)
Line 83: Line 83:
; query result
; query result
[https://tinyurl.com/284sfyek 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%3Furl%20%3FinceptionDate%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP1%20%3Furl%3B%0A%20%20%20%20wdt%3AP5%20%3FinceptionDate%3B%0A%20%20%20%20wdt%3AP13%20wd%3AQ54.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%28%3FinceptionDate%29 - long URL]
[https://tinyurl.com/284sfyek 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%3Furl%20%3FinceptionDate%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP1%20%3Furl%3B%0A%20%20%20%20wdt%3AP5%20%3FinceptionDate%3B%0A%20%20%20%20wdt%3AP13%20wd%3AQ54.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%28%3FinceptionDate%29 - long URL]
=== all using the Automated Values extension and online ===
; query code
<syntaxhighlight lang=sparql>
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>
SELECT ?item ?itemLabel ?url ?onlineLabel ?extension ?extensionLabel
WHERE {
  ?item wdt:P1 ?url .
  ?item wdt:P13 ?online.
  ?item wdt:P14 ?extension.
  FILTER(?extension = wd:Q216)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
</syntaxhighlight>
; query result
[https://tinyurl.com/2c2pem5a 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%3AQ216%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]


=== all using the Wikibase Local Media extension and online ===
=== all using the Wikibase Local Media extension and online ===

Revision as of 09:42, 20 September 2023

Wikis using Wikibase

independently hosted

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?itemLabel ?url
WHERE {
  ?item wdt:P2 wd:Q5.
  ?item wdt:P1 ?url .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
query result

tinyurl.com - short URL / wikibase.world/query/ - long URL

independently hosted and online

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?itemLabel ?url
WHERE {
  ?item wdt:P2 wd:Q5.
  ?item wdt:P1 ?url .
  ?item wdt:P13 wd:Q54.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
query result

tinyurl.com - short URL / wikibase.world/query/ - long URL

independently hosted and online (show status explicitly)

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?itemLabel ?url ?online
WHERE {
  ?item wdt:P2 wd:Q5.
  ?item wdt:P1 ?url .
  ?item wdt:P13 ?online.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
query result

tinyurl.com - short URL / wikibase.world/query/ - long URL

all by inception date

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?itemLabel ?url ?inceptionDate
WHERE {
  ?item wdt:P1 ?url.
  ?item wdt:P5 ?inceptionDate.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?inceptionDate
query result

tinyurl.com - short URL / - long URL

all by inception date and online

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?url ?inceptionDate WHERE {
  ?item wdt:P1 ?url;
    wdt:P5 ?inceptionDate;
    wdt:P13 wd:Q54.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?inceptionDate)
query result

tinyurl.com - short URL / - long URL

all using the Automated Values extension and online

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?itemLabel ?url ?onlineLabel ?extension ?extensionLabel
WHERE {
  ?item wdt:P1 ?url .
  ?item wdt:P13 ?online.
  ?item wdt:P14 ?extension.
  FILTER(?extension = wd:Q216)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
query result

tinyurl.com - short URL / - long URL

all using the Wikibase Local Media extension and online

query code
PREFIX wdt: <https://wikibase.world/prop/direct/>
PREFIX wd: <https://wikibase.world/entity/>

SELECT ?item ?itemLabel ?url ?onlineLabel ?extension ?extensionLabel
WHERE {
  ?item wdt:P1 ?url .
  ?item wdt:P13 ?online.
  ?item wdt:P14 ?extension.
  FILTER(?extension = wd:Q215)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
query result

tinyurl.com - short URL / - long URL

Retrieved from "https://wikibase.world/w/index.php?title=User:Kghbln/queries&oldid=2398"