Bureaucrats, emailconfirmed, Administrators
1,168
edits
User:Kghbln/queries: Difference between revisions
→by inception date and online
| Line 68: | Line 68: | ||
[https://tinyurl.com/yt2mlkdg 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%3AP2%20wd%3AQ5.%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] | [https://tinyurl.com/yt2mlkdg 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%3AP2%20wd%3AQ5.%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] | ||
=== by inception date and online === | === all by inception date and online === | ||
; query code | ; query code | ||
<syntaxhighlight lang=sparql> | <syntaxhighlight lang=sparql> | ||
| Line 74: | Line 74: | ||
PREFIX wd: <https://wikibase.world/entity/> | PREFIX wd: <https://wikibase.world/entity/> | ||
SELECT ?item | SELECT ?item ?url ?inceptionDate WHERE { | ||
WHERE { | ?item wdt:P1 ?url; | ||
wdt:P5 ?inceptionDate; | |||
?item wdt:P1 ?url | wdt:P13 wd:Q54. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
ORDER BY ?inceptionDate | ORDER BY (?inceptionDate) | ||
</syntaxhighlight> | </syntaxhighlight> | ||
; query result | ; query result | ||
[https://tinyurl.com/ | [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] | ||
=== online and using the Wikibase Local Media extension === | === online and using the Wikibase Local Media extension === | ||