1960 - 61 primeira divisão
in the 1960 - 61 primeira divisão , for clubs that have 27 seasons at this level , the only one with settlements as porto is the porto club .
{'scope': 'subset', 'row': '4', 'col': '3', 'col_other': '1', 'criterion': 'equal', 'value': 'porto', 'subset': {'col': '2', 'criterion': 'equal', 'value': '27 seasons'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'seasons at this level', '27 seasons'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; seasons at this level ; 27 seasons }', 'tointer': 'select the rows whose seasons at this level record fuzzily matches to 27 seasons .'}, 'settlements', 'porto'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose seasons at this level record fuzzily matches to 27 seasons . among these rows , select the rows whose settlements record fuzzily matches to porto .', 'tostr': 'filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } }', 'tointer': 'select the rows whose seasons at this level record fuzzily matches to 27 seasons . among these rows , select the rows whose settlements record fuzzily matches to porto . 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', 'seasons at this level', '27 seasons'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; seasons at this level ; 27 seasons }', 'tointer': 'select the rows whose seasons at this level record fuzzily matches to 27 seasons .'}, 'settlements', 'porto'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose seasons at this level record fuzzily matches to 27 seasons . among these rows , select the rows whose settlements record fuzzily matches to porto .', 'tostr': 'filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto }'}, 'clubs'], 'result': 'porto', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } ; clubs }'}, 'porto'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } ; clubs } ; porto }', 'tointer': 'the clubs record of this unqiue row is porto .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } } ; eq { hop { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } ; clubs } ; porto } } = true', 'tointer': 'select the rows whose seasons at this level record fuzzily matches to 27 seasons . among these rows , select the rows whose settlements record fuzzily matches to porto . there is only one such row in the table . the clubs record of this unqiue row is porto .'}
and { only { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } } ; eq { hop { filter_eq { filter_eq { all_rows ; seasons at this level ; 27 seasons } ; settlements ; porto } ; clubs } ; porto } } = true
select the rows whose seasons at this level record fuzzily matches to 27 seasons . among these rows , select the rows whose settlements record fuzzily matches to porto . there is only one such row in the table . the clubs record of this unqiue row is porto .
{'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', 'seasons at this level_8': 'seasons at this level', '27 seasons_9': '27 seasons', 'settlements_10': 'settlements', 'porto_11': 'porto', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'clubs_12': 'clubs', 'porto_13': 'porto'}
['clubs', 'seasons at this level', 'settlements', 'season joined league', 'position in 1959 - 1960']
[['benfica', '27 seasons', 'lisbon', '1934 - 1935', '1'], ['sporting cp', '27 seasons', 'lisbon', '1934 - 1935', '2'], ['belenenses', '27 seasons', 'lisbon', '1934 - 1935', '3'], ['porto', '27 seasons', 'porto', '1934 - 1935', '4'], ['académica de coimbra', '26 seasons', 'coimbra', '1949 - 1950', '6'], ['vitória de guimarães', '17 seasons', 'guimarães', '1958 - 1959', '7'], ['atlético cp', '15 seasons', 'lisbon', '1959 - 1960', '11'], ['barreirense', '14 seasons', 'barreiro', '1960 - 1961', 'segunda divisão'], ['sporting de braga', '13 seasons', 'braga', '1957 - 1958', '12'], ['sporting da covilhã', '12 seasons', 'covilhã', '1958 - 1959', '9'], ['lusitano de évora', '9 seasons', 'évora', '1952 - 1953', '10'], ['cuf barreiro', '8 seasons', 'barreiro', '1954 - 1955', '5'], ['salgueiros', '5 seasons', 'porto', '1960 - 1961', 'segunda divisão'], ['leixões', '4 seasons', 'matosinhos', '1959 - 1960', '8']]