User:TweetsFactsAndQueries/Queries/twins at Eurovision

From Wikidata
Jump to navigation Jump to search

Originally posted on Twitter and on Mastodon.

#defaultView:Timeline
SELECT ?entry ?entryLabel ?artist ?artistLabel (MIN(?date) AS ?date_) (SAMPLE(?image) AS ?image_) WHERE {
  {
    ?entry wdt:P1344 ?contest.
    ?contest wdt:P31 wd:Q110288240.
  } UNION {
    ?entry wdt:P31 wd:Q63481999.
  }
  ?entry wdt:P585|wdt:P577 ?date;
         wdt:P175 ?artist.
  OPTIONAL { ?artist wdt:P18 ?image. }
  {
    ?artist (wdt:P527|^wdt:P361)?/wdt:P361?/(wdt:P31|wdt:P1552)/wdt:P279* wd:Q14756018.
  } UNION {
    ?artist (wdt:P527|^wdt:P361|^wdt:P463)?/p:P3373/pq:P1039/wdt:P279* wd:Q159979.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?entry ?entryLabel ?artist ?artistLabel
Try it!