query-71d6c78b515b497489e5e060d1d74a92
Remi Mathis
Use at
- https://query.wikidata.org/sparql
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/>
SELECT ?item ?article ?sitelinks
WHERE
{
{
SELECT ?item ?article ?sitelinks
WHERE
{
?article schema:about ?item .
?article schema:isPartOf <https://fr.wikipedia.org/> .
?item wikibase:sitelinks ?sitelinks .
FILTER (?sitelinks >= 100)
}
} MINUS
{
[] schema:about ?item ; schema:isPartOf <https://en.wikipedia.org/> .
}
MINUS
{
VALUES ?exclude { wd:Q11266439 wd:Q20010800 wd:Q15184295 wd:Q14204246
wd:Q59541917 wd:Q36330215 wd:Q4167836 wd:Q23894233 }
?item wdt:P31 ?exclude . # exclude templates, project pages, modules, categories
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?article"):::projected
v4("?exclude")
v3("?item"):::projected
v1("?sitelinks"):::projected
a1((" "))
c6([https://en.wikipedia.org/]):::iri
c4([https://fr.wikipedia.org/]):::iri
f0[["?sitelinks >= '100^^xsd:integer'"]]
f0 --> v1
v2 --"schema:about"--> v3
v2 --"schema:isPartOf"--> c4
v3 --"wikibase:sitelinks"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
a1 --"schema:about"--> v3
a1 --"schema:isPartOf"--> c6
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
bind3[/VALUES ?exclude/]
bind3-->v4
bind30(["wd:Q11266439"])
bind30 --> bind3
bind31(["wd:Q20010800"])
bind31 --> bind3
bind32(["wd:Q15184295"])
bind32 --> bind3
bind33(["wd:Q14204246"])
bind33 --> bind3
bind34(["wd:Q59541917"])
bind34 --> bind3
bind35(["wd:Q36330215"])
bind35 --> bind3
bind36(["wd:Q4167836"])
bind36 --> bind3
bind37(["wd:Q23894233"])
bind37 --> bind3
v3 --"wdt:P31"--> v4
end