Painters who are also writers

The query

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#> PREFIX schema: <http://schema.org/> SELECT ?p ?who ?year ?description ?image WHERE { { SELECT ?p WHERE { ?p wdt:P106 wd:Q1028181 ; # painter wdt:P106 wd:Q36180 # writer } LIMIT 25 } ?p rdfs:label ?who . FILTER(LANG(?who) = "en") OPTIONAL { ?p wdt:P569 ?dob . BIND(YEAR(?dob) AS ?year) } OPTIONAL { ?p schema:description ?description . FILTER(LANG(?description) = "en") } OPTIONAL { ?p wdt:P18 ?image } }