three cheers for sweet revenge
for three cheers for sweet revenge , when the region is the united states or japan , the majority of the time the format is cd .
{'scope': 'subset', 'col': '4', 'most_or_all': 'most', 'criterion': 'equal', 'value': 'cd', 'subset': {'col': '1', 'criterion': 'equal', 'value': 'united states or japan'}}
{'func': 'most_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'united states or japan'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; region ; united states or japan }', 'tointer': 'select the rows whose region record fuzzily matches to united states or japan .'}, 'format', 'cd'], 'result': True, 'ind': 1, 'tointer': 'select the rows whose region record fuzzily matches to united states or japan . for the format records of these rows , most of them fuzzily match to cd .', 'tostr': 'most_eq { filter_eq { all_rows ; region ; united states or japan } ; format ; cd } = true'}
most_eq { filter_eq { all_rows ; region ; united states or japan } ; format ; cd } = true
select the rows whose region record fuzzily matches to united states or japan . for the format records of these rows , most of them fuzzily match to cd .
{'most_str_eq_1': 'most_str_eq', 'result_2': 'true', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_3': 'all_rows', 'region_4': 'region', 'united states or japan_5': 'united states or japan', 'format_6': 'format', 'cd_7': 'cd'}
['region', 'date', 'label', 'format', 'catalogue']
[['australia', 'april 11 , 2005', 'reprise', 'cd', '9362486152'], ['japan', 'july 22 , 2004', 'reprise', 'cd', 'wpcr11890'], ['japan', 'january 26 , 2005', 'reprise', 'cd + dvd', 'wpzr30075'], ['japan', 'june 24 , 2009', 'reprise', 'cd', 'wpcr13504'], ['united kingdom', 'september 3 , 2004', 'reprise', 'cd', '9362486152'], ['united states', 'june 8 , 2004', 'reprise', 'cd', '486152'], ['united states', 'december 16 , 2008', 'reprise', '12 vinyl', '148615']]