and { eq { hop { filter_eq { all_rows ; date ; 16 august 2000 } ; competition } ; hop { filter_eq { all_rows ; date ; 22 august 2007 } ; competition } } ; and { eq { hop { filter_eq { all_rows ; date ; 16 august 2000 } ; competition } ; friendly } ; eq { hop { filter_eq { all_rows ; date ; 22 august 2007 } ; competition } ; friendly } } } = true
select the rows whose date record fuzzily matches to 16 august 2000 . take the competition record of this row . select the rows whose date record fuzzily matches to 22 august 2007 . take the competition record of this row . the first record fuzzily matches to the second record . the competition record of the first row is friendly . the competition record of the second row is friendly .