and { only { filter_eq { filter_eq { all_rows ; region ; united states } ; format ; cd } } ; eq { hop { filter_eq { filter_eq { all_rows ; region ; united states } ; format ; cd } ; date } ; june 8 , 2004 } } = true
select the rows whose region record fuzzily matches to united states . among these rows , select the rows whose format record fuzzily matches to cd . there is only one such row in the table . the date record of this unqiue row is june 8 , 2004 .