Bureaucrats, emailconfirmed, Administrators
272
edits
GreenReaper (talk | contribs) (+Convention series with data and logo, Convention instances, including postponements) |
GreenReaper (talk | contribs) (Update query UI URI) Tags: Mobile edit Mobile web edit Advanced mobile edit |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
These [[wikipedia:SPARQL|SPARQL]] queries [//furry.wikibase.cloud/query/ can be used] in the local [[wikidata:Wikidata:SPARQL query service|Query Service]]. See [[wikidata:Wikidata:SPARQL tutorial|Wikidata's tutorial]] for an overview. The custom prefix declarations are required, and do not autocomplete (<code>wd:</code> does, but actually queries Wikidata). | |||
==Conventions== | ==Conventions== | ||
===Convention series with data and logo=== | ===Convention series with data and logo URL=== | ||
<SPARQL> | <SPARQL> | ||
PREFIX wfd: < | PREFIX wfd: <https://furry.wikibase.cloud/entity/> | ||
PREFIX wfdt: < | PREFIX wfdt: <https://furry.wikibase.cloud/prop/direct/> | ||
SELECT ?itemLabel ?creationDate (CONCAT("https://en.wikifur.com/w/images/", substr(?logoMD5, 1, 1), "/", substr(?logoMD5, 1, 2), "/", ?logoFileName) AS ?logoURL) | SELECT ?itemLabel ?creationDate (CONCAT("https://en.wikifur.com/w/images/", substr(?logoMD5, 1, 1), "/", substr(?logoMD5, 1, 2), "/", ?logoFileName) AS ?logoURL) | ||
Line 16: | Line 18: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | ||
} | } | ||
ORDER BY ?creationDate | |||
</SPARQL> | </SPARQL> | ||
===Convention instances, including postponements=== | ===Convention instances, including postponements=== | ||
<SPARQL> | <SPARQL> | ||
PREFIX wfd: < | PREFIX wfd: <https://furry.wikibase.cloud/entity/> | ||
PREFIX wfdt: < | PREFIX wfdt: <https://furry.wikibase.cloud/prop/direct/> | ||
PREFIX wfp: < | PREFIX wfp: <https://furry.wikibase.cloud/prop/> | ||
PREFIX wfps: < | PREFIX wfps: <https://furry.wikibase.cloud/prop/statement/> | ||
PREFIX wfpq: < | PREFIX wfpq: <https://furry.wikibase.cloud/prop/qualifier/> | ||
SELECT ?eventInstanceLabel ?eventStart ?eventEnd ?eventRank ?eventSeriesLabel | SELECT ?eventInstanceLabel ?eventStart ?eventEnd ?eventRank ?eventSeriesLabel | ||
WHERE | WHERE |