query-01a726e3f7cd4e8a742112a77e0e11ff

rq turtle/ttl

people with occupation actor born between 1960 and 1970 who are born oder death in India SELECT DISTINCT ?item ?itemLabel ?born WHERE { ?item wdt:P106 wd:Q33999;#occupation = actor wdt:P569 ?born;# FILTER (?born >= "1960-01-01T00:00:00Z"^^xsd:dateTime) .#after 1960 FILTER (?born <= "1970-12-31T00:00:00Z"^^xsd:dateTime) .#befor 31.12.1970 ?item wdt:P19/wdt:P131|wdt:P20/wdt:P131 wd:Q668.#place of birth or death is India SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ?born

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#>
#people with occupation actor born between 1960 and 1970 who are born oder death in India
SELECT DISTINCT ?item ?itemLabel ?born
WHERE 
{
  ?item wdt:P106 wd:Q33999;#occupation = actor
        wdt:P569 ?born;#
  FILTER (?born >= "1960-01-01T00:00:00Z"^^xsd:dateTime) .#after 1960
  FILTER (?born <= "1970-12-31T00:00:00Z"^^xsd:dateTime) .#befor 31.12.1970
  ?item wdt:P19/wdt:P131*|wdt:P20/wdt:P131* wd:Q668.#place of birth or death is India
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?born

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?born"):::projected v2("?item"):::projected a1((" ")) a2((" ")) c11(["bd:serviceParam"]):::iri c8(["wd:Q668"]):::iri c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal c4(["wd:Q33999"]):::iri f0[["?born <= '1970-12-31T00:00:00Z^^xsd:dateTime'"]] f0 --> v1 f1[["?born >= '1960-01-01T00:00:00Z^^xsd:dateTime'"]] f1 --> v1 v2 --"wdt:P106"--> c4 v2 --"wdt:P569"--> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P20"--> a2 a2 --"wdt:P131"--> c8 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P19"--> a1 a1 --"wdt:P131"--> c8 end union0r <== or ==> union0l end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end