carsten jancker
of the competitions that carsten jancker has participated in , the 2nd to last was when the venue was vasil levski national stadium .
{'row': '9', 'col': '1', 'order': '2', 'col_other': '2', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'scope': 'all', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'date', '2'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; date ; 2 }'}, 'venue'], 'result': 'vasil levski national stadium , sofia', 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; date ; 2 } ; venue }'}, 'vasil levski national stadium , sofia'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmax { all_rows ; date ; 2 } ; venue } ; vasil levski national stadium , sofia } = true', 'tointer': 'select the row whose date record of all rows is 2nd maximum . the venue record of this row is vasil levski national stadium , sofia .'}
eq { hop { nth_argmax { all_rows ; date ; 2 } ; venue } ; vasil levski national stadium , sofia } = true
select the row whose date record of all rows is 2nd maximum . the venue record of this row is vasil levski national stadium , sofia .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_4': 'all_rows', 'date_5': 'date', '2_6': '2', 'venue_7': 'venue', 'vasil levski national stadium , sofia_8': 'vasil levski national stadium , sofia'}
['date', 'venue', 'score', 'result', 'competition']
[['3 june 2000', 'easycredit - stadion , nuremberg', '1 - 0', '3 - 2', 'friendly'], ['7 june 2000', 'dreisamstadion , freiburg', '6 - 2', '8 - 2', 'friendly'], ['7 june 2000', 'dreisamstadion , freiburg', '8 - 2', '8 - 2', 'friendly'], ['2 june 2001', 'helsinki olympic stadium , helsinki', '2 - 2', '2 - 2', '2002 world cup qualifier'], ['15 august 2001', 'ferenc puskás stadium , budapest', '3 - 0', '5 - 2', 'friendly'], ['1 september 2001', 'olympiastadion , munich', '1 - 0', '1 - 5', '2002 world cup qualifier'], ['9 may 2002', 'dreisamstadion , freiburg', '7 - 0', '7 - 0', 'friendly'], ['1 june 2002', 'sapporo dome , sapporo', '4 - 0', '8 - 0', '2002 world cup'], ['21 august 2002', 'vasil levski national stadium , sofia', '2 - 2', '2 - 2', 'friendly'], ['11 october 2002', 'asim ferhatović hase stadium , sarajevo', '1 - 1', '1 - 1', 'friendly']]