what is the number of theater plays in psychological horror?
Value
4
class class entity
theater.play theater.theater_genre m.01zxzp
theater.play theater.theater_genre cvg.cvg_genre
Play Theater Genre Psychological horror
count none none
theater.theater_genre.plays_in_this_genre media_common.media_genre.parent_genre
Plays In This Genre Parent genre
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 (COUNT(?x0) AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :theater.play . 
?x1 :type.object.type :theater.theater_genre . 
VALUES ?x2 { :m.01zxzp } 
?x1 :theater.theater_genre.plays_in_this_genre ?x0 . 
?x2 :media_common.media_genre.parent_genre ?x1 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(COUNT (AND theater.play (JOIN (R theater.theater_genre.plays_in_this_genre) (JOIN (R media_common.media_genre.parent_genre) m.01zxzp))))