User:AHendriksen-collecties/sandbox

queries --AHendriksen-collecties (talk) 09:17, 8 February 2022 (UTC)And which files have no depicts P180 yet?

The following query uses these:

• Properties: depicts (P180)   

  SELECT ?file ?title ?depicts ?depicts_label
  WITH
  {
    SELECT ?file ?title
    WHERE
    {
      SERVICE wikibase:mwapi
      {
        bd:serviceParam wikibase:api "Generator" .
        bd:serviceParam wikibase:endpoint "commons.wikimedia.org" .
        bd:serviceParam mwapi:gcmtitle "Category:Historia Naturalis van Rudolf II" .
        bd:serviceParam mwapi:generator "categorymembers" .
        bd:serviceParam mwapi:gcmtype "file" .
        bd:serviceParam mwapi:gcmlimit "max" .
        ?title wikibase:apiOutput mwapi:title .
        ?pageid wikibase:apiOutput "@pageid" .
      }
      BIND (URI(CONCAT('https://commons.wikimedia.org/entity/M', ?pageid)) AS ?file)
    }
  } AS %get_files
  WHERE
   
  {
    INCLUDE %get_files
    FILTER NOT EXISTS {
    ?file wdt:P180 ?depicts .
  

Try it!

biologen

1. Nederlands bioloog/taxonoom/entomoloog/botanicus/zooloog met/zonder EN/NL Wikipedia-artikel en/of codes external identifier

https://w.wiki/5W6n AHendriksen-collecties (talk) 12:55, 26 July 2022 (UTC)