what is the genre of an opera that premiered before 01/02/1843?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.01_22_ m.02vqkqk m.04mkyt5 m.04dg7h2 m.02g129 m.04b7znm m.0d8gp m.052bg4 m.04b7q58 m.04b2fpl m.0gd6k3 m.0gghh3
Opera seria Romantische Oper Opera in five acts Opera in three acts Singspiel Opera in one act Opera buffa Lyric tragedy Comic opera in two acts Opera in two acts Rescue opera Opera semi-seria
class class literal
opera.opera_genre opera.opera 1843-01-02^^http://www.w3.org/2001/XMLSchema#date
opera.opera_genre opera.opera type.datetime
Opera Genre Opera 01/02/1843
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 < "1843-01-02-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 1843-01-02^^http://www.w3.org/2001/XMLSchema#date)))