2010 - 11 fc basel season
in the 2010-11 fc basel season , when the position is f2 , the 2nd highest number is for fwayo tembo .
{'scope': 'subset', 'row': '7', 'col': '2', 'order': '2', 'col_other': '3', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'subset': {'col': '1', 'criterion': 'equal', 'value': 'fw'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'position', 'fw'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; position ; fw }', 'tointer': 'select the rows whose position record fuzzily matches to fw .'}, 'number', '2'], 'result': None, 'ind': 1, 'tostr': 'nth_argmax { filter_eq { all_rows ; position ; fw } ; number ; 2 }'}, 'player'], 'result': 'fwayo tembo', 'ind': 2, 'tostr': 'hop { nth_argmax { filter_eq { all_rows ; position ; fw } ; number ; 2 } ; player }'}, 'fwayo tembo'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { nth_argmax { filter_eq { all_rows ; position ; fw } ; number ; 2 } ; player } ; fwayo tembo } = true', 'tointer': 'select the rows whose position record fuzzily matches to fw . select the row whose number record of these rows is 2nd maximum . the player record of this row is fwayo tembo .'}
eq { hop { nth_argmax { filter_eq { all_rows ; position ; fw } ; number ; 2 } ; player } ; fwayo tembo } = true
select the rows whose position record fuzzily matches to fw . select the row whose number record of these rows is 2nd maximum . the player record of this row is fwayo tembo .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'nth_argmax_1': 'nth_argmax', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'position_6': 'position', 'fw_7': 'fw', 'number_8': 'number', '2_9': '2', 'player_10': 'player', 'fwayo tembo_11': 'fwayo tembo'}
['position', 'number', 'player', 'super league', 'champions league', 'swiss cup', 'total']
[['mf', '14', 'valentin stocker', '3', '0', '0', '3'], ['fw', '13', 'alexander frei', '2', '1', '0', '3'], ['df', '22', 'samuel inkoom', '2', '0', '0', '2'], ['df', '20', 'behrang safari', '1', '1', '0', '2'], ['mf', '8', 'benjamin huggel', '0', '2', '0', '2'], ['mf', '17', 'xherdan shaqiri', '0', '2', '0', '2'], ['fw', '30', 'fwayo tembo', '1', '0', '0', '1'], ['fw', '31', 'jacques zoua', '0', '1', '0', '1']]