vietnam open ( badminton )
2006 was the only year that the men 's singles of the vietnam open was won by andrew smith .
{'scope': 'all', 'row': '4', 'col': '2', 'col_other': '1', 'criterion': 'equal', 'value': 'andrew smith', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', "men 's singles", 'andrew smith'], 'result': None, 'ind': 0, 'tointer': "select the rows whose men 's singles record fuzzily matches to andrew smith .", 'tostr': "filter_eq { all_rows ; men 's singles ; andrew smith }"}], 'result': True, 'ind': 1, 'tostr': "only { filter_eq { all_rows ; men 's singles ; andrew smith } }", 'tointer': "select the rows whose men 's singles record fuzzily matches to andrew smith . there is only one such row in the table ."}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', "men 's singles", 'andrew smith'], 'result': None, 'ind': 0, 'tointer': "select the rows whose men 's singles record fuzzily matches to andrew smith .", 'tostr': "filter_eq { all_rows ; men 's singles ; andrew smith }"}, 'year'], 'result': '2006', 'ind': 2, 'tostr': "hop { filter_eq { all_rows ; men 's singles ; andrew smith } ; year }"}, '2006'], 'result': True, 'ind': 3, 'tostr': "eq { hop { filter_eq { all_rows ; men 's singles ; andrew smith } ; year } ; 2006 }", 'tointer': 'the year record of this unqiue row is 2006 .'}], 'result': True, 'ind': 4, 'tostr': "and { only { filter_eq { all_rows ; men 's singles ; andrew smith } } ; eq { hop { filter_eq { all_rows ; men 's singles ; andrew smith } ; year } ; 2006 } } = true", 'tointer': "select the rows whose men 's singles record fuzzily matches to andrew smith . there is only one such row in the table . the year record of this unqiue row is 2006 ."}
and { only { filter_eq { all_rows ; men 's singles ; andrew smith } } ; eq { hop { filter_eq { all_rows ; men 's singles ; andrew smith } ; year } ; 2006 } } = true
select the rows whose men 's singles record fuzzily matches to andrew smith . there is only one such row in the table . the year record of this unqiue row is 2006 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', "men 's singles_7": "men 's singles", 'andrew smith_8': 'andrew smith', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'year_9': 'year', '2006_10': '2006'}
['year', "men 's singles", "women 's singles", "men 's doubles", "women 's doubles", 'mixed doubles']
[['1996', 'nunung subandoro', 'zheng yaqiong', 'choong tan fook lee wan wah', 'peng xingyong zhang jin', 'liu yong zhang jin'], ['1997', 'chen gang', 'susi susanti', 'ricky subagja rexy mainaky', 'eliza nathanael zelin resiana', 'bambang supriyanto riseu rosalina'], ['1998 2005', 'no competition', 'no competition', 'no competition', 'no competition', 'no competition'], ['2006', 'andrew smith', 'bae seung - hee', 'yoo yeon - seong jeon jun - bum', 'kim jin - ock lee jung - mi', 'yoo yeon - seong lee jung - mi'], ['2007', 'roslin hashim', 'zhu jingjing', 'kwon yi - goo ko sung - hyun', 'natalia poluakan yulianti', 'tontowi ahmad yulianti'], ['2008', 'nguyen tien minh', 'zhang beiwen', 'choong tan fook lee wan wah', 'shendy puspa irawati meiliana jauhari', 'tontowi ahmad shendy puspa irawati'], ['2009', 'nguyen tien minh', 'fransisca ratnasari', 'luluk hadiyanto joko riyadi', 'anneke feinya agustin annisa wahyuni', 'flandy limpele cheng wen - hsing'], ['2010', 'chen yuekun', 'ratchanok inthanon', 'mohammad ahsan bona septano', 'ma jin zhong qianxin', 'he hanbin ma jin'], ['2011', 'nguyen tien minh', 'fu mingtian', 'angga pratama ryan agung saputra', 'anneke feinya agustin nitya krishinda maheswari', 'vitaliy durkin nina vislova'], ['2012', 'nguyen tien minh', 'porntip buranaprasertsuk', 'bodin issara maneepong jongjit', 'pia zebadiah rizki amelia pradipta', 'markis kido pia zebadiah']]