User:Kghbln/queries

< User:Kghbln
Revision as of 07:15, 9 October 2023 by Kghbln (talk | contribs) (+ cat)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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