and { eq { hop { filter_eq { all_rows ; date ; 10 june 2009 } ; competition } ; hop { filter_eq { all_rows ; date ; 5 september 2009 } ; competition } } ; and { eq { hop { filter_eq { all_rows ; date ; 10 june 2009 } ; competition } ; 2010 fifa world cup qualification } ; eq { hop { filter_eq { all_rows ; date ; 5 september 2009 } ; competition } ; 2010 fifa world cup qualification } } } = true
select the rows whose date record fuzzily matches to 10 june 2009 . take the competition record of this row . select the rows whose date record fuzzily matches to 5 september 2009 . take the competition record of this row . the first record fuzzily matches to the second record . the competition record of the first row is 2010 fifa world cup qualification . the competition record of the second row is 2010 fifa world cup qualification .