laser quest
1997 was the only year that team mad madison heights mi won the laser quest .
{'scope': 'all', 'row': '16', 'col': '2', 'col_other': '1', 'criterion': 'equal', 'value': 'team mad madison heights mi', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'winner', 'team mad madison heights mi'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose winner record fuzzily matches to team mad madison heights mi .', 'tostr': 'filter_eq { all_rows ; winner ; team mad madison heights mi }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; winner ; team mad madison heights mi } }', 'tointer': 'select the rows whose winner record fuzzily matches to team mad madison heights mi . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'winner', 'team mad madison heights mi'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose winner record fuzzily matches to team mad madison heights mi .', 'tostr': 'filter_eq { all_rows ; winner ; team mad madison heights mi }'}, 'year'], 'result': '1997 details', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; winner ; team mad madison heights mi } ; year }'}, '1997 details'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; winner ; team mad madison heights mi } ; year } ; 1997 details }', 'tointer': 'the year record of this unqiue row is 1997 details .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; winner ; team mad madison heights mi } } ; eq { hop { filter_eq { all_rows ; winner ; team mad madison heights mi } ; year } ; 1997 details } } = true', 'tointer': 'select the rows whose winner record fuzzily matches to team mad madison heights mi . there is only one such row in the table . the year record of this unqiue row is 1997 details .'}
and { only { filter_eq { all_rows ; winner ; team mad madison heights mi } } ; eq { hop { filter_eq { all_rows ; winner ; team mad madison heights mi } ; year } ; 1997 details } } = true
select the rows whose winner record fuzzily matches to team mad madison heights mi . there is only one such row in the table . the year record of this unqiue row is 1997 details .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'winner_7': 'winner', 'team mad madison heights mi_8': 'team mad madison heights mi', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'year_9': 'year', '1997 details_10': '1997 details'}
['year', 'winner', 'first runner up', 'third place', 'consolation winner / 4th', 'finals location']
[['2012 details', 'tsa toronto on', 'nrh north richland hills tx', 'mesa mesa az', 'denver denver co', 'las vegas nv'], ['2011 details', 'nrh north richland hills tx', 'tsa toronto on', 'mesa mesa az', 'federal way seattle wa', 'las vegas nv'], ['2010 details', 'tsa toronto on', 'nrh north richland hills tx', 'mesa mesa az', 'federal way seattle wa', 'hoffman estates il'], ['2009 details', 'nrh north richland hills tx', 'tsa toronto on', 'federal way seattle wa', 'team off hoffman estates il', 'las vegas nv'], ['2008 details', 'nrh north richland hills tx', 'shadowz lincoln ne', 'tsa scarborough on', 'team off hoffman estates il', 'hoffman estates il'], ['2007 details', '9 deadly venoms houston tx', 'brampton brew crew brampton on', 'team off hoffman estates il', 'nrh north richland hills tx', 'gwinnett ga'], ['2006 details', 'shadowz lincoln ne', 'westland wolfpack westland mi', '42 appleton wi', 'brampton brew crew brampton on', 'las vegas nv'], ['2005 details', 'nrh north richland hills tx', '9 deadly venoms houston tx', 'westland wolfpack westland mi', 'brampton brew crew brampton on', 'mesquite tx'], ['2004 details', 'brampton brew crew brampton on', 'nrh north richland hills tx', '9 deadly venoms houston tx', 'phoenix pyros phoenix az', 'rochester ny'], ['2003 details', 'paragon denver co', 'westland wolfpack westland mi', 'shadowz lincoln ne', 'brampton brew crew brampton on', 'north richland hills tx'], ['2002 details', 'paragon denver co', 'phoenix pyros phoenix az', '9 deadly venoms houston tx', 'shadowz lincoln ne', 'norridge il'], ['2001 details', 'paragon denver co', 'westland wolfpack westland mi', 'san antonio san antonio tx', 'austin austin tx', 'colorado springs co'], ['2000 details', 'phoenix pyros phoenix az', 'paragon denver co', 'tulsa whoopdonkeys tulsa ok', 'westland wolfpack westland mi', 'scarborough on'], ['1999 details', 'phoenix pyros phoenix az', 'paragon denver co', 'austin austin tx', 'nrh north richland hills tx', 'north richland hills tx'], ['1998 details', '9 deadly venoms houston tx', 'phoenix pyros phoenix az', 'armageddon lincoln ne', 'mesa mesa az', 'knoxville tn'], ['1997 details', 'team mad madison heights mi', 'paragon denver co', 'oshawa oshawa on', 'phoenix pyros phoenix az', 'downers grove il'], ['1996 details', 'oshawa oshawa on', 'london london on', 'brampton brew crew brampton on', 'charlotte charlotte nc', 'london on']]