query-686a08622dd115c9c55513e14cb4cd21
Или в русском:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?cat ?catLabel ?cnt ?lems where {
{SELECT ?cat (count(*) as ?cnt) (GROUP_CONCAT(DISTINCT ?lem; SEPARATOR=", ") AS ?lems) WHERE {
?l <http://purl.org/dc/terms/language> wd:Q7737.
?l wikibase:lexicalCategory ?cat.
MINUS { ?l wikibase:lexicalCategory wd:Q1084 }
?l wikibase:lemma ?lem.
} group by ?cat}
SERVICE wikibase:label { bd:serviceParam wikibase:language "ru". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?cat"):::projected
v4("?cnt"):::projected
v1("?l")
v3("?lem")
v5("?lems"):::projected
c7(["bd:serviceParam"]):::iri
c9(["ru"]):::literal
c4(["wd:Q1084"]):::iri
c2(["wd:Q7737"]):::iri
v1 --http://purl.org/dc/terms/language--> c2
v1 --"wikibase:lexicalCategory"--> v2
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wikibase:lexicalCategory"--> c4
end
v1 --"wikibase:lemma"--> v3
bind3[/"count(*)"/]
bind3 --as--o v4
bind4[/"?lem"/]
v3 --o bind4
bind4 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end