2003 mls superdraft
doug warren was the only player in this round of the draft that played position gk .
{'scope': 'all', 'row': '4', 'col': '4', 'col_other': '3', 'criterion': 'equal', 'value': 'gk', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'position', 'gk'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose position record fuzzily matches to gk .', 'tostr': 'filter_eq { all_rows ; position ; gk }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; position ; gk } }', 'tointer': 'select the rows whose position record fuzzily matches to gk . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'position', 'gk'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose position record fuzzily matches to gk .', 'tostr': 'filter_eq { all_rows ; position ; gk }'}, 'player'], 'result': 'doug warren', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; position ; gk } ; player }'}, 'doug warren'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; position ; gk } ; player } ; doug warren }', 'tointer': 'the player record of this unqiue row is doug warren .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; position ; gk } } ; eq { hop { filter_eq { all_rows ; position ; gk } ; player } ; doug warren } } = true', 'tointer': 'select the rows whose position record fuzzily matches to gk . there is only one such row in the table . the player record of this unqiue row is doug warren .'}
and { only { filter_eq { all_rows ; position ; gk } } ; eq { hop { filter_eq { all_rows ; position ; gk } ; player } ; doug warren } } = true
select the rows whose position record fuzzily matches to gk . there is only one such row in the table . the player record of this unqiue row is doug warren .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'position_7': 'position', 'gk_8': 'gk', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'doug warren_10': 'doug warren'}
['pick', 'mls team', 'player', 'position', 'affiliation']
[['11', 'dc united', 'brian carroll', 'm', 'wake forest university'], ['12', 'metrostars', 'eddie gaven', 'm', 'nike project - 40'], ['13', 'san jose earthquakes', 'arturo alvarez', 'm', 'nike project - 40'], ['14', 'dc united', 'doug warren', 'gk', 'clemson university'], ['15', 'dallas burn', 'jason thompson', 'f', 'eastern illinois university'], ['16', 'los angeles galaxy', 'scot thompson', 'd', 'ucla'], ['17', 'metrostars', 'tim regan', 'd', 'bradley university'], ['18', 'chicago fire', 'damani ralph', 'f', 'university of connecticut'], ['19', 'los angeles galaxy', 'arturo torres', 'm', 'loyola marymount university'], ['20', 'los angeles galaxy', 'ricky lewis', 'd', 'clemson university']]