tom kristensen
the only year that tom kristensen finished second in a race was in 2012 .
{'scope': 'all', 'row': '16', 'col': '6', 'col_other': '1', 'criterion': 'equal', 'value': '2nd', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pos', '2nd'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose pos record fuzzily matches to 2nd .', 'tostr': 'filter_eq { all_rows ; pos ; 2nd }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; pos ; 2nd } }', 'tointer': 'select the rows whose pos record fuzzily matches to 2nd . there is only one such row in the table .'}, {'func': 'eq', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'pos', '2nd'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose pos record fuzzily matches to 2nd .', 'tostr': 'filter_eq { all_rows ; pos ; 2nd }'}, 'year'], 'result': '2012', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; pos ; 2nd } ; year }'}, '2012'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; pos ; 2nd } ; year } ; 2012 }', 'tointer': 'the year record of this unqiue row is 2012 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; pos ; 2nd } } ; eq { hop { filter_eq { all_rows ; pos ; 2nd } ; year } ; 2012 } } = true', 'tointer': 'select the rows whose pos record fuzzily matches to 2nd . there is only one such row in the table . the year record of this unqiue row is 2012 .'}
and { only { filter_eq { all_rows ; pos ; 2nd } } ; eq { hop { filter_eq { all_rows ; pos ; 2nd } ; year } ; 2012 } } = true
select the rows whose pos record fuzzily matches to 2nd . there is only one such row in the table . the year record of this unqiue row is 2012 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'pos_7': 'pos', '2nd_8': '2nd', 'eq_3': 'eq', 'num_hop_2': 'num_hop', 'year_9': 'year', '2012_10': '2012'}
['year', 'team', 'co - drivers', 'class', 'laps', 'pos']
[['1997', 'joest racing', 'michele alboreto stefan johansson', 'lmp', '361', '1st'], ['1998', 'team bmw motorsport', 'hans joachim stuck steve soper', 'lmp1', '60', 'dnf'], ['1999', 'team bmw motorsport', 'jj lehto jörg müller', 'lmp', '304', 'dnf'], ['2000', 'audi sport team joest', 'frank biela emanuele pirro', 'lmp900', '368', '1st'], ['2001', 'audi sport team joest', 'frank biela emanuele pirro', 'lmp900', '321', '1st'], ['2002', 'audi sport team joest', 'frank biela emanuele pirro', 'lmp900', '375', '1st'], ['2003', 'team bentley', 'rinaldo capello guy smith', 'lmgtp', '377', '1st'], ['2004', 'audi sport japan team goh', 'seiji ara rinaldo capello', 'lmp1', '379', '1st'], ['2005', 'adt champion racing', 'jj lehto marco werner', 'lmp1', '370', '1st'], ['2006', 'audi sport team joest', 'rinaldo capello allan mcnish', 'lmp1', '367', '3rd'], ['2007', 'audi sport north america', 'rinaldo capello allan mcnish', 'lmp1', '262', 'dnf'], ['2008', 'audi sport north america', 'rinaldo capello allan mcnish', 'lmp1', '381', '1st'], ['2009', 'audi sport team joest', 'rinaldo capello allan mcnish', 'lmp1', '376', '3rd'], ['2010', 'audi sport team joest', 'rinaldo capello allan mcnish', 'lmp1', '394', '3rd'], ['2011', 'audi sport north america', 'rinaldo capello allan mcnish', 'lmp1', '14', 'dnf'], ['2012', 'audi sport team joest', 'allan mcnish rinaldo capello', 'lmp1', '377', '2nd'], ['2013', 'audi sport team joest', 'allan mcnish loïc duval', 'lmp1', '348', '1st']]