2006 - 07 macedonian cup
the only game of the macedonian cup for 2006 - 07 having a team score a 2nd . leg score of 4 is rabotnički vs. ilinden .
{'scope': 'all', 'row': '6', 'col': '5', 'col_other': '1,3', 'criterion': 'fuzzily_match', 'value': '4', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', '2nd leg', '4'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose 2nd leg record fuzzily matches to 4 .', 'tostr': 'filter_eq { all_rows ; 2nd leg ; 4 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; 2nd leg ; 4 } }', 'tointer': 'select the rows whose 2nd leg record fuzzily matches to 4 . there is only one such row in the table .'}, {'func': 'and', 'args': [{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', '2nd leg', '4'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose 2nd leg record fuzzily matches to 4 .', 'tostr': 'filter_eq { all_rows ; 2nd leg ; 4 }'}, 'team 1'], 'result': 'rabotnički', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 1 }'}, 'rabotnički'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 1 } ; rabotnički }', 'tointer': 'the team 1 record of this unqiue row is rabotnički .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', '2nd leg', '4'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose 2nd leg record fuzzily matches to 4 .', 'tostr': 'filter_eq { all_rows ; 2nd leg ; 4 }'}, 'team 2'], 'result': 'ilinden', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 2 }'}, 'ilinden'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 2 } ; ilinden }', 'tointer': 'the team 2 record of this unqiue row is ilinden .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 1 } ; rabotnički } ; eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 2 } ; ilinden } }', 'tointer': 'the team 1 record of this unqiue row is rabotnički . the team 2 record of this unqiue row is ilinden .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; 2nd leg ; 4 } } ; and { eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 1 } ; rabotnički } ; eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 2 } ; ilinden } } } = true', 'tointer': 'select the rows whose 2nd leg record fuzzily matches to 4 . there is only one such row in the table . the team 1 record of this unqiue row is rabotnički . the team 2 record of this unqiue row is ilinden .'}
and { only { filter_eq { all_rows ; 2nd leg ; 4 } } ; and { eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 1 } ; rabotnički } ; eq { hop { filter_eq { all_rows ; 2nd leg ; 4 } ; team 2 } ; ilinden } } } = true
select the rows whose 2nd leg record fuzzily matches to 4 . there is only one such row in the table . the team 1 record of this unqiue row is rabotnički . the team 2 record of this unqiue row is ilinden .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_9': 'all_rows', '2nd leg_10': '2nd leg', '4_11': '4', 'and_6': 'and', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'team 1_12': 'team 1', 'rabotnički_13': 'rabotnički', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'team 2_14': 'team 2', 'ilinden_15': 'ilinden'}
['team 1', 'agg', 'team 2', '1st leg', '2nd leg']
[['pobeda', '3 - 0', 'shkëndija 79', '2 - 0', '1 - 0'], ['vardar', '5 - 1', 'metalurg', '4 - 1', '1 - 0'], ['drita', '4 - 2', 'bregalnica kraun', '3 - 0', '1 - 2'], ['gostivar', '3 - 6', 'renova', '1 - 4', '2 - 2'], ['milano', '4 - 3', 'baškimi', '2 - 1', '2 - 2'], ['rabotnički', '5 - 4', 'ilinden', '4 - 0', '1 - 4'], ['makedonija', '0 - 2', 'meridian fcu', '0 - 2', '0 - 0'], ['madžari solidarnost', '2 - 4', 'pelister', '2 - 2', '0 - 2']]