what tropical cyclone, that affected areas including grand canyon, is in the season 1974 atlantic hurricane season?
Entity
m.03wxjq
Hurricane Fifi–Orlene
class entity entity
meteorology.tropical_cyclone m.0vmt m.03by27
meteorology.tropical_cyclone meteorology.cyclone_affected_area meteorology.tropical_cyclone_season
Tropical Cyclone grand canyon 1974 Atlantic hurricane season
none none none
meteorology.tropical_cyclone.affected_areas meteorology.tropical_cyclone.tropical_cyclone_season
Affected areas Season
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 :meteorology.tropical_cyclone . 
VALUES ?x1 { :m.0vmt } 
VALUES ?x2 { :m.03by27 } 
?x0 :meteorology.tropical_cyclone.affected_areas ?x1 . 
?x0 :meteorology.tropical_cyclone.tropical_cyclone_season ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND meteorology.tropical_cyclone (AND (JOIN meteorology.tropical_cyclone.affected_areas m.0vmt) (JOIN meteorology.tropical_cyclone.tropical_cyclone_season m.03by27)))