User:Kghbln/queries
Wikibase instances that are hosted independently.
- 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
Wikibase instances that are hosted independently and are 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
Wikibase instances that are hosted independently and are online. Explicitly show the status.
- 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
Wikibase instances by their 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:P2 wd:Q5.
?item wdt:P1 ?url.
?item wdt:P5 ?inceptionDate.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?inceptionDate
- query result