vasek pospisil
vasek pospisil won only once on clay surface .
{'scope': 'subset', 'row': '5', 'col': '1', 'col_other': 'n/a', 'criterion': 'equal', 'value': 'winner', 'subset': {'col': '4', 'criterion': 'equal', 'value': 'clay'}}
{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'surface', 'clay'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; surface ; clay }', 'tointer': 'select the rows whose surface record fuzzily matches to clay .'}, 'outcome', 'winner'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose surface record fuzzily matches to clay . among these rows , select the rows whose outcome record fuzzily matches to winner .', 'tostr': 'filter_eq { filter_eq { all_rows ; surface ; clay } ; outcome ; winner }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; surface ; clay } ; outcome ; winner } } = true', 'tointer': 'select the rows whose surface record fuzzily matches to clay . among these rows , select the rows whose outcome record fuzzily matches to winner . there is only one such row in the table .'}
only { filter_eq { filter_eq { all_rows ; surface ; clay } ; outcome ; winner } } = true
select the rows whose surface record fuzzily matches to clay . among these rows , select the rows whose outcome record fuzzily matches to winner . there is only one such row in the table .
{'only_2': 'only', 'result_3': 'true', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'surface_5': 'surface', 'clay_6': 'clay', 'outcome_7': 'outcome', 'winner_8': 'winner'}
['outcome', 'date', 'tournament', 'surface', 'opponent', 'score']
[['runner - up', 'july 13 , 2009', 'usa f17 , peoria', 'clay', 'michael venus', '7 - 6 ( 7 - 4 ) , 4 - 6 , 4 - 6'], ['winner', 'september 26 , 2009', 'italy f29 , alghero', 'hard', 'francesco piccari', '6 - 3 , 6 - 7 ( 5 - 7 ) , 6 - 3'], ['winner', 'october 3 , 2009', "italy f30 , quartu sant ' elena", 'hard', 'matteo viola', '6 - 1 , 6 - 2'], ['winner', 'november 1 , 2009', 'mexico f12 , obregón', 'hard', 'daniel garza', '7 - 6 ( 7 - 0 ) , 6 - 3'], ['winner', 'november 8 , 2009', 'mexico f14 , guadalajara', 'clay', 'césar ramírez', '6 - 2 , 6 - 2'], ['runner - up', 'february 22 , 2010', 'usa f5 , brownsville', 'hard', 'víctor estrella', '4 - 6 , 3 - 6'], ['winner', 'march 21 , 2010', 'canada f3 , sherbrooke', 'hard ( i )', 'milos raonic', '6 - 4 , 4 - 6 , 6 - 3'], ['winner', 'september 5 , 2010', 'mexico f6 , león', 'hard', 'david rice', '6 - 1 , 6 - 2'], ['winner', 'september 12 , 2010', 'mexico f7 , guadalajara', 'hard', 'adam el mihdawy', '6 - 0 , 6 - 1'], ['winner', 'october 3 , 2010', 'canada f5 , markham', 'hard ( i )', 'nicholas monroe', '6 - 3 , 6 - 2'], ['winner', 'may 29 , 2011', 'korea f2 , changwon', 'hard', 'lim yong - kyu', '7 - 5 , 6 - 4'], ['winner', 'july 31 , 2011', 'canada f4 , saskatoon', 'hard', 'érik chvojka', '7 - 5 , 6 - 2'], ['winner', 'march 25 , 2012', 'rimouski , canada', 'hard ( i )', 'maxime authom', '7 - 6 ( 8 - 6 ) , 6 - 4'], ['winner', 'july 22 , 2012', 'granby , canada', 'hard', 'igor sijsling', '7 - 6 ( 7 - 2 ) , 6 - 4'], ['runner - up', 'march 18 , 2013', 'rimouski , canada', 'hard ( i )', 'rik de voest', '6 - 7 ( 6 - 8 ) , 4 - 6'], ['winner', 'may 4 , 2013', 'johannesburg , south africa', 'hard', 'michał przysiężny', '6 - 7 ( 7 - 9 ) , 6 - 0 , 4 - 1 ret'], ['winner', 'august 4 , 2013', 'vancouver , canada', 'hard', 'daniel evans', '6 - 0 , 1 - 6 , 7 - 5']]