Wikidata SPARQL GND: Difference between revisions
Appearance
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
SELECT ?id | SELECT ?id | ||
{ | { | ||
?item wdt:P31 wd:Q5. | |||
?item wdt:P227 ?id. | |||
?item wikibase:sitelinks ?sl. | |||
FILTER (?sl >= 1). | |||
} | |||
https://w.wiki/6oWr | |||
SELECT ?id | |||
{ | |||
?item wdt:P31 wd:Q5. | |||
?item wdt:P227 ?id. | |||
FILTER EXISTS { | |||
?article schema:about ?item . | |||
?article schema:isPartOf <https://de.wikipedia.org/> | |||
} | |||
} | |||
https://w.wiki/Rkt | |||
SELECT (COUNT(DISTINCT(?item)) AS ?count_item) (COUNT(DISTINCT(?id)) AS ?count_did) (COUNT(?id) AS ?count_id) | |||
{ | |||
?item wdt:P31 wd:Q5. | |||
?item wdt:P227 ?id. | |||
} | } | ||
Latest revision as of 2023-06-07T21:29:07
SELECT ?id
{
?item wdt:P31 wd:Q5.
?item wdt:P227 ?id.
?item wikibase:sitelinks ?sl.
FILTER (?sl >= 1).
}
SELECT ?id
{
?item wdt:P31 wd:Q5.
?item wdt:P227 ?id.
FILTER EXISTS {
?article schema:about ?item .
?article schema:isPartOf <https://de.wikipedia.org/>
}
}
SELECT (COUNT(DISTINCT(?item)) AS ?count_item) (COUNT(DISTINCT(?id)) AS ?count_did) (COUNT(?id) AS ?count_id)
{
?item wdt:P31 wd:Q5.
?item wdt:P227 ?id.
}