2005 cfl draft
in the 2005 cfl draft , the only player drafted from acadia was karl ortmanns .
{'scope': 'all', 'row': '8', 'col': '5', 'col_other': '3', 'criterion': 'equal', 'value': 'acadia', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'college', 'acadia'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose college record fuzzily matches to acadia .', 'tostr': 'filter_eq { all_rows ; college ; acadia }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; college ; acadia } }', 'tointer': 'select the rows whose college record fuzzily matches to acadia . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'college', 'acadia'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose college record fuzzily matches to acadia .', 'tostr': 'filter_eq { all_rows ; college ; acadia }'}, 'player'], 'result': 'karl ortmanns', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; college ; acadia } ; player }'}, 'karl ortmanns'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; college ; acadia } ; player } ; karl ortmanns }', 'tointer': 'the player record of this unqiue row is karl ortmanns .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; college ; acadia } } ; eq { hop { filter_eq { all_rows ; college ; acadia } ; player } ; karl ortmanns } } = true', 'tointer': 'select the rows whose college record fuzzily matches to acadia . there is only one such row in the table . the player record of this unqiue row is karl ortmanns .'}
and { only { filter_eq { all_rows ; college ; acadia } } ; eq { hop { filter_eq { all_rows ; college ; acadia } ; player } ; karl ortmanns } } = true
select the rows whose college record fuzzily matches to acadia . there is only one such row in the table . the player record of this unqiue row is karl ortmanns .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'college_7': 'college', 'acadia_8': 'acadia', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'player_9': 'player', 'karl ortmanns_10': 'karl ortmanns'}
['pick', 'cfl team', 'player', 'position', 'college']
[['45', 'calgary stampeders', 'brett ralph', 'wr', 'alberta'], ['46', 'ottawa renegades', 'lenard semajuste', 'fb', 'adams state'], ['47', 'winnipeg blue bombers', 'ryan bisson', 'ol', 'northwood'], ['48', 'saskatchewan roughriders', 'ryan gottselig', 'dl', 'saskatchewan'], ['49', 'montreal alouettes ( via edmonton )', 'adam eckert', 'wr', 'dickinson state'], ['50', 'hamilton tiger - cats', 'andrew paopao', 'dl', 'san jose state'], ['51', 'montreal alouettes', 'olivier manigat', 'ol', 'columbia'], ['52', 'bc lions', 'karl ortmanns', 'ol', 'acadia']]