query-53f2b7c26575c94b61465d21bf82c630
Écrivains français sans lien BnF : (P268)Bibliothèque nationale de France ID French writer born after 1800 and without a
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT distinct ?s ?writer ?born ?linkcount
WHERE
{
{?s wdt:P106 wd:Q36180 .} UNION { ?s wdt:P106 wd:Q482980 . } UNION { ?s wdt:P106 wd:Q49757 . }
?s wdt:P27 wd:Q142 .
?s wikibase:sitelinks ?linkcount .
MINUS { ?s wdt:P268 [] }.
?s wdt:P569 ?born .
FILTER (?born >= "1800-01-01T00:00:00Z"^^xsd:dateTime) .
OPTIONAL {
?s rdfs:label ?writer filter (lang(?writer) = "fr").
}
} GROUP BY ?s ?writer ?born ?linkcount HAVING (?linkcount > 1) ORDER BY DESC(?linkcount)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?born"):::projected
v1("?linkcount"):::projected
v4("?s"):::projected
v3("?writer"):::projected
a1((" "))
c7(["wd:Q49757"]):::iri
c5(["wd:Q36180"]):::iri
c6(["wd:Q482980"]):::iri
c9(["wd:Q142"]):::iri
f0[["?linkcount > '1^^xsd:integer'"]]
f0 --> v1
f1[["?born >= '1800-01-01T00:00:00Z^^xsd:dateTime'"]]
f1 --> v2
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P106"--> c7
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P106"--> c6
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v4 --"wdt:P106"--> c5
end
union0r <== or ==> union0l
end
v4 --"wdt:P27"--> c9
v4 --"wikibase:sitelinks"--> v1
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v4 --"wdt:P268"--> a1
end
v4 --"wdt:P569"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."rdfs:label".-> v3
end