query-c9ef84c1ad58ac0bb984e0e4e1ba675f

All category that include a given string PREFIX schema: http://schema.org/

SELECT ?item ?LabelES WHERE { ?item wdt:P31 wd:Q4167836. ?sitelink schema:about ?item. ?sitelink schema:isPartOf https://or.wikipedia.org/. ?sitelink schema:name ?LabelES. FILTER(REGEX(?LabelES, "^ଶ୍ରେଣୀ:ଓଡ଼ିଶାର .*")) } LIMIT 123

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
# All category that include a given string 
PREFIX schema: <http://schema.org/>

SELECT ?item ?LabelES WHERE {
  ?item wdt:P31 wd:Q4167836.
  ?sitelink schema:about ?item.
  ?sitelink schema:isPartOf <https://or.wikipedia.org/>.
  ?sitelink schema:name ?LabelES.
  FILTER(REGEX(?LabelES, "^ଶ୍ରେଣୀ:ଓଡ଼ିଶାର .*"))
}
LIMIT 123

Query found at

https://www.wikidata.org/wiki/User:MKar/Query

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?LabelES"):::projected v2("?item"):::projected v3("?sitelink") c3(["wd:Q4167836"]):::iri c6([https://or.wikipedia.org/]):::iri f0[["regex(?LabelES,'^ଶ୍ରେଣୀ:ଓଡ଼ିଶାର .*')"]] f0 --> v1 v2 --"wdt:P31"--> c3 v3 --"schema:about"--> v2 v3 --"schema:isPartOf"--> c6 v3 --"schema:name"--> v1