what quotation is on 07/04/2007?
(AND media_common.quotation (JOIN media_common.quotation.date 2007-07-04^^http://www.w3.org/2001/XMLSchema#date))