on 2012-07-30, which broadcast content ended?
(AND broadcast.content (JOIN broadcast.content.production_end 2012-07-30^^http://www.w3.org/2001/XMLSchema#date))