PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
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#>
# Llista de titulars d'un títol (P97) de comte català + els seus P39-Càrrec
SELECT ?item ?itemLabel ?carrecLabel
?ini ?fi
?ant ?antLabel ?seg ?segLabel
?titolLabel
?ini_T ?fi_T ?ant_T ?ant_TLabel ?seg_T ?seg_TLabel ?imatge
# ?pointInTime ?ordre 
WHERE {
  VALUES ?carrec {
      wd:Q38673587
      wd:Q60732050
      wd:Q1541699
      wd:Q1541813
      wd:Q2037817
      wd:Q1541642
      wd:Q1541642
      wd:Q1514510
      wd:Q956729
      wd:Q657448
      wd:Q2338948
      wd:Q1541779
      wd:Q1541787
      wd:Q1297894
    }
  VALUES ?titol {
      wd:Q38673587
      wd:Q60732050
      wd:Q1541699
      wd:Q1541813
      wd:Q2037817
      wd:Q1541642
      wd:Q1541642
      wd:Q1514510
      wd:Q956729
      wd:Q657448
      wd:Q2338948
      wd:Q1541779
      wd:Q1541787
      wd:Q1297894
    }
  ?item p:P97 ?p97stm.
  ?p97stm ps:P97 ?titol.
  OPTIONAL { ?p97stm pq:P580 ?ini_T. }
  OPTIONAL { ?p97stm pq:P582 ?fi_T. }
  OPTIONAL { ?p97stm pq:P1365 ?ant_T. }
  OPTIONAL { ?p97stm pq:P1366 ?seg_T. }
  OPTIONAL {?item p:P39 ?p39stm.}
  ?p39stm ps:P39 ?carrec.
#  OPTIONAL { ?p39stm pq:P585 ?pointInTime. }
  OPTIONAL { ?p39stm pq:P580 ?ini. }
  OPTIONAL { ?p39stm pq:P582 ?fi. }
  OPTIONAL { ?p39stm pq:P1365 ?ant. }
  OPTIONAL { ?p39stm pq:P1366 ?seg. }
#  OPTIONAL { ?p39stm pq:P1545 ?ordre. }

  OPTIONAL { ?item wdt:P18 ?imatge. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?inici)
LIMIT 100

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v13("?ant"):::projected v8("?ant_T"):::projected v2("?carrec") v12("?fi"):::projected v7("?fi_T"):::projected v15("?imatge"):::projected v11("?ini"):::projected v6("?ini_T"):::projected v1("?inici") v4("?item"):::projected v10("?p39stm") v5("?p97stm") v14("?seg"):::projected v9("?seg_T"):::projected v3("?titol") c11(["bd:serviceParam"]):::iri c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal bind0[/VALUES ?carrec/] bind0-->v2 bind00(["wd:Q38673587"]) bind00 --> bind0 bind01(["wd:Q60732050"]) bind01 --> bind0 bind02(["wd:Q1541699"]) bind02 --> bind0 bind03(["wd:Q1541813"]) bind03 --> bind0 bind04(["wd:Q2037817"]) bind04 --> bind0 bind05(["wd:Q1541642"]) bind05 --> bind0 bind06(["wd:Q1541642"]) bind06 --> bind0 bind07(["wd:Q1514510"]) bind07 --> bind0 bind08(["wd:Q956729"]) bind08 --> bind0 bind09(["wd:Q657448"]) bind09 --> bind0 bind010(["wd:Q2338948"]) bind010 --> bind0 bind011(["wd:Q1541779"]) bind011 --> bind0 bind012(["wd:Q1541787"]) bind012 --> bind0 bind013(["wd:Q1297894"]) bind013 --> bind0 bind1[/VALUES ?titol/] bind1-->v3 bind10(["wd:Q38673587"]) bind10 --> bind1 bind11(["wd:Q60732050"]) bind11 --> bind1 bind12(["wd:Q1541699"]) bind12 --> bind1 bind13(["wd:Q1541813"]) bind13 --> bind1 bind14(["wd:Q2037817"]) bind14 --> bind1 bind15(["wd:Q1541642"]) bind15 --> bind1 bind16(["wd:Q1541642"]) bind16 --> bind1 bind17(["wd:Q1514510"]) bind17 --> bind1 bind18(["wd:Q956729"]) bind18 --> bind1 bind19(["wd:Q657448"]) bind19 --> bind1 bind110(["wd:Q2338948"]) bind110 --> bind1 bind111(["wd:Q1541779"]) bind111 --> bind1 bind112(["wd:Q1541787"]) bind112 --> bind1 bind113(["wd:Q1297894"]) bind113 --> bind1 v4 --"p:P97"--> v5 v5 --"p:statement/P97"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P580".-> v6 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P582".-> v7 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P1365".-> v8 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P1366".-> v9 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:P39".-> v10 end v10 --"p:statement/P39"--> v2 subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v10 -."p:qualifier/P580".-> v11 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v10 -."p:qualifier/P582".-> v12 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v10 -."p:qualifier/P1365".-> v13 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v10 -."p:qualifier/P1366".-> v14 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P18".-> v15 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end