query-0592202ff68a52b423303871ba4e90c4
title:Tipograf* con Id Cerl ma senza Id Edit16 SELECT DISTINCT ?item ?itemLabel ?itemdesc (URI(CONCAT("https://data.cerl.org/thesaurus/",?cerlid))as ?cerlurl) #?datainizio ?datafine WHERE { ?item wdt:P1871 ?cerlid; wdt:P106 ?activity; schema:description ?itemdesc. {?item wdt:P2031 ?datainizio} UNION {?item wdt:P569 ?datainizio} {?item wdt:P2032 ?datafine} UNION {?item wdt:P570 ?datafine} values ?activity { wd:Q175151 wd:Q1229025 wd:Q998550 wd:Q2516866 wd:Q40881196 }
FILTER ("1620-01-01"^^xsd:dateTime > ?datafine)
FILTER ("1480-01-01"^^xsd:dateTime < ?datainizio)
FILTER((LANG(?itemdesc)) = "it")
FILTER(CONTAINS(STR(?itemdesc), "italiano"))
MINUS {{ ?item wdt:P5493 ?edit16} UNION {?item wdt:P5492 ?edit16. }}
SERVICE wikibase:label { bd:serviceParam wikibase:language "it". } }
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Tipograf* con Id Cerl ma senza Id Edit16
SELECT DISTINCT ?item ?itemLabel ?itemdesc (URI(CONCAT("https://data.cerl.org/thesaurus/",?cerlid))as ?cerlurl) #?datainizio ?datafine
WHERE
{ ?item wdt:P1871 ?cerlid; wdt:P106 ?activity; schema:description ?itemdesc.
{?item wdt:P2031 ?datainizio} UNION {?item wdt:P569 ?datainizio}
{?item wdt:P2032 ?datafine} UNION {?item wdt:P570 ?datafine}
values ?activity { wd:Q175151 wd:Q1229025 wd:Q998550 wd:Q2516866 wd:Q40881196 }
FILTER ("1620-01-01"^^xsd:date > ?datafine)
FILTER ("1480-01-01"^^xsd:date < ?datainizio)
FILTER((LANG(?itemdesc)) = "it")
FILTER(CONTAINS(STR(?itemdesc), "italiano"))
MINUS {{ ?item wdt:P5493 ?edit16} UNION {?item wdt:P5492 ?edit16. }}
SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?activity")
v5("?cerlid"):::projected
v8("?cerlurl")
v3("?datafine")
v2("?datainizio")
v7("?edit16")
v4("?item"):::projected
v1("?itemdesc"):::projected
c2(["it"]):::literal
c15(["bd:serviceParam"]):::iri
f0[["contains(str(?itemdesc),'italiano')"]]
f0 --> v1
f1[["?itemdesc = 'it'"]]
f1 --> v1
f2[["'1480-01-01^^xsd:date' < ?datainizio"]]
f2 --> v2
f3[["'1620-01-01^^xsd:date' > ?datafine"]]
f3 --> v3
v4 --"wdt:P1871"--> v5
v4 --"wdt:P106"--> v7
v4 --"schema:description"--> v1
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P569"--> v2
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P2031"--> v2
end
union0r <== or ==> union0l
end
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P570"--> v3
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P2032"--> v3
end
union1r <== or ==> union1l
end
bind4[/VALUES ?activity/]
bind4-->v7
bind40(["wd:Q175151"])
bind40 --> bind4
bind41(["wd:Q1229025"])
bind41 --> bind4
bind42(["wd:Q998550"])
bind42 --> bind4
bind43(["wd:Q2516866"])
bind43 --> bind4
bind44(["wd:Q40881196"])
bind44 --> bind4
subgraph minus5["MINUS"]
style minus5 stroke-width:6px,fill:pink,stroke:red;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P5492"--> v7
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P5493"--> v7
end
union2r <== or ==> union2l
end
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c15 --"wikibase:language"--> c2
end
bind6[/"concat('https://data.cerl.org/thesaurus/',?cerlid)"/]
v5 --o bind6
bind6 --as--o v8