an opera whose date of first performance is before 03/29/1828 is in what opera genre?
Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.01_22_ m.02vqkqk m.04b7znm m.02g129 m.04dg7h2 m.0d8gp m.052bg4 m.04b2fpl m.0gd6k3
Opera seria Romantische Oper Opera in one act Singspiel Opera in three acts Opera buffa Lyric tragedy Opera in two acts Rescue opera
class class literal
opera.opera_genre opera.opera 1828-03-29^^http://www.w3.org/2001/XMLSchema#date
opera.opera_genre opera.opera type.datetime
Opera Genre Opera 03/29/1828
none none <
opera.opera.genre music.composition.date_of_first_performance
Genre Date of first performance
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 :opera.opera_genre . 
?x1 :type.object.type :opera.opera . 
FILTER (?x2 < "1828-03-29-08:00"^^<http://www.w3.org/2001/XMLSchema#date>)
?x1 :opera.opera.genre ?x0 . 
?x1 :music.composition.date_of_first_performance ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND opera.opera_genre (JOIN (R opera.opera.genre) (lt music.composition.date_of_first_performance 1828-03-29^^http://www.w3.org/2001/XMLSchema#date)))