zhang chunhui
the 2nd to last competition for zhang chunhui was when the venue was at olympic stadium in japan .
{'row': '7', 'col': '1', 'order': '7', 'col_other': '2', 'max_or_min': 'min_to_max', 'value_mentioned': 'no', 'scope': 'all', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmin', 'args': ['all_rows', 'date', '7'], 'result': None, 'ind': 0, 'tostr': 'nth_argmin { all_rows ; date ; 7 }'}, 'venue'], 'result': 'olympic stadium , tokyo , japan', 'ind': 1, 'tostr': 'hop { nth_argmin { all_rows ; date ; 7 } ; venue }'}, 'olympic stadium , tokyo , japan'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmin { all_rows ; date ; 7 } ; venue } ; olympic stadium , tokyo , japan } = true', 'tointer': 'select the row whose date record of all rows is 7th minimum . the venue record of this row is olympic stadium , tokyo , japan .'}
eq { hop { nth_argmin { all_rows ; date ; 7 } ; venue } ; olympic stadium , tokyo , japan } = true
select the row whose date record of all rows is 7th minimum . the venue record of this row is olympic stadium , tokyo , japan .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmin_0': 'nth_argmin', 'all_rows_4': 'all_rows', 'date_5': 'date', '7_6': '7', 'venue_7': 'venue', 'olympic stadium , tokyo , japan_8': 'olympic stadium , tokyo , japan'}
['date', 'venue', 'result', 'goals', 'competition']
[['14 january 2009', 'hong kong stadium , hong kong', '2 - 1', '0', 'friendly'], ['21 january 2009', 'hong kong stadium , hong kong', '1 - 3', '0', '2011 afc asian cup qualification'], ['28 january 2009', "ali muhesen stadium , sana'a , yemen", '0 - 1', '0', '2011 afc asian cup qualification'], ['27 august 2009', 'world games stadium , kaohsiung , taiwan', '12 - 0', '0', '2010 east asian football championship semi - final'], ['9 october 2009', 'outsourcing stadium , shizuoka , japan', '0 - 6', '0', '2011 afc asian cup qualification'], ['18 november 2009', 'hong kong stadium , hong kong', '0 - 4', '0', '2011 afc asian cup qualification'], ['7 february 2010', 'olympic stadium , tokyo , japan', '0 - 5', '0', '2010 east asian football championship'], ['17 november 2010', 'hong kong stadium , hong kong', '0 - 7', '0', 'friendly']]