query-72e9a3f39e3978d4e3359d4d7870956b
OtherDisambiguation pages with the same name.
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?item ?item2 (SAMPLE(?iLabel) AS ?label)
WHERE
{
?item2 wdt:P31/wdt:P279* wd:Q4167410;
wikibase:sitelinks 1 ;
rdfs:label ?iLabel.
#?sitelinkfi schema:isPartOf <https://sv.wikipedia.org/>;
# schema:about ?item2.
?item wdt:P31/wdt:P279* wd:Q4167410;
rdfs:label ?iLabel.
FILTER(?item != ?item2)
FILTER(xsd:integer(STRAFTER(STR(?item2), 'www.wikidata.org/entity/Q')) > 100000000)
}
GROUP BY ?item ?item2
ORDER BY DESC(?item2)
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?iLabel"):::projected
v2("?item"):::projected
v1("?item2"):::projected
v4("?label")
a1((" "))
a2((" "))
c7(["1^^xsd:integer"]):::literal
c5(["wd:Q4167410"]):::iri
f0[["http://www.w3.org/2001/XMLSchema#integer(substring-after(str(?item2),'www.wikidata.org/entity/Q')) > '100000000^^xsd:integer'"]]
f0 --> v1
f1[["?item != ?item2"]]
f1 --> v2
f1 --> v1
v1 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c5
v1 --"wikibase:sitelinks"--> c7
v1 --"rdfs:label"--> v3
v2 --"wdt:P31"--> a2
a2 --"wdt:P279"--> c5
v2 --"rdfs:label"--> v3
bind3[/"sample(?iLabel)"/]
v3 --o bind3
bind3 --as--o v4