User:Kghbln/queries: Difference between revisions
Jump to navigation
Jump to search
(+ cat) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 50: | Line 50: | ||
[https://tinyurl.com/yruqcec2 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%3Fonline%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP2%20wd%3AQ5.%0A%20%20%3Fitem%20wdt%3AP1%20%3Furl%20.%0A%20%20%3Fitem%20wdt%3AP13%20%3Fonline.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D wikibase.world/query/ - long URL] | [https://tinyurl.com/yruqcec2 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%3Fonline%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP2%20wd%3AQ5.%0A%20%20%3Fitem%20wdt%3AP1%20%3Furl%20.%0A%20%20%3Fitem%20wdt%3AP13%20%3Fonline.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D wikibase.world/query/ - long URL] | ||
=== by inception date === | === all by inception date === | ||
; query code | ; query code | ||
<syntaxhighlight lang=sparql> | <syntaxhighlight lang=sparql> | ||
Line 58: | Line 58: | ||
SELECT ?item ?itemLabel ?url ?inceptionDate | SELECT ?item ?itemLabel ?url ?inceptionDate | ||
WHERE { | WHERE { | ||
?item wdt:P1 ?url. | ?item wdt:P1 ?url. | ||
?item wdt:P5 ?inceptionDate. | ?item wdt:P5 ?inceptionDate. | ||
Line 66: | Line 65: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
; query result | ; query result | ||
[https://tinyurl.com/ | [https://tinyurl.com/2bdunzcf 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%3FinceptionDate%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP1%20%3Furl.%0A%20%20%3Fitem%20wdt%3AP5%20%3FinceptionDate.%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%3FinceptionDate - long URL] | ||
=== all by inception date and online === | === all by inception date and online === | ||
Line 84: | 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 === | ||
Line 102: | Line 119: | ||
; query result | ; query result | ||
[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] | [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] | ||
[[Category:User:Kghbln]] |
Latest revision as of 07:15, 9 October 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