major league soccer records and statistics
2008 was the only year in which the columbus crew won the mls cup .
{'scope': 'all', 'row': '13', 'col': '2', 'col_other': '1', 'criterion': 'equal', 'value': 'columbus crew', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mls cup winner', 'columbus crew'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose mls cup winner record fuzzily matches to columbus crew .', 'tostr': 'filter_eq { all_rows ; mls cup winner ; columbus crew }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; mls cup winner ; columbus crew } }', 'tointer': 'select the rows whose mls cup winner record fuzzily matches to columbus crew . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'mls cup winner', 'columbus crew'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose mls cup winner record fuzzily matches to columbus crew .', 'tostr': 'filter_eq { all_rows ; mls cup winner ; columbus crew }'}, 'season'], 'result': '2008', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; mls cup winner ; columbus crew } ; season }'}, '2008'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; mls cup winner ; columbus crew } ; season } ; 2008 }', 'tointer': 'the season record of this unqiue row is 2008 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; mls cup winner ; columbus crew } } ; eq { hop { filter_eq { all_rows ; mls cup winner ; columbus crew } ; season } ; 2008 } } = true', 'tointer': 'select the rows whose mls cup winner record fuzzily matches to columbus crew . there is only one such row in the table . the season record of this unqiue row is 2008 .'}
and { only { filter_eq { all_rows ; mls cup winner ; columbus crew } } ; eq { hop { filter_eq { all_rows ; mls cup winner ; columbus crew } ; season } ; 2008 } } = true
select the rows whose mls cup winner record fuzzily matches to columbus crew . there is only one such row in the table . the season record of this unqiue row is 2008 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'mls cup winner_7': 'mls cup winner', 'columbus crew_8': 'columbus crew', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'season_9': 'season', '2008_10': '2008'}
['season', 'mls cup winner', 'mls cup runner - up', 'mls supporters shield winner', 'mls supporters shield runner - up']
[['1996', 'dc united', 'los angeles galaxy', 'tampa bay mutiny', 'los angeles galaxy'], ['1997', 'dc united', 'colorado rapids', 'dc united', 'kansas city wizards'], ['1998', 'chicago fire', 'dc united', 'los angeles galaxy', 'dc united'], ['1999', 'dc united', 'los angeles galaxy', 'dc united', 'los angeles galaxy'], ['2000', 'kansas city wizards', 'chicago fire', 'kansas city wizards', 'chicago fire'], ['2001', 'san jose earthquakes', 'los angeles galaxy', 'miami fusion', 'chicago fire'], ['2002', 'los angeles galaxy', 'new england revolution', 'los angeles galaxy', 'san jose earthquakes'], ['2003', 'san jose earthquakes', 'chicago fire', 'chicago fire', 'san jose earthquakes'], ['2004', 'dc united', 'kansas city wizards', 'columbus crew', 'kansas city wizards'], ['2005', 'los angeles galaxy', 'new england revolution', 'san jose earthquakes', 'new england revolution'], ['2006', 'houston dynamo', 'new england revolution', 'dc united', 'fc dallas'], ['2007', 'houston dynamo', 'new england revolution', 'dc united', 'chivas usa'], ['2008', 'columbus crew', 'new york red bulls', 'columbus crew', 'houston dynamo'], ['2009', 'real salt lake', 'los angeles galaxy', 'columbus crew', 'los angeles galaxy'], ['2010', 'colorado rapids', 'fc dallas', 'los angeles galaxy', 'real salt lake'], ['2011', 'los angeles galaxy', 'houston dynamo', 'los angeles galaxy', 'seattle sounders fc'], ['2012', 'los angeles galaxy', 'houston dynamo', 'san jose earthquakes', 'sporting kansas city']]