Bureaucrats, emailconfirmed, Administrators
273
edits
GreenReaper (talk | contribs) (Update query UI URI) Tags: Mobile edit Mobile web edit Advanced mobile edit |
GreenReaper (talk | contribs) m (→Convention instances, including postponements: switch to universal wfd prefix) |
||
Line 25: | Line 25: | ||
PREFIX wfd: <https://furry.wikibase.cloud/entity/> | PREFIX wfd: <https://furry.wikibase.cloud/entity/> | ||
PREFIX wfdt: <https://furry.wikibase.cloud/prop/direct/> | PREFIX wfdt: <https://furry.wikibase.cloud/prop/direct/> | ||
PREFIX | PREFIX wfdp: <https://furry.wikibase.cloud/prop/> | ||
PREFIX | PREFIX wfdps: <https://furry.wikibase.cloud/prop/statement/> | ||
PREFIX | PREFIX wfdpq: <https://furry.wikibase.cloud/prop/qualifier/> | ||
SELECT ?eventInstanceLabel ?eventStart ?eventEnd ?eventRank ?eventSeriesLabel | SELECT ?eventInstanceLabel ?eventStart ?eventEnd ?eventRank ?eventSeriesLabel | ||
WHERE | WHERE | ||
Line 37: | Line 37: | ||
# duplicate for each start time property | # duplicate for each start time property | ||
# (not wfdt: to get single eventStart) | # (not wfdt: to get single eventStart) | ||
wfdp:P6 ?eventStartProp. | |||
# populate start time for the row with this property | # populate start time for the row with this property | ||
?eventStartProp | ?eventStartProp wfdps:P6 ?eventStart. | ||
# normal or deprecated (rescheduled/cancelled) | # normal or deprecated (rescheduled/cancelled) | ||
?eventStartProp wikibase:rank ?eventRank. | ?eventStartProp wikibase:rank ?eventRank. | ||
# grab end time as qualifier if present (else, one-day event) | # grab end time as qualifier if present (else, one-day event) | ||
OPTIONAL {?eventStartProp | OPTIONAL {?eventStartProp wfdpq:P7 ?eventEnd} | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
ORDER BY DESC(?eventInstanceLabel) DESC(?eventStart) DESC(?eventRank) | ORDER BY DESC(?eventInstanceLabel) DESC(?eventStart) DESC(?eventRank) | ||
</SPARQL> | </SPARQL> |