From WikiFur Data
Revision as of 02:48, 17 April 2021 by GreenReaper (talk | contribs) (+Convention series with data and logo, Convention instances, including postponements)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


PREFIX wfd: <>
PREFIX wfdt: <>

SELECT ?itemLabel ?creationDate (CONCAT("", substr(?logoMD5, 1, 1), "/", substr(?logoMD5, 1, 2), "/", ?logoFileName) AS ?logoURL)
    ?item wfdt:P2 wfd:Q2 .
    ?item wfdt:P6 ?creationDate .
      ?item wfdt:P15 ?logoFileName.
      BIND(MD5(?logoFileName) as ?logoMD5).
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

Convention instances, including postponements

PREFIX wfd: <>
PREFIX wfdt: <>
PREFIX wfp: <>
PREFIX wfps: <>
PREFIX wfpq: <>
SELECT ?eventInstanceLabel ?eventStart ?eventEnd ?eventRank ?eventSeriesLabel 
  #                subclass of furcons
  ?eventSeries     wfdt:P2 wfd:Q2.
  #                instance of specific furcon
  ?eventInstance   wfdt:P1 ?eventSeries;
  #                duplicate for each start time property
  #                (not wfdt: to get single eventStart)
                   wfp:P6 ?eventStartProp.
  #                populate start time for the row with  this property
  ?eventStartProp  wfps:P6 ?eventStart.
  #                normal or deprecated (rescheduled/cancelled)
  ?eventStartProp  wikibase:rank ?eventRank.
  #                grab end time as qualifier if present (else, one-day event)
  OPTIONAL {?eventStartProp wfpq:P7 ?eventEnd}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
ORDER BY DESC(?eventInstanceLabel) DESC(?eventStart) DESC(?eventRank)