query-f16e10255fc55dcf814ac64ff44fceb4
Items that are instance of (P31) human (Q5) with sitelink to redirect (Q70893996) in enwiki 13:11, 25 November 2022 (UTC)❫ ✉ ❪ChristianKl into enwiki. (Q70894304)intentional sitelink to redirect into enwiki but not with (Q70893996)sitelink to redirect that have sidelinks with (Q5)human (P31)instance of I'd love to have a query that shows all
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?name ?sitelink WHERE {
?sitelink schema:about ?item; schema:isPartOf <https://en.wikipedia.org/>; schema:name ?name; wikibase:badge wd:Q70893996 .
?item wdt:P31 wd:Q5 .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v3("?name"):::projected
v1("?sitelink"):::projected
c3([https://en.wikipedia.org/]):::iri
c10(["bd:serviceParam"]):::iri
c8(["wd:Q5"]):::iri
c12(["en"]):::literal
c6(["wd:Q70893996"]):::iri
v1 --"schema:about"--> v2
v1 --"schema:isPartOf"--> c3
v1 --"schema:name"--> v3
v1 --"wikibase:badge"--> c6
v2 --"wdt:P31"--> c8
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end