2008 - 09 detroit red wings season
in the 2008-09 detroit red wings season , when the player 's position is center , the only player from canada is julien cayer .
{'scope': 'subset', 'row': '4', 'col': '5', 'col_other': '3', 'criterion': 'equal', 'value': 'canada', 'subset': {'col': '4', 'criterion': 'equal', 'value': 'center'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'position', 'center'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; position ; center }', 'tointer': 'select the rows whose position record fuzzily matches to center .'}, 'nationality', 'canada'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose position record fuzzily matches to center . among these rows , select the rows whose nationality record fuzzily matches to canada .', 'tostr': 'filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } }', 'tointer': 'select the rows whose position record fuzzily matches to center . among these rows , select the rows whose nationality record fuzzily matches to canada . 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', 'position', 'center'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; position ; center }', 'tointer': 'select the rows whose position record fuzzily matches to center .'}, 'nationality', 'canada'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose position record fuzzily matches to center . among these rows , select the rows whose nationality record fuzzily matches to canada .', 'tostr': 'filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada }'}, 'player'], 'result': 'julien cayer', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } ; player }'}, 'julien cayer'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } ; player } ; julien cayer }', 'tointer': 'the player record of this unqiue row is julien cayer .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } } ; eq { hop { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } ; player } ; julien cayer } } = true', 'tointer': 'select the rows whose position record fuzzily matches to center . among these rows , select the rows whose nationality record fuzzily matches to canada . there is only one such row in the table . the player record of this unqiue row is julien cayer .'}
and { only { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } } ; eq { hop { filter_eq { filter_eq { all_rows ; position ; center } ; nationality ; canada } ; player } ; julien cayer } } = true
select the rows whose position record fuzzily matches to center . among these rows , select the rows whose nationality record fuzzily matches to canada . there is only one such row in the table . the player record of this unqiue row is julien cayer .
{'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', 'position_8': 'position', 'center_9': 'center', 'nationality_10': 'nationality', 'canada_11': 'canada', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'player_12': 'player', 'julien cayer_13': 'julien cayer'}
['round', 'overall pick', 'player', 'position', 'nationality', 'college / junior / club team ( league )']
[['1', '30', 'thomas mccollum', 'goaltender', 'united states', 'guelph storm ( ohl )'], ['3', '91', 'max nicastro', 'defenseman', 'united states', 'chicago steel ( ushl )'], ['4', '121', 'gustav nyquist', 'center', 'sweden', 'malmö redhawks ( sweden jr )'], ['5', '151', 'julien cayer', 'center', 'canada', 'northwood school ( hs - new york )'], ['6', '181', 'stephen johnston', 'left wing', 'canada', 'belleville bulls ( ohl )'], ['7', '211', 'jesper samuelsson', 'center', 'sweden', 'hc vita hästen ( swe - 3 )']]