christian dailly
the only game that christian dailly scored more than one international goal took place in hong kong , china .
{'scope': 'all', 'row': '3', 'col': '4', 'col_other': '3', 'criterion': 'greater_than', 'value': '1', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'score', '1'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose score record is greater than 1 .', 'tostr': 'filter_greater { all_rows ; score ; 1 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; score ; 1 } }', 'tointer': 'select the rows whose score record is greater than 1 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'score', '1'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose score record is greater than 1 .', 'tostr': 'filter_greater { all_rows ; score ; 1 }'}, 'venue'], 'result': 'hong kong , china', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; score ; 1 } ; venue }'}, 'hong kong , china'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; score ; 1 } ; venue } ; hong kong , china }', 'tointer': 'the venue record of this unqiue row is hong kong , china .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; score ; 1 } } ; eq { hop { filter_greater { all_rows ; score ; 1 } ; venue } ; hong kong , china } } = true', 'tointer': 'select the rows whose score record is greater than 1 . there is only one such row in the table . the venue record of this unqiue row is hong kong , china .'}
and { only { filter_greater { all_rows ; score ; 1 } } ; eq { hop { filter_greater { all_rows ; score ; 1 } ; venue } ; hong kong , china } } = true
select the rows whose score record is greater than 1 . there is only one such row in the table . the venue record of this unqiue row is hong kong , china .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', 'score_7': 'score', '1_8': '1', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'venue_9': 'venue', 'hong kong , china_10': 'hong kong , china'}
['goal', 'date', 'venue', 'score', 'result', 'competition']
[['1', '1 june 1997', "ta ' qali , malta", '1 - 0', '3 - 2', 'friendly'], ['2', '17 april 2002', 'aberdeen , scotland', '1 - 0', '1 - 2', 'friendly'], ['3', '23 may 2002', 'hong kong , china', '3 - 0', '4 - 0', 'friendly'], ['4', '12 october 2002', 'reykjavík , iceland', '1 - 0', '2 - 0', 'uefa euro 2004 qualifying'], ['5', '4 june 2005', 'glasgow , scotland', '1 - 0', '2 - 0', 'fifa world cup 2006 qualifying'], ['6', '6 september 2006', 'kaunas , lithuania', '1 - 0', '2 - 1', 'uefa euro 2008 qualifying']]