meistriliiga
of the clubs in meistriliiga whose first season in the top division was in 1992 , the only one that has had 9 seasons there was in 5th position in 2012 .
{'scope': 'subset', 'row': '7', 'col': '4', 'col_other': '2', 'criterion': 'equal', 'value': '9', 'subset': {'col': '3', 'criterion': 'equal', 'value': '1992'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'first season in top division', '1992'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; first season in top division ; 1992 }', 'tointer': 'select the rows whose first season in top division record is equal to 1992 .'}, 'number of seasons in meistriliiga', '9'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose first season in top division record is equal to 1992 . among these rows , select the rows whose number of seasons in meistriliiga record is equal to 9 .', 'tostr': 'filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } }', 'tointer': 'select the rows whose first season in top division record is equal to 1992 . among these rows , select the rows whose number of seasons in meistriliiga record is equal to 9 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'first season in top division', '1992'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; first season in top division ; 1992 }', 'tointer': 'select the rows whose first season in top division record is equal to 1992 .'}, 'number of seasons in meistriliiga', '9'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose first season in top division record is equal to 1992 . among these rows , select the rows whose number of seasons in meistriliiga record is equal to 9 .', 'tostr': 'filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 }'}, 'position in 2012'], 'result': '5th', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } ; position in 2012 }'}, '5th'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } ; position in 2012 } ; 5th }', 'tointer': 'the position in 2012 record of this unqiue row is 5th .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } } ; eq { hop { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } ; position in 2012 } ; 5th } } = true', 'tointer': 'select the rows whose first season in top division record is equal to 1992 . among these rows , select the rows whose number of seasons in meistriliiga record is equal to 9 . there is only one such row in the table . the position in 2012 record of this unqiue row is 5th .'}
and { only { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } } ; eq { hop { filter_eq { filter_eq { all_rows ; first season in top division ; 1992 } ; number of seasons in meistriliiga ; 9 } ; position in 2012 } ; 5th } } = true
select the rows whose first season in top division record is equal to 1992 . among these rows , select the rows whose number of seasons in meistriliiga record is equal to 9 . there is only one such row in the table . the position in 2012 record of this unqiue row is 5th .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_eq_1': 'filter_eq', 'filter_eq_0': 'filter_eq', 'all_rows_7': 'all_rows', 'first season in top division_8': 'first season in top division', '1992_9': '1992', 'number of seasons in meistriliiga_10': 'number of seasons in meistriliiga', '9_11': '9', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'position in 2012_12': 'position in 2012', '5th_13': '5th'}
['club', 'position in 2012', 'first season in top division', 'number of seasons in meistriliiga', 'first season of current spell in top division', 'top division titles']
[['flora a , b , c', '3rd', '1992', '23', '1992', '9'], ['infonet c', '1st , ( esiliiga )', '2013', '1', '2013', '0'], ['nõmme kalju c', '1st', '2008', '6', '2008', '1'], ['kuressaare', '8th', '2000', '10', '2009', '0'], ['levadia c', '2nd', '1999', '15', '1999', '7'], ['paide linnameeskond c', '6th', '2009', '5', '2009', '0'], ['sillamäe kalev a', '5th', '1992', '9', '2008', '0'], ['tallinna kalev', '9th', '2007', '5', '2012', '0'], ['tammeka', '10th', '2005', '9', '2005', '0'], ['narva trans a , b , c', '4th', '1992', '23', '1992', '0']]