Wikidata SPARQL: People with VIAFs and notable works, without OLIDs

authors.sparql

#People with VIAFs and notable works, without OLIDs

SELECT ?author (SAMPLE(?authorLabel) AS ?authorLabel)
  (SAMPLE(?dob) AS ?dob) (SAMPLE(?dod) AS ?dod)
  (SAMPLE(?viaf) AS ?viaf) (COUNT(?notable) AS ?works) WHERE {
  ?author wdt:P31 wd:Q5;
          wdt:P800 ?notable;
          rdfs:label ?authorLabel;
          wdt:P214 ?viaf;
          wdt:P569 ?dob;
          wdt:P570 ?dod.
          # wdt:P648 ?olid.

  FILTER NOT EXISTS { ?author wdt:P648 ?olid }
  FILTER (langMatches( lang(?authorLabel), "EN" ) )
  #SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
  #FILTER regex (?authorLabel, ".").
}
GROUP BY ?author
ORDER BY DESC(?works)
LIMIT 2000