query-baa0ebf708ab12a400f0814583f90281

rq turtle/ttl

10:24, 21 November 2016 (UTC)) talk (Theklan part in a negative way? -wd:Q47588 wdt:P527 ?parts.Is there any way to get just the opposite? People not born in the Basque Country in nov 16th? How can I say the Interestingly, adding an statement count and a siteling count changes the number of results: 13:36, 21 November 2016 (UTC)) talk (Matěj Suchánek. MINUS { ?item wdt:P19/wdt:P131/^wdt:P527 wd:Q47588 } a small difference which is quite hard to explain) and even simplify it to is clause (there MINUS {} or FILTER NOT EXISTS {} into ?item wdt:P19 ?pob . ?pob wdt:P131 ?parts . wd:Q47588 wdt:P527 ?partsYou can wrap the whole

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?date ?stct ?slct WHERE {
  ?item wdt:P19 ?pob.
  ?pob wdt:P131* ?parts.
  wd:Q47588 wdt:P527 ?parts.
  ?item wdt:P31 wd:Q5.
    ?date_node wikibase:timePrecision "11"^^xsd:integer . 
    ?date_node wikibase:timeValue ?date . 
    FILTER (year(?date) > 1 && day(?date) = (16) && month(?date) = (11))
    ?item p:P569/psv:P569 ?date_node .
  OPTIONAL {?item wdt:P570 ?dod. BIND(YEAR(?dod) AS ?yod)}
    ?item wikibase:statements ?stct .
    ?item wikibase:sitelinks ?slct
}
ORDER BY DESC(?rank)
LIMIT 2000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?date"):::projected v6("?date_node") v7("?dod") v3("?item"):::projected v5("?parts") v4("?pob") v1("?rank") v10("?slct"):::projected v9("?stct"):::projected v8("?yod") a1((" ")) c3(["11^^xsd:integer"]):::literal c6(["wd:Q47588"]):::iri c9(["wd:Q5"]):::iri f0[["year-from-dateTime(?date) > '1^^xsd:integer'day-from-dateTime(?date) = '16^^xsd:integer'month-from-dateTime(?date) = '11^^xsd:integer'"]] f0 --> v2 v3 --"p:direct/P19"--> v4 v4 --"p:direct/P131"--> v5 c6 --"p:direct/P527"--> v5 v3 --"p:direct/P31"--> c9 v6 --"wikibase:timePrecision"--> c3 v6 --"wikibase:timeValue"--> v2 v3 --"p:P569"--> a1 a1 --"p:statement/value/P569"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P570".-> v7 bind1[/"year-from-dateTime(?dod)"/] v7 --o bind1 bind1 --as--o v8 end v3 --"wikibase:statements"--> v9 v3 --"wikibase:sitelinks"--> v10