query-b2e64be4828e218dab454011edceeb58

rq turtle/ttl

Query Wikidata with MW API AccessRetrieve information about Arabic-language women poets with more than three site links on Wikidata, excluding those featured in Italian. It lists sorted by the number of links in descending order, limited to the top 500 results.

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription ?linkcount WHERE {                          
  ?item wdt:P21 wd:Q6581072.                  
  ?item wikibase:sitelinks ?linkcount .                                              
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
  SERVICE wikibase:mwapi {
     bd:serviceParam wikibase:endpoint "en.wikipedia.org";
                     wikibase:api "Generator";
                     mwapi:generator "categorymembers";
                     mwapi:gcmtitle "Category:Arabic-language women poets";
                     mwapi:gcmlimit "max".
     ?item wikibase:apiOutputItem mwapi:item.
  } 
  FILTER NOT EXISTS { ?it schema:about ?item . ?it schema:inLanguage "it" } 
  FILTER(?linkcount > 3 )
  }
ORDER BY DESC (?linkcount)                                                     
LIMIT 500

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?it") v3("?item"):::projected v1("?linkcount"):::projected c24(["mwapi:item"]):::iri c22(["max"]):::literal c4(["it"]):::literal c6(["wd:Q6581072"]):::iri c18(["categorymembers"]):::literal c14(["en.wikipedia.org"]):::literal c9(["bd:serviceParam"]):::iri c20(["Category:Arabic-language women poets"]):::literal c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal c16(["Generator"]):::literal f0[["?linkcount > '3^^xsd:integer'"]] f0 --> v1 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"schema:about"--> e0v2 e0v1 --"schema:inLanguage"--> e0c3 e0v1("?it"):::projected e0v2("?item"):::projected e0c3(["it"]):::literal end f1--EXISTS--> f1e0 f1 --> v2 f1 --> c2 f1 --> v3 f1 --> c3 f1 --> c4 v2 --"schema:about"--> v3 v2 --"schema:inLanguage"--> c4 v3 --"wdt:P21"--> c6 v3 --"mwapi:sitelinks"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"mwapi:language"--> c11 end subgraph s2["http://wikiba.se/ontology#mwapi"] style s2 stroke-width:4px; c9 --"mwapi:endpoint"--> c14 c9 --"mwapi:api"--> c16 c9 --"mwapi:generator"--> c18 c9 --"mwapi:gcmtitle"--> c20 c9 --"mwapi:gcmlimit"--> c22 v3 --"mwapi:apiOutputItem"--> c24 end