query-c967413de4bb508bb8fb4fd61236ae14

rq turtle/ttl

12:57, 3 September 2016 (UTC) Jura--- would allow to do the same by identifier. Phab:T144476 goes live, you can select by number of sitelinks more easily. phab:T129046If you add the above, you will get the most recent ones. If you wait a couple of days till Your query modified to have n° of sitelink, filtered for n° of sitelink > 4 and sort for n° of sitelink in desc. order . But we have a time out. I don't know if is possible some optimization. 12:58, 3 September 2016 (UTC)) talk (ValterVB, more or less do what you want. --this ListeriaBot listYou can see the query in

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 bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>
SELECT ?item ?itemLabel ?professionLabel ?born (COUNT(distinct ?sitelink) as ?count)
WHERE {
  ?item wdt:P21 wd:Q6581072.
  ?item wdt:P106 ?profession.
  ?profession wdt:P279* wd:Q3391743.
  ?item wdt:P569 ?born .
  ?sitelink schema:about ?item .

  FILTER (?born > "1900-01-01T00:00:00Z"^^xsd:dateTime) .
  FILTER NOT EXISTS { ?wfr schema:about ?item . ?wfr schema:inLanguage "nl" }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "nl,en,fr,de". }
  OPTIONAL {
    ?wiki0 schema:about ?item.
    ?wiki0 schema:isPartOf <https://nl.wikipedia.org/>.
  }
FILTER(!BOUND(?wiki0))
}
GROUP BY ?item ?itemLabel ?professionLabel ?born
HAVING (?count > 4)
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?born"):::projected v8("?count") v4("?item"):::projected v6("?profession") v7("?sitelink"):::projected v3("?wfr") v2("?wiki0") c15(["nl,en,fr,de"]):::literal c10(["wd:Q3391743"]):::iri c7(["wd:Q6581072"]):::iri c13(["bd:serviceParam"]):::iri c17([https://nl.wikipedia.org/]):::iri c4(["nl"]):::literal f0[["?count > '4^^xsd:integer'"]] f0 --> v8 f1[["not bound(?wiki0)"]] f1 --> v2 f2[["not "]] subgraph f2e0["Exists Clause"] e0v1 --"schema:about"--> e0v2 e0v1 --"schema:inLanguage"--> e0c3 e0v2("?item"):::projected e0v1("?wfr"):::projected e0c3(["nl"]):::literal end f2--EXISTS--> f2e0 f2 --> v3 f2 --> c2 f2 --> v4 f2 --> c3 f2 --> c4 v3 --"schema:about"--> v4 v3 --"schema:inLanguage"--> c4 f3[["?born > '1900-01-01T00:00:00Z^^xsd:dateTime'"]] f3 --> v5 v4 --"wdt:P21"--> c7 v4 --"wdt:P106"--> v6 v6 --"wdt:P279"--> c10 v4 --"wdt:P569"--> v5 v7 --"schema:about"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."schema:about".-> v4 v2 --"schema:isPartOf"--> c17 end bind5[/"count(?sitelink)"/] v7 --o bind5 bind5 --as--o v8