2010 - 11 uefa champions league
of the teams 2 ’s that had 1-0 in the first leg , the only one with 0-0 in the second leg was jeunesse esch .
{'scope': 'subset', 'row': '15', 'col': '5', 'col_other': '3', 'criterion': 'equal', 'value': '0-0', 'subset': {'col': '4', 'criterion': 'equal', 'value': '1 - 0'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', '1st leg', '1 - 0'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; 1st leg ; 1 - 0 }', 'tointer': 'select the rows whose 1st leg record fuzzily matches to 1 - 0 .'}, '2nd leg', '0-0'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose 1st leg record fuzzily matches to 1 - 0 . among these rows , select the rows whose 2nd leg record fuzzily matches to 0-0 .', 'tostr': 'filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } }', 'tointer': 'select the rows whose 1st leg record fuzzily matches to 1 - 0 . among these rows , select the rows whose 2nd leg record fuzzily matches to 0-0 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', '1st leg', '1 - 0'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; 1st leg ; 1 - 0 }', 'tointer': 'select the rows whose 1st leg record fuzzily matches to 1 - 0 .'}, '2nd leg', '0-0'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose 1st leg record fuzzily matches to 1 - 0 . among these rows , select the rows whose 2nd leg record fuzzily matches to 0-0 .', 'tostr': 'filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 }'}, 'team 2'], 'result': 'jeunesse esch', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } ; team 2 }'}, 'jeunesse esch'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } ; team 2 } ; jeunesse esch }', 'tointer': 'the team 2 record of this unqiue row is jeunesse esch .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } } ; eq { hop { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } ; team 2 } ; jeunesse esch } } = true', 'tointer': 'select the rows whose 1st leg record fuzzily matches to 1 - 0 . among these rows , select the rows whose 2nd leg record fuzzily matches to 0-0 . there is only one such row in the table . the team 2 record of this unqiue row is jeunesse esch .'}
and { only { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } } ; eq { hop { filter_eq { filter_eq { all_rows ; 1st leg ; 1 - 0 } ; 2nd leg ; 0-0 } ; team 2 } ; jeunesse esch } } = true
select the rows whose 1st leg record fuzzily matches to 1 - 0 . among these rows , select the rows whose 2nd leg record fuzzily matches to 0-0 . there is only one such row in the table . the team 2 record of this unqiue row is jeunesse esch .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', '1st leg_8': '1st leg', '1 - 0_9': '1 - 0', '2nd leg_10': '2nd leg', '0-0_11': '0-0', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'team 2_12': 'team 2', 'jeunesse esch_13': 'jeunesse esch'}
['team 1', 'agg', 'team 2', '1st leg', '2nd leg']
[['liepājas metalurgs', '0 - 5', 'sparta prague', '0 - 3', '0 - 2'], ['aktobe', '3 - 1', 'olimpi rustavi', '2 - 0', '1 - 1'], ['levadia', '3 - 4', 'debrecen', '1 - 1', '2 - 3'], ['partizan', '4 - 1', 'pyunik', '3 - 1', '1 - 0'], ['inter baku', '1 - 1 ( 8 - 9 p )', 'lech poznań', '0 - 1', '1 - 0 ( aet )'], ['dinamo zagreb', '5 - 4', 'koper', '5 - 1', '0 - 3'], ['litex lovech', '5 - 0', 'rudar pljevlja', '1 - 0', '4 - 0'], ['birkirkara', '1 - 3', 'žilina', '1 - 0', '0 - 3'], ['sheriff tiraspol', '3 - 2', 'dinamo tirana', '3 - 1', '0 - 1'], ['hapoel tel aviv', '6 - 0', 'željezničar', '5 - 0', '1 - 0'], ['omonia', '5 - 0', 'renova', '3 - 0', '2 - 0'], ['red bull salzburg', '5 - 1', 'hb tórshavn', '5 - 0', '0 - 1'], ['bohemians', '1 - 4', 'the new saints', '1 - 0', '0 - 4'], ['bate', '6 - 1', 'fh', '5 - 1', '1 - 0'], ['aik', '1 - 0', 'jeunesse esch', '1 - 0', '0 - 0'], ['linfield', '0 - 2', 'rosenborg', '0 - 0', '0 - 2'], ['ekranas', '1 - 2', 'hjk helsinki', '1 - 0', '0 - 2 ( aet )']]