query-faf50fb8aedd25e916a73605bb0bc026

rq turtle/ttl

Male tennis players who were born before 1950 without an atp id SELECT ?player ?date ?cause ?player_label WHERE { ?player wdt:P106 wd:Q10833314 . # find items that have "occupation (P106): tennis player (Q10833314)" ?player wdt:P569 ?date . # with a P569 (date of birth) claim ?player wdt:P21 wd:Q6581097 . # with a P21 (sex or gender) "sex or gender (P21): male (Q658109)"

FILTER not exists {?player wdt:P536 ?atp_id . } FILTER (?date < "1950-01-01T00:00:00Z"^^xsd:dateTime)

OPTIONAL {?player rdfs:label ?player_label filter (lang(?player_label) = "en") .} 
OPTIONAL {?cause rdfs:label ?cause_of_death_label filter (lang(?cause_of_death_label) = "en").}

} ORDER BY ASC (?player) LIMIT 100

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#Male tennis players who were born before 1950 without an atp id
SELECT ?player ?date ?cause ?player_label
WHERE 
{
    ?player wdt:P106 wd:Q10833314 .    # find items that have "occupation (P106): tennis player (Q10833314)"
    ?player wdt:P569 ?date .       # with a P569 (date of birth) claim
    ?player wdt:P21 wd:Q6581097 .       # with a P21 (sex or gender) "sex or gender (P21): male (Q658109)"

 FILTER not exists {?player wdt:P536 ?atp_id . }
 FILTER (?date < "1950-01-01T00:00:00Z"^^xsd:dateTime)


    OPTIONAL {?player rdfs:label ?player_label filter (lang(?player_label) = "en") .} 
    OPTIONAL {?cause rdfs:label ?cause_of_death_label filter (lang(?cause_of_death_label) = "en").}
}
ORDER BY ASC (?player)
LIMIT 100

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2017/02