User:Kghbln/queries: Difference between revisions

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:P2 wd:Q5.
   ?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/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/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 ===
Bureaucrats, emailconfirmed, Administrators
1,168

edits