andre roberts ( mixed martial artist )
the fight against ruben villareal was the only draw result in the career of andre roberts .
{'scope': 'all', 'row': '2', 'col': '1', 'col_other': '3', 'criterion': 'equal', 'value': 'draw', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'res', 'draw'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose res record fuzzily matches to draw .', 'tostr': 'filter_eq { all_rows ; res ; draw }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; res ; draw } }', 'tointer': 'select the rows whose res record fuzzily matches to draw . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'res', 'draw'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose res record fuzzily matches to draw .', 'tostr': 'filter_eq { all_rows ; res ; draw }'}, 'opponent'], 'result': 'ruben villareal', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; res ; draw } ; opponent }'}, 'ruben villareal'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; res ; draw } ; opponent } ; ruben villareal }', 'tointer': 'the opponent record of this unqiue row is ruben villareal .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; res ; draw } } ; eq { hop { filter_eq { all_rows ; res ; draw } ; opponent } ; ruben villareal } } = true', 'tointer': 'select the rows whose res record fuzzily matches to draw . there is only one such row in the table . the opponent record of this unqiue row is ruben villareal .'}
and { only { filter_eq { all_rows ; res ; draw } } ; eq { hop { filter_eq { all_rows ; res ; draw } ; opponent } ; ruben villareal } } = true
select the rows whose res record fuzzily matches to draw . there is only one such row in the table . the opponent record of this unqiue row is ruben villareal .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'res_7': 'res', 'draw_8': 'draw', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'opponent_9': 'opponent', 'ruben villareal_10': 'ruben villareal'}
['res', 'record', 'opponent', 'method', 'event', 'round', 'time']
[['loss', '14 - 2 - 1', 'dan christison', 'submission ( armbar )', 'wec 13 - heavyweight explosion', '1', '3:26'], ['draw', '14 - 1 - 1', 'ruben villareal', 'draw', 'sb 38 - superbrawl 38', '3', '5:00'], ['win', '14 - 1', 'gabe beauperthy', 'submission ( kimura )', 'ec 57 - extreme challenge 57', '1', '3:34'], ['win', '13 - 1', 'johnathan ivey', 'submission ( bad position )', 'sb 30 - collision course', '1', '1:38'], ['win', '12 - 1', 'ray seraille', 'submission ( neck crank )', 'sb 28 - superbrawl 28', '1', '2:49'], ['win', '11 - 1', 'joe campanella', 'tko', 'ec 27 - extreme challenge 27', '1', '2:07'], ['win', '10 - 1', 'ron waterman', 'ko', 'ufc 21', '1', '2:51'], ['loss', '9 - 1', 'gary goodridge', 'submission ( punches )', 'ufc 19', '1', '0:43'], ['win', '9 - 0', 'jamie schell', 'tko', 'icf 1 - iowa cage fighting 1', '1', '1:25'], ['win', '8 - 0', 'jamie schell', 'tko', 'mfc 1 - midwest fighting 1', '1', '1:35'], ['win', '7 - 0', 'dave kirshman', 'submission', 'mfc 1 - midwest fighting 1', '1', '0:10'], ['win', '6 - 0', 'phil breecher', 'n / a', 'ec 19 - extreme challenge 19', '1', '0:35'], ['win', '5 - 0', 'harry moskowitz', 'ko', 'ufc 17', '1', '3:15'], ['win', '4 - 0', 'jason brewer', 'submission ( strikes )', 'ec 15 - extreme challenge 15', '1', '0:39'], ['win', '3 - 0', 'sam adkins', 'submission', 'ec 11 - extreme challenge 11', '1', '4:02'], ['win', '2 - 0', 'jim axtell', 'submission', 'ec 4 - extreme challenge 4', '1', '5:41'], ['win', '1 - 0', 'trevor thrasher', 'submission', 'ec 2 - extreme challenge 2', '1', '3:59']]