query-d0523b14eb0dfb4f757290524bd35f7b

rq turtle/ttl

title:list of recorded track from one specific composition, and all the releases (single/album, etc.) where using SELECT DISTINCT ?item ?itemLabel ?tipusLabel ?interpret ?interpretLabel ?album ?albumLabel ?pista ?data_publi (GROUP_CONCAT(DISTINCT ?productorLabel; separator=", ") AS ?productors ) WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?itemLabel . ?tipus rdfs:label ?tipusLabel . ?interpret rdfs:label ?interpretLabel. ?album rdfs:label ?albumLabel . ?productor rdfs:label ?productorLabel. } ?item wdt:P2550 wd:Q1550581. OPTIONAL { ?item wdt:P31 ?tipus_trk. } OPTIONAL { ?item wdt:P175 ?interpret. } OPTIONAL { ?item wdt:P10135 ?data_enreg. } OPTIONAL { ?item wdt:P483 ?gravat_a. } OPTIONAL { ?item wdt:P162 ?productor. } OPTIONAL { ?album p:P658 ?statement. ?statement ps:P658 ?item. OPTIONAL {?statement pq:P1545 ?pista_ord.} OPTIONAL {?statement pq:P3831 ?pista_rol.} OPTIONAL { ?album wdt:P31 ?tipus_rls. } OPTIONAL { ?album wdt:P577 ?data_publi. } OPTIONAL { ?album wdt:P437 ?format_dist. } } BIND(IF(BOUND(?tipus_rls), ?tipus_rls, ?tipus_trk ) as ?tipus). BIND(IF(BOUND(?pista_ord), ?pista_ord, ?pista_rol) as ?pista). } GROUP BY ?item ?itemLabel ?tipusLabel ?interpret ?interpretLabel ?album ?albumLabel ?pista ?data_publi

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:list of recorded track from one specific composition, and all the releases (single/album, etc.) where using
SELECT DISTINCT ?item ?itemLabel ?tipusLabel ?interpret ?interpretLabel ?album ?albumLabel ?pista ?data_publi 
                 (GROUP_CONCAT(DISTINCT ?productorLabel; separator=", ") AS ?productors ) WHERE
{
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". 
                         ?item rdfs:label ?itemLabel . 
                         ?tipus rdfs:label ?tipusLabel .
                         ?interpret rdfs:label ?interpretLabel. 
                         ?album  rdfs:label  ?albumLabel .
                         ?productor rdfs:label ?productorLabel.
                         }
  ?item wdt:P2550 wd:Q1550581.
  OPTIONAL { ?item wdt:P31 ?tipus_trk. }
  OPTIONAL { ?item wdt:P175 ?interpret. }
  OPTIONAL { ?item wdt:P10135 ?data_enreg. }
  OPTIONAL { ?item wdt:P483 ?gravat_a. }
  OPTIONAL { ?item wdt:P162 ?productor. }
  OPTIONAL { ?album p:P658 ?statement.
       ?statement ps:P658 ?item.
       OPTIONAL {?statement pq:P1545 ?pista_ord.}
       OPTIONAL {?statement pq:P3831 ?pista_rol.}
       OPTIONAL { ?album wdt:P31 ?tipus_rls. }
       OPTIONAL { ?album wdt:P577 ?data_publi. }
       OPTIONAL { ?album wdt:P437 ?format_dist. }
           }
  BIND(IF(BOUND(?tipus_rls), ?tipus_rls, ?tipus_trk )
           as ?tipus).
  BIND(IF(BOUND(?pista_ord), ?pista_ord, ?pista_rol)
           as ?pista).
}
GROUP BY ?item ?itemLabel ?tipusLabel ?interpret ?interpretLabel ?album ?albumLabel ?pista ?data_publi

Query found at