User:MargaretRDonald/MarieCurietimelineAndVolcanoes

SELECT ?item ?itemLabel ?apni_id ?article ?sitelink
WHERE 
{
  {
    ?item wdt:P5984 ?apni_id.
    ?sitelink ^schema:name ?article .
    ?article schema:about ?item ;
             schema:isPartOf <https://en.wikipedia.org/> .
  }
  #MINUS
  {
    SERVICE wikibase:mwapi
    {
      bd:serviceParam wikibase:api "Search" .
      bd:serviceParam wikibase:endpoint "en.wikipedia.org" .
      bd:serviceParam mwapi:srnamespace "0" .
      bd:serviceParam mwapi:srlimit "max" .
      bd:serviceParam mwapi:srwhat "text" .
      bd:serviceParam mwapi:srsearch 'insource:"Noongar Bush Medicine Medicinal plants"' .
      ?title wikibase:apiOutput mwapi:title .
    }
    BIND (STRLANG(?title, "en") as ?sitelink)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

This times out

Partially failed stuff edit

APNI optional NTFlora starting with P

Examples from JarrahTree edit

- Query examples:
  - All deaths in Game of Thrones (source)
  - Wikidata knows of at least 5263 buildings started before Notre Dame de Paris (query based on this discussion)
  - Timeline for the History of Telecommunications (source)
  - Graph of London Tube stations that are on at least three lines (source)
  - Map of churches in Sri Lanka (source)

Examples from help edit

Goats Goats

Horses with birthyear Horses: parents, birth & death years

Most used properties for poems Most used properties for poems

User 99of9's queries edit

parent taxa of Christmas Island red crabs

properties which are instances of a particular item, here "Wikidata property for items about works"

Australian Science age & details

Chemical compounds with the least, most statements
mass vs boiling point (ignores units) with units Celsius only
copublishers COE journals
author name
properties for diseases
properties for compounds full count for a specific property
ceb suburbs with no ssc
Aussie OSM relations for use with Kartographer maps example: w:Coburg, Victoria
USA newspapers missing USNPL ID map global map by sitelinks en-wiki infoboxes infoboxes joined to USNPL
Trove Australia newspaper wiki coverage

Failed queries edit

Women alumni of Sydney U edit

# select Australian women who have an enwiki article and are said to be usyd alumni
# but wikidata does not assert "educated at Sydney Uni"
SELECT ?item ?itemLabel  ?article ?sitelink
WHERE 
{
  {
    ?item wdt:P21 wd:Q6581072. # is a woman
    ?item wdt:P27 wd:Q408.     # Is Australian
    ?sitelink ^schema:name ?article .
    ?article schema:about ?item ;
             schema:isPartOf <https://en.wikipedia.org/> .
  }
MINUS    { ?item wdt:P69 wd:Q487556.  # educated at Sydney University
           ?item wdt:P21 wd:Q6581072. # is a woman
           ?item wdt:P27 wd:Q408.     # Is Australian
          } 
  {
    SERVICE wikibase:mwapi
    {
      bd:serviceParam wikibase:api "Search" .
      bd:serviceParam wikibase:endpoint "en.wikipedia.org" .
      bd:serviceParam mwapi:srnamespace "0" .
      bd:serviceParam mwapi:srlimit "max" .
      bd:serviceParam mwapi:srwhat "text" .
      bd:serviceParam mwapi:srsearch 'insource:"Category:University of Sydney alumni"' .
      ?title wikibase:apiOutput mwapi:title .
    }
    BIND (STRLANG(?title, "en") as ?sitelink)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 10

Try it!

Query times out

User:MargaretRDonald/MarieCurietimelineAndVolcanoes

Wikidata SPARQL tutorial edit

Margaret's Queries edit

Conferences edit

BHL proposal for Nicole Kearney edit

Miscellaneous edit

Wikimedia wikidata proposal 2022 edit

Wikidata fellowship blog edit

Scottish witches edit

Miscellaneous queries edit

Other biota edit

Art works edit

Humans edit

Mapping edit

Plants etc edit

Partially failed stuff edit

Examples from JarrahTree edit

Examples from help edit

User 99of9's queries edit

Failed queries edit

Women alumni of Sydney U edit