query-140d134cd2768facc8e887a06832a33c

rq turtle/ttl

title: Participants (groups and singers) at Eurovision 2024 SELECT ?performer (GROUP_CONCAT(DISTINCT(?performerName); separator=" / ") as ?NameOrTitle) ?performerLabel ?performerDescription (GROUP_CONCAT(DISTINCT(?countryLabel); separator=" + ") as ?countries) (GROUP_CONCAT(DISTINCT(?langLabel); separator=" + ") as ?langs) WHERE { SELECT ?performer ?performerName ?performerLabel ?performerDescription ?countryLabel ?langLabel WHERE { ?euro wdt:P179 wd:Q276; wdt:P585 ?time. FILTER (YEAR(?time)=2024). VALUES ?type {wd:Q5 wd:Q2088357} ?performer wdt:P31/wdt:P279* ?type. ?performer wdt:P1344 ?euro. OPTIONAL {?performer wdt:P1476|wdt:P1559|wdt:P2561|wdt:P1705|wdt:P1448 ?performerName.} OPTIONAL {?performer wdt:P17|wdt:P495|wdt:P27 ?country.} OPTIONAL {?performer wdt:P1412|wdt:P2936 ?lang.} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } } GROUP BY ?performer ?NameOrTitle ?performerLabel ?performerDescription ORDER BY ?NameOrTitle

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Participants (groups and singers) at Eurovision 2024
SELECT ?performer
(GROUP_CONCAT(DISTINCT(?performerName); separator=" / ") as ?NameOrTitle)
?performerLabel ?performerDescription
(GROUP_CONCAT(DISTINCT(?countryLabel); separator=" + ") as ?countries)
(GROUP_CONCAT(DISTINCT(?langLabel); separator=" + ") as ?langs)
WHERE
{
  SELECT ?performer ?performerName ?performerLabel ?performerDescription ?countryLabel ?langLabel WHERE {
  ?euro wdt:P179 wd:Q276; wdt:P585 ?time. FILTER (YEAR(?time)=2024).
  VALUES ?type {wd:Q5 wd:Q2088357}
  ?performer wdt:P31/wdt:P279* ?type.
  ?performer wdt:P1344 ?euro.
  OPTIONAL {?performer wdt:P1476|wdt:P1559|wdt:P2561|wdt:P1705|wdt:P1448 ?performerName.}
  OPTIONAL {?performer wdt:P17|wdt:P495|wdt:P27 ?country.}
  OPTIONAL {?performer wdt:P1412|wdt:P2936 ?lang.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
 }
GROUP BY ?performer ?NameOrTitle ?performerLabel ?performerDescription
ORDER BY ?NameOrTitle

Query found at