charmed ( season 3 )
the honeymoon 's over is the only epsiode of charmed ( season 3 ) that was written by brad kern .
{'scope': 'all', 'row': '1', 'col': '5', 'col_other': '3', 'criterion': 'equal', 'value': 'brad kern', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'written by', 'brad kern'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose written by record fuzzily matches to brad kern .', 'tostr': 'filter_eq { all_rows ; written by ; brad kern }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; written by ; brad kern } }', 'tointer': 'select the rows whose written by record fuzzily matches to brad kern . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'written by', 'brad kern'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose written by record fuzzily matches to brad kern .', 'tostr': 'filter_eq { all_rows ; written by ; brad kern }'}, 'title'], 'result': "the honeymoon 's over", 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; written by ; brad kern } ; title }'}, "the honeymoon 's over"], 'result': True, 'ind': 3, 'tostr': "eq { hop { filter_eq { all_rows ; written by ; brad kern } ; title } ; the honeymoon 's over }", 'tointer': "the title record of this unqiue row is the honeymoon 's over ."}], 'result': True, 'ind': 4, 'tostr': "and { only { filter_eq { all_rows ; written by ; brad kern } } ; eq { hop { filter_eq { all_rows ; written by ; brad kern } ; title } ; the honeymoon 's over } } = true", 'tointer': "select the rows whose written by record fuzzily matches to brad kern . there is only one such row in the table . the title record of this unqiue row is the honeymoon 's over ."}
and { only { filter_eq { all_rows ; written by ; brad kern } } ; eq { hop { filter_eq { all_rows ; written by ; brad kern } ; title } ; the honeymoon 's over } } = true
select the rows whose written by record fuzzily matches to brad kern . there is only one such row in the table . the title record of this unqiue row is the honeymoon 's over .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'written by_7': 'written by', 'brad kern_8': 'brad kern', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'title_9': 'title', "the honeymoon 's over_10": "the honeymoon 's over"}
['no in series', 'no in season', 'title', 'directed by', 'written by', 'original air date', 'production code', 'us viewers ( millions )']
[['45', '1', "the honeymoon 's over", 'jim conway', 'brad kern', 'october 5 , 2000', '4300045', '7.7'], ['46', '2', 'magic hour', 'john behring', 'zack estrin & chris levinson', 'october 12 , 2000', '4300046', '5.1'], ['47', '3', 'once upon a time', 'joel j feigenbaum', 'krista vernoff', 'october 19 , 2000', '4300047', '5.4'], ['48', '4', "all halliwell 's eve", 'anson williams', 'sheryl j anderson', 'october 26 , 2000', '4300048', '6.5'], ['49', '5', 'sight unseen', 'perry lang', 'william schmidt', 'november 2 , 2000', '4300049', '5.7'], ['50', '6', 'primrose empath', 'mel damski', 'daniel cerone', 'november 9 , 2000', '4300051', '6.1'], ['51', '7', 'power outage', 'craig zisk', 'monica breen & alison schapker', 'november 16 , 2000', '4300050', '5.7'], ['52', '8', 'sleuthing with the enemy', 'noel nosseck', 'peter hume', 'december 14 , 2000', '4300052', '5.5'], ['53', '9', 'coyote piper', 'chris long', 'krista vernoff', 'january 11 , 2001', '4300053', '5.1'], ['54', '10', 'we all scream for ice cream', 'allan kroeker', 'chris levinson & zack estrin', 'january 18 , 2001', '4300054', '5.4'], ['55', '11', 'blinded by the whitelighter', 'david straiton', 'nell scovell', 'january 25 , 2001', '4300055', '5.4'], ['56', '12', 'wrestling with demons', 'joel j feigenbaum', 'sheryl j anderson', 'february 1 , 2001', '4300056', '5.9'], ['57', '13', 'bride and gloom', 'chris long', 'william schmidt', 'february 8 , 2001', '4300057', '5.4'], ['58', '14', 'the good , the bad and the cursed', 'shannen doherty', 'monica breen & alison schapker', 'february 15 , 2001', '4300058', '5.1'], ['59', '15', 'just harried', 'mel damski', 'daniel cerone', 'february 22 , 2001', '4300059', '5.8'], ['60', '16', 'death takes a halliwell', 'jon pare', 'krista vernoff', 'march 15 , 2001', '4300060', '5.4'], ['61', '17', 'pre - witched', 'david straiton', 'chris levinson & zack estrin', 'march 22 , 2001', '4300061', '5.1'], ['62', '18', 'sin francisco', 'joel j feigenbaum', 'nell scovell', 'april 19 , 2001', '4300062', '4.0'], ['63', '19', 'the demon who came in from the cold', 'anson williams', 'sheryl j anderson', 'april 26 , 2001', '4300063', '3.6'], ['64', '20', 'exit strategy', 'joel j feigenbaum', 'peter hume & daniel cerone', 'may 3 , 2001', '4300064', '4.1']]