which cyclist has a adaptation. as a favorite film?
Entity
m.03q54dk
Daniel O'Connor
class class entity
sports.cyclist freebase.user_profile m.01chpn
sports.cyclist freebase.user_profile film.film
Cyclist User Profile adaptation.
none none none
freebase.user_profile.person freebase.user_profile.favorite_films
Person-Topic About Me Favorite Films
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (?x0 AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :sports.cyclist . 
?x1 :type.object.type :freebase.user_profile . 
VALUES ?x2 { :m.01chpn } 
?x1 :freebase.user_profile.person ?x0 . 
?x1 :freebase.user_profile.favorite_films ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND sports.cyclist (JOIN (R freebase.user_profile.person) (JOIN freebase.user_profile.favorite_films m.01chpn)))