query-ebe866a85a1ea5a22098acbdcafdaee0

rq turtle/ttl

TODO

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT ?item ?linkcount ?_articleEN ?born
WHERE
{
  ?item wdt:P31 wd:Q5 ; wdt:P569 ?born .
  # person with birthdate
  FILTER (?born >= "1920-01-01T00:00:00Z"^^xsd:dateTime) .
  # birthdate on or after 1/1/1920
  FILTER (?born < "1930-01-01T00:00:00Z"^^xsd:dateTime) .
  # birthdate before 1/1/1930
  ?_articleEN schema:about ?item. ?_articleEN schema:isPartOf <https://en.wikipedia.org/>.
  # has an enwiki article
  filter not exists { ?_articleHE schema:about ?item. ?_articleHE schema:isPartOf <https://he.wikipedia.org/>. }
  # does not have hewiki article
  ?item wikibase:sitelinks ?linkcount .
  # how many sitelinks has it got?
} order by desc(?linkcount)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?_articleEN"):::projected v2("?_articleHE") v4("?born"):::projected v3("?item"):::projected v1("?linkcount"):::projected c9([https://en.wikipedia.org/]):::iri c3([https://he.wikipedia.org/]):::iri c7(["wd:Q5"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"schema:about"--> e0v2 e0v1 --"schema:isPartOf"--> e0c3 e0v1("?_articleHE"):::projected e0v2("?item"):::projected e0c3([https://he.wikipedia.org/]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> v3 f0 --> c2 f0 --> c3 v2 --"schema:about"--> v3 v2 --"schema:isPartOf"--> c3 f1[["?born < '1930-01-01T00:00:00Z^^xsd:dateTime'"]] f1 --> v4 f2[["?born >= '1920-01-01T00:00:00Z^^xsd:dateTime'"]] f2 --> v4 v3 --"wdt:P31"--> c7 v3 --"wdt:P569"--> v4 v5 --"schema:about"--> v3 v5 --"schema:isPartOf"--> c9 v3 --"wikibase:sitelinks"--> v1