User:TweetsFactsAndQueries/Queries/twins at Eurovision
Jump to navigation
Jump to search
Try it!
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