query-11c061915fff14e02369422c926841c7
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
WHERE
{
?article schema:about ?item .
?article schema:isPartOf <https://fr.wikipedia.org/> .
?item wikibase:sitelinks 60 .
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
wd:Q59259626 wd:Q19887878 wd:Q15647814 wd:Q23894246
wd:Q30432511 wd:Q11753321 wd:Q24046192 wd:Q4663903
wd:Q13331174 wd:Q59542487 }
?item wdt:P31 ?exclude . # exclude templates, project pages, modules, categories, portals
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?article"):::projected
v3("?exclude")
v2("?item"):::projected
a1((" "))
c6([https://en.wikipedia.org/]):::iri
c3([https://fr.wikipedia.org/]):::iri
c5(["60^^xsd:integer"]):::literal
v1 --"schema:about"--> v2
v1 --"schema:isPartOf"--> c3
v2 --"wikibase:sitelinks"--> c5
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
a1 --"schema:about"--> v2
a1 --"schema:isPartOf"--> c6
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
bind2[/VALUES ?exclude/]
bind2-->v3
bind20(["wd:Q11266439"])
bind20 --> bind2
bind21(["wd:Q20010800"])
bind21 --> bind2
bind22(["wd:Q15184295"])
bind22 --> bind2
bind23(["wd:Q14204246"])
bind23 --> bind2
bind24(["wd:Q59541917"])
bind24 --> bind2
bind25(["wd:Q36330215"])
bind25 --> bind2
bind26(["wd:Q4167836"])
bind26 --> bind2
bind27(["wd:Q23894233"])
bind27 --> bind2
bind28(["wd:Q59259626"])
bind28 --> bind2
bind29(["wd:Q19887878"])
bind29 --> bind2
bind210(["wd:Q15647814"])
bind210 --> bind2
bind211(["wd:Q23894246"])
bind211 --> bind2
bind212(["wd:Q30432511"])
bind212 --> bind2
bind213(["wd:Q11753321"])
bind213 --> bind2
bind214(["wd:Q24046192"])
bind214 --> bind2
bind215(["wd:Q4663903"])
bind215 --> bind2
bind216(["wd:Q13331174"])
bind216 --> bind2
bind217(["wd:Q59542487"])
bind217 --> bind2
v2 --"wdt:P31"--> v3
end