uefa club competition records and statistics
the only player to debut in europe in the uefa club competition in 1995 and play more than 160 games is raãl .
{'scope': 'subset', 'row': '2', 'col': '3', 'col_other': '2', 'criterion': 'greater_than', 'value': '160', 'subset': {'col': '6', 'criterion': 'equal', 'value': '1995'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'debut in europe', '1995'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; debut in europe ; 1995 }', 'tointer': 'select the rows whose debut in europe record is equal to 1995 .'}, 'games', '160'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose debut in europe record is equal to 1995 . among these rows , select the rows whose games record is greater than 160 .', 'tostr': 'filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } }', 'tointer': 'select the rows whose debut in europe record is equal to 1995 . among these rows , select the rows whose games record is greater than 160 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'debut in europe', '1995'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; debut in europe ; 1995 }', 'tointer': 'select the rows whose debut in europe record is equal to 1995 .'}, 'games', '160'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose debut in europe record is equal to 1995 . among these rows , select the rows whose games record is greater than 160 .', 'tostr': 'filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 }'}, 'player'], 'result': 'raãl', 'ind': 3, 'tostr': 'hop { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } ; player }'}, 'raãl'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } ; player } ; raãl }', 'tointer': 'the player record of this unqiue row is raãl .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } } ; eq { hop { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } ; player } ; raãl } } = true', 'tointer': 'select the rows whose debut in europe record is equal to 1995 . among these rows , select the rows whose games record is greater than 160 . there is only one such row in the table . the player record of this unqiue row is raãl .'}
and { only { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } } ; eq { hop { filter_greater { filter_eq { all_rows ; debut in europe ; 1995 } ; games ; 160 } ; player } ; raãl } } = true
select the rows whose debut in europe record is equal to 1995 . among these rows , select the rows whose games record is greater than 160 . there is only one such row in the table . the player record of this unqiue row is raãl .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_greater_1': 'filter_greater', 'filter_eq_0': 'filter_eq', 'all_rows_7': 'all_rows', 'debut in europe_8': 'debut in europe', '1995_9': '1995', 'games_10': 'games', '160_11': '160', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'player_12': 'player', 'raãl_13': 'raãl'}
['rank', 'player', 'games', 'goals', 'goal ratio', 'debut in europe']
[['1', 'paolo maldini', '173', '3', '0.02', '1985'], ['2', 'raãl', '161', '76', '0.46', '1995'], ['3', 'clarence seedorf', '161', '15', '0.09', '1992'], ['4', 'javier zanetti', '159', '5', '0.03', '1995'], ['5', 'xavi', '154', '12', '0.08', '1999'], ['6', 'ryan giggs', '151', '29', '0.19', '1991'], ['7', 'jamie carragher', '150', '1', '0.01', '1997'], ['8', 'edwin van der sar', '142', '0', '0.00', '1993'], ['9', 'andriy shevchenko', '142', '67', '0.47', '1994'], ['10', 'roberto carlos', '141', '20', '0.14', '1995']]