query-d0d9ae85af16536ccf8cde96aedfc2c0

rq turtle/ttl

Propertiesinstance of (P31)sex or gender (P21)

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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?FAsitelink ?WQsitelink
WHERE
 {
   ?item wdt:P31 wd:Q5.
   ?item wdt:P21 wd:Q6581072 .
     ?FAsitelink # There is a Wikipedia Featured article
     schema:about ?item;
     wikibase:badge wd:Q17437796 . # Sitelink is badged as a Featured Article
   {
     ?FAsitelink schema:isPartOf <https://fr.wikipedia.org/> .
     }
UNION
   {
    ?FAsitelink schema:isPartOf <https://en.wikipedia.org/> .
     }

   MINUS
   {
   ?WQsitelink # And a sitelink to a frwq page
     schema:about ?item ;
     schema:isPartOf <https://fr.wikiquote.org/>.  
     }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
 }
 LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?FAsitelink"):::projected v3("?WQsitelink"):::projected v1("?item"):::projected c9([https://fr.wikipedia.org/]):::iri c4(["wd:Q6581072"]):::iri c11([https://fr.wikiquote.org/]):::iri c10([https://en.wikipedia.org/]):::iri c13(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal c7(["wd:Q17437796"]):::iri v1 --"wdt:P31"--> c2 v1 --"wdt:P21"--> c4 v2 --"schema:about"--> v1 v2 --"wikibase:badge"--> c7 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 --"schema:isPartOf"--> c10 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"schema:isPartOf"--> c9 end union0r <== or ==> union0l end subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v3 --"schema:about"--> v1 v3 --"schema:isPartOf"--> c11 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end