What is {position held} of {Colin Renfrew} that is {end time} is {2004-0-0} ?
What job did Colin Renfrew have in 2004?
what position did colin renfrew hold in 2004-0-0?
SELECT ?o WHERE { ?o property:end_time ?n . ?o property:position_held ?o . resource:Colin_Renfrew property:position_held ?o . FILTER ( CONTAINS ( YEAR ( ?n ) , '2004' ) ) }
select distinct ?obj  where {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q335189> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P39> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> ?obj .
?statement <http://www.wikidata.org/entity/P582> <2004-0-0>
} 

SELECT ?obj WHERE { wd:Q335189 p:P39 ?s . ?s ps:P39 ?obj . ?s pq:P582 ?x filter(contains(YEAR(?x),'2004')) }