query-b5b6446bc2940a3ac579c189ceb2f89d

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?okresLabel ?pocet
WHERE {
  ?item wdt:P31 wd:Q811534 .
  ?item wdt:P17 wd:Q213 .
  ?item wdt:P677 ?USOP . 
  {?item wdt:P131/wdt:P131 ?okres .}
  OPTIONAL{ ?item p:P527/pq:P1114 ?pocet .}
  FILTER (?pocet>1)
  #?item wdt:P131/wdt:P131 wd:Q579648 .         #Okres ZR
  FILTER regex(?USOP, "106049|106055|106086|106095|106094|106078|105947|106102|106101|106103|106114|105884|105990|105977|105882|105958|105975|105976|105991|105928|106060|105893|106070|106071|106127|105943|105944|106044|105883|106087|105945|105935|105996|106007|106010|106092|105921|106061|106063|105880|14672|106043|105931|106072|106085|105951|106106|105962|106042|106019|106024|106023|106031|106112|105992|105842|105879|105956|105913|105911|105912|105933|105901|105940|106068|106109|105936|105938|105937|106057|106062|106124|105878|106032|106034|106033|105919|105906|105918|105905|105952|105949|106111|105881|105954|105953|105955|103731|103714|106082|106022|106005|106121|106123|105902|105989|106118|103822|105907|106089|106091|106100|105891|105968|105967|105969|105970|106014|106020|105916|106069|106125|106065|105988|105053|104628|104928|104627|105118|104860|105114|105732|105734|103943|103937|103949|103950|103946|103947|103951|103954|103953|103968|103998|103994|103995|105535|105892|106036|106035|105948|106048|105965|106008|106009|105900|106058|106113|105966|105934|105930|106084|105899|106051|106046|106050|106056|105939|105874|106030|106028|106029|105917|106090|105972|106079|106088|105946|105973|106052|106081|102091|106126|105909|105910|106080|106107|106108|106116|106117|105873|105877|105886|105887|105885|105890|105888|105889|105960|105959|105301|106110|105974|103215|106045|106054|105876|106006|106073|105929|106064|106067|105897|105896|106040|105961|106025|106041|106099|106038|106115|105923|105924|105927|105925|105926|105932|106096|106083|106003|106105|104271") 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" }
}
#ORDER BY (?itemLabel)
ORDER BY DESC(?okresLabel)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?USOP") v4("?item"):::projected v5("?okres") v1("?okresLabel"):::projected v3("?pocet"):::projected a1((" ")) a2((" ")) c4(["wd:Q811534"]):::iri c14(["cs"]):::literal c6(["wd:Q213"]):::iri c12(["bd:serviceParam"]):::iri f0[["regex(?USOP,'106049|106055|106086|106095|106094|106078|105947|106102|106101|106103|106114|105884|105990|105977|105882|105958|105975|105976|105991|105928|106060|105893|106070|106071|106127|105943|105944|106044|105883|106087|105945|105935|105996|106007|106010|106092|105921|106061|106063|105880|14672|106043|105931|106072|106085|105951|106106|105962|106042|106019|106024|106023|106031|106112|105992|105842|105879|105956|105913|105911|105912|105933|105901|105940|106068|106109|105936|105938|105937|106057|106062|106124|105878|106032|106034|106033|105919|105906|105918|105905|105952|105949|106111|105881|105954|105953|105955|103731|103714|106082|106022|106005|106121|106123|105902|105989|106118|103822|105907|106089|106091|106100|105891|105968|105967|105969|105970|106014|106020|105916|106069|106125|106065|105988|105053|104628|104928|104627|105118|104860|105114|105732|105734|103943|103937|103949|103950|103946|103947|103951|103954|103953|103968|103998|103994|103995|105535|105892|106036|106035|105948|106048|105965|106008|106009|105900|106058|106113|105966|105934|105930|106084|105899|106051|106046|106050|106056|105939|105874|106030|106028|106029|105917|106090|105972|106079|106088|105946|105973|106052|106081|102091|106126|105909|105910|106080|106107|106108|106116|106117|105873|105877|105886|105887|105885|105890|105888|105889|105960|105959|105301|106110|105974|103215|106045|106054|105876|106006|106073|105929|106064|106067|105897|105896|106040|105961|106025|106041|106099|106038|106115|105923|105924|105927|105925|105926|105932|106096|106083|106003|106105|104271')"]] f0 --> v2 f1[["?pocet > '1^^xsd:integer'"]] f1 --> v3 v4 --"p:direct/P31"--> c4 v4 --"p:direct/P17"--> c6 v4 --"p:direct/P677"--> v2 v4 --"p:direct/P131"--> a1 a1 --"p:direct/P131"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:P527".-> a2 a2 --"p:qualifier/P1114"--> v3 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end