query-15e992a15a285f49d64292ae1b87dfca

rq turtle/ttl

All band from a special country SELECT ?band ?bandLabel (GROUP_CONCAT(DISTINCT ?typeLabel; separator=", ") AS ?types) (GROUP_CONCAT(DISTINCT ?genreLabel; separator=", ") AS ?genres) (GROUP_CONCAT(DISTINCT ?mitgliedLabel; separator=", ") AS ?mitglieder) ?geb ?gebOrtLabel ?img WHERE { VALUES ?land { wd:Q1005 wd:Q1041 wd:Q912 wd:Q965 wd:Q117 wd:Q945 wd:Q962 wd:Q1008 wd:Q1006 wd:Q1044 wd:Q1007 wd:Q1014 } # Maroko (changy to whatever country you want) VALUES ?b { wdt:P740 wdt:P495 wdt:P27 } ?band wdt:P31/wdt:P279* wd:Q215380; ?b ?land.

OPTIONAL { ?band wdt:P495 ?gebOrt. } ?band wdt:P31 ?type. OPTIONAL { ?band wdt:P527 ?mitglied. } OPTIONAL { ?band wdt:P571 ?geb. } OPTIONAL { ?band wdt:P136 ?genre. } OPTIONAL { ?band wdt:P18 ?img. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr". ?band rdfs:label ?bandLabel . ?genre rdfs:label ?genreLabel . ?gebOrt rdfs:label ?gebOrtLabel. ?type rdfs:label ?typeLabel. ?mitglied rdfs:label ?mitgliedLabel. } } GROUP BY ?band ?bandLabel ?geb ?gebOrtLabel ?img ORDER BY ASC (?geb)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# All band from a special country
SELECT ?band ?bandLabel 
      (GROUP_CONCAT(DISTINCT ?typeLabel; separator=", ") AS ?types)
      (GROUP_CONCAT(DISTINCT ?genreLabel; separator=", ") AS ?genres)
      (GROUP_CONCAT(DISTINCT ?mitgliedLabel; separator=", ") AS ?mitglieder)
      ?geb ?gebOrtLabel ?img 
WHERE {
  VALUES ?land { wd:Q1005 wd:Q1041 wd:Q912 wd:Q965 wd:Q117 wd:Q945 wd:Q962 wd:Q1008 wd:Q1006 wd:Q1044 wd:Q1007 wd:Q1014 }  # Maroko (changy to whatever country you want)
  VALUES ?b { wdt:P740 wdt:P495 wdt:P27 }
  ?band wdt:P31/wdt:P279* wd:Q215380;
           ?b ?land.

  OPTIONAL { ?band wdt:P495 ?gebOrt. }
  ?band wdt:P31 ?type.
  OPTIONAL { ?band wdt:P527 ?mitglied. }
  OPTIONAL { ?band wdt:P571 ?geb. }
  OPTIONAL { ?band wdt:P136 ?genre. }
  OPTIONAL { ?band wdt:P18 ?img. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr". 
    ?band rdfs:label ?bandLabel .
    ?genre rdfs:label ?genreLabel .
    ?gebOrt rdfs:label ?gebOrtLabel.
    ?type rdfs:label ?typeLabel.
    ?mitglied rdfs:label ?mitgliedLabel.
  }
}
GROUP BY ?band ?bandLabel ?geb ?gebOrtLabel ?img
ORDER BY ASC (?geb)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?b") v4("?band"):::projected v10("?bandLabel"):::projected v1("?geb"):::projected v5("?gebOrt") v12("?gebOrtLabel"):::projected v8("?genre") v11("?genreLabel"):::projected v16("?genres") v9("?img"):::projected v2("?land") v7("?mitglied") v14("?mitgliedLabel"):::projected v17("?mitglieder") v6("?type") v13("?typeLabel"):::projected v15("?types") a1((" ")) c12(["#91;AUTO_LANGUAGE#93;,en,fr"]):::literal c3(["wd:Q215380"]):::iri c10(["bd:serviceParam"]):::iri bind0[/VALUES ?land/] bind0-->v2 bind00(["wd:Q1005"]) bind00 --> bind0 bind01(["wd:Q1041"]) bind01 --> bind0 bind02(["wd:Q912"]) bind02 --> bind0 bind03(["wd:Q965"]) bind03 --> bind0 bind04(["wd:Q117"]) bind04 --> bind0 bind05(["wd:Q945"]) bind05 --> bind0 bind06(["wd:Q962"]) bind06 --> bind0 bind07(["wd:Q1008"]) bind07 --> bind0 bind08(["wd:Q1006"]) bind08 --> bind0 bind09(["wd:Q1044"]) bind09 --> bind0 bind010(["wd:Q1007"]) bind010 --> bind0 bind011(["wd:Q1014"]) bind011 --> bind0 bind1[/VALUES ?b/] bind1-->v3 bind10(["wdt:P740"]) bind10 --> bind1 bind11(["wdt:P495"]) bind11 --> bind1 bind12(["wdt:P27"]) bind12 --> bind1 v4 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v4 -->v3--> v2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P495".-> v5 end v4 --"wdt:P31"--> v6 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P527".-> v7 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P571".-> v1 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P136".-> v8 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P18".-> v9 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 v4 --"rdfs:label"--> v10 v8 --"rdfs:label"--> v11 v5 --"rdfs:label"--> v12 v6 --"rdfs:label"--> v13 v7 --"rdfs:label"--> v14 end bind5[/"?typeLabel"/] v13 --o bind5 bind5 --as--o v15 bind6[/"?genreLabel"/] v11 --o bind6 bind6 --as--o v16 bind7[/"?mitgliedLabel"/] v14 --o bind7 bind7 --as--o v17