2009 atp world tour masters 1000
at the 2009 atp world tour masters 1000 , when the court surface is hard , the only tournament in shanghai is the shanghai masters .
{'scope': 'subset', 'row': '8', 'col': '3', 'col_other': '1', 'criterion': 'equal', 'value': 'shanghai', 'subset': {'col': '6', 'criterion': 'fuzzily_match', 'value': 'hard'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'court surface', 'hard'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; court surface ; hard }', 'tointer': 'select the rows whose court surface record fuzzily matches to hard .'}, 'location', 'shanghai'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose court surface record fuzzily matches to hard . among these rows , select the rows whose location record fuzzily matches to shanghai .', 'tostr': 'filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } }', 'tointer': 'select the rows whose court surface record fuzzily matches to hard . among these rows , select the rows whose location record fuzzily matches to shanghai . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'court surface', 'hard'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; court surface ; hard }', 'tointer': 'select the rows whose court surface record fuzzily matches to hard .'}, 'location', 'shanghai'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose court surface record fuzzily matches to hard . among these rows , select the rows whose location record fuzzily matches to shanghai .', 'tostr': 'filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai }'}, 'tournament'], 'result': 'shanghai masters', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } ; tournament }'}, 'shanghai masters'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } ; tournament } ; shanghai masters }', 'tointer': 'the tournament record of this unqiue row is shanghai masters .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } } ; eq { hop { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } ; tournament } ; shanghai masters } } = true', 'tointer': 'select the rows whose court surface record fuzzily matches to hard . among these rows , select the rows whose location record fuzzily matches to shanghai . there is only one such row in the table . the tournament record of this unqiue row is shanghai masters .'}
and { only { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } } ; eq { hop { filter_eq { filter_eq { all_rows ; court surface ; hard } ; location ; shanghai } ; tournament } ; shanghai masters } } = true
select the rows whose court surface record fuzzily matches to hard . among these rows , select the rows whose location record fuzzily matches to shanghai . there is only one such row in the table . the tournament record of this unqiue row is shanghai masters .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'court surface_8': 'court surface', 'hard_9': 'hard', 'location_10': 'location', 'shanghai_11': 'shanghai', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'tournament_12': 'tournament', 'shanghai masters_13': 'shanghai masters'}
['tournament', 'country', 'location', 'current venue', 'began', 'court surface']
[['indian wells masters', 'united states', 'indian wells', 'indian wells tennis garden', '1987', 'hard'], ['miami masters', 'united states', 'miami', 'tennis center at crandon park', '1987', 'hard'], ['monte carlo masters', 'monaco', 'roquebrune - cap - martin , france', 'monte carlo country club', '1897', 'clay'], ['rome masters', 'italy', 'rome', 'foro italico', '1930', 'clay'], ['madrid masters', 'spain', 'madrid', 'park manzanares', '2002', 'clay'], ['canada masters', 'canada', 'montreal / toronto', 'stade uniprix / rexall centre', '1881', 'hard'], ['cincinnati masters', 'united states', 'mason , ohio', 'lindner family tennis center', '1899', 'hard'], ['shanghai masters', 'china', 'shanghai', 'qi zhong stadium', '2009', 'hard'], ['paris masters', 'france', 'paris', 'palais omnisports de paris - bercy', '1968', 'hard ( i )']]