query-367ebf8150aa5364ef7048f1b5c481a8

rq turtle/ttl

donne non presenti su it.wiki ma su altre wiki? da en:Wikipedia:WikiProject_Women_in_Red/Number_of_links SELECT ?item ?linkcount WHERE { hint:Query hint:optimizer "None". hint:Query hint:maxParallel 50 . hint:Query hint:chunkSize 1000 . hint:Query hint:queryEngineChunkHandler "Native" . # Native/Managed hint:Query hint:filterExists "VectoredSubPlan" . # SubQueryLimitOne/VectoredSubPlan ?item wdt:P21 wd:Q6581072 . # gender is female ?item wikibase:sitelinks ?linkcount . FILTER ( ?linkcount >= 7 ) FILTER( ?item NOT IN (wd:Q4617, wd:Q180807, wd:Q234649, wd:Q237119, wd:Q264096, wd:Q270980, wd:Q326474, wd:Q464944, wd:Q468313, wd:Q8265475, wd:Q17413110, wd:Q19940498, wd:Q15397819, wd:Q13406268, wd:Q4115189)) # don’t count those who are redirects or any sandboxes FILTER NOT EXISTS { ?wen schema:about ?item . ?wen schema:isPartOf https://it.wikipedia.org/. } FILTER NOT EXISTS { ?item wdt:P106 wd:Q488111 } # don’t include porn actors ?item wdt:P31 wd:Q5 . # human } ORDER BY DESC(?linkcount) LIMIT 100

Use at

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/>
#donne non presenti su it.wiki ma su altre wiki? da en:Wikipedia:WikiProject_Women_in_Red/Number_of_links
SELECT ?item ?linkcount
WHERE {



   # Native/Managed
   # SubQueryLimitOne/VectoredSubPlan
  ?item wdt:P21 wd:Q6581072 .  # gender is female
  ?item wikibase:sitelinks ?linkcount .
  FILTER ( ?linkcount >= 7 )
  FILTER( ?item NOT IN (wd:Q4617, wd:Q180807, wd:Q234649, wd:Q237119, wd:Q264096, wd:Q270980, wd:Q326474, wd:Q464944, wd:Q468313, wd:Q8265475, wd:Q17413110, wd:Q19940498, wd:Q15397819, wd:Q13406268, wd:Q4115189)) # don’t count those who are redirects or any sandboxes
  FILTER NOT EXISTS { ?wen schema:about ?item . ?wen schema:isPartOf <https://it.wikipedia.org/>. }
  FILTER NOT EXISTS { ?item wdt:P106 wd:Q488111 } # don’t include porn actors
  ?item wdt:P31 wd:Q5 . # human
}
ORDER BY DESC(?linkcount)
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v1("?linkcount"):::projected v3("?wen") c5([https://it.wikipedia.org/]):::iri c23(["wd:Q6581072"]):::iri c26(["wd:Q5"]):::iri c2(["wd:Q488111"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P106"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q488111"]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> c2 v2 --"wdt:P106"--> c2 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"schema:about"--> e1v2 e1v1 --"schema:isPartOf"--> e1c3 e1v2("?item"):::projected e1v1("?wen"):::projected e1c3([https://it.wikipedia.org/]):::iri end f1--EXISTS--> f1e1 f1 --> v3 f1 --> c3 f1 --> v2 f1 --> c4 f1 --> c5 v3 --"schema:about"--> v2 v3 --"schema:isPartOf"--> c5 f2[["?item != 'wd:Q4617'?item != 'wd:Q180807'?item != 'wd:Q234649'?item != 'wd:Q237119'?item != 'wd:Q264096'?item != 'wd:Q270980'?item != 'wd:Q326474'?item != 'wd:Q464944'?item != 'wd:Q468313'?item != 'wd:Q8265475'?item != 'wd:Q17413110'?item != 'wd:Q19940498'?item != 'wd:Q15397819'?item != 'wd:Q13406268'?item != 'wd:Q4115189'"]] f2 --> v2 f3[["?linkcount >= '7^^xsd:integer'"]] f3 --> v1 v2 --"wdt:P21"--> c23 v2 --"wikibase:sitelinks"--> v1 v2 --"wdt:P31"--> c26