Wikidata SPARQL GND: Difference between revisions

From annawiki
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:P31 wd:Q5.
?item wdt:P227 ?id.  
  ?item wdt:P227 ?id.  
?item wikibase:sitelinks ?sl .
  ?item wikibase:sitelinks ?sl.
FILTER (?sl >= 1) .
  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-07T22:29:07

https://w.wiki/6oWf

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.  
}