query-e454b8913858e0ad41094c08dff13e94

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?item ?itemLabel ?desc ?nkcr where {

   {
  select * where {
    ?item wdt:P691 ?nkcr .
    bind(substr(str(?item),33) as ?no ).

  } order by desc(xsd:integer(?no)) limit 500 
}  optional {?item schema:description ?desccs filter(lang(?desccs)="cs" ). }
  optional {?item schema:description ?descen filter(lang(?descen)="en" ). }
  bind(coalesce(?desccs,?descen) as ?desc) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs,en,de,nl,ru". }
} order by desc(xsd:integer(?no))

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?desc"):::projected v3("?desccs") v2("?descen") v4("?item"):::projected v5("?nkcr"):::projected v6("?no") c6(["bd:serviceParam"]):::iri c8(["cs,en,de,nl,ru"]):::literal v4 --"wdt:P691"--> v5 bind0[/"substring(str(?item),'33^^xsd:integer')"/] v4 --o bind0 bind0 --as--o v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:description".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:description".-> v2 end bind1[/"?desccs?descen"/] v3 --o bind1 v2 --o bind1 bind1 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end