query-f140898799b02462f63a178eb4f3537c

rq turtle/ttl

Male tennis players who were born before 1950 without an atp id

Draft

SELECT ?player ?date ?cause ?player_label ?atp_id 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 (Q6581097)" ?player wdt:P536 ?atp_id .

FILTER (?date < "1950-01-01T00:00:00Z"^^xsd:dateTime) FILTER isBLANK(?atp_id) .

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)

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
#Draft

SELECT ?player ?date ?cause ?player_label ?atp_id
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 (Q6581097)" 
    ?player wdt:P536 ?atp_id .


 FILTER (?date < "1950-01-01T00:00:00Z"^^xsd:dateTime)
 FILTER isBLANK(?atp_id) .

    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)

Query found at

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