what a lemon
the only version of what a lemon formatted in a double cd was the version from scandinavia in 2002 .
{'scope': 'all', 'row': '5', 'col': '4', 'col_other': '1,2', 'criterion': 'equal', 'value': 'double cd', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'format', 'double cd'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose format record fuzzily matches to double cd .', 'tostr': 'filter_eq { all_rows ; format ; double cd }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; format ; double cd } }', 'tointer': 'select the rows whose format record fuzzily matches to double cd . there is only one such row in the table .'}, {'func': 'and', 'args': [{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'format', 'double cd'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose format record fuzzily matches to double cd .', 'tostr': 'filter_eq { all_rows ; format ; double cd }'}, 'region'], 'result': 'scandinavia', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; format ; double cd } ; region }'}, 'scandinavia'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; format ; double cd } ; region } ; scandinavia }', 'tointer': 'the region record of this unqiue row is scandinavia .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'format', 'double cd'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose format record fuzzily matches to double cd .', 'tostr': 'filter_eq { all_rows ; format ; double cd }'}, 'date'], 'result': '2002', 'ind': 4, 'tostr': 'hop { filter_eq { all_rows ; format ; double cd } ; date }'}, '2002'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { filter_eq { all_rows ; format ; double cd } ; date } ; 2002 }', 'tointer': 'the date record of this unqiue row is 2002 .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { hop { filter_eq { all_rows ; format ; double cd } ; region } ; scandinavia } ; eq { hop { filter_eq { all_rows ; format ; double cd } ; date } ; 2002 } }', 'tointer': 'the region record of this unqiue row is scandinavia . the date record of this unqiue row is 2002 .'}], 'result': True, 'ind': 7, 'tostr': 'and { only { filter_eq { all_rows ; format ; double cd } } ; and { eq { hop { filter_eq { all_rows ; format ; double cd } ; region } ; scandinavia } ; eq { hop { filter_eq { all_rows ; format ; double cd } ; date } ; 2002 } } } = true', 'tointer': 'select the rows whose format record fuzzily matches to double cd . there is only one such row in the table . the region record of this unqiue row is scandinavia . the date record of this unqiue row is 2002 .'}
and { only { filter_eq { all_rows ; format ; double cd } } ; and { eq { hop { filter_eq { all_rows ; format ; double cd } ; region } ; scandinavia } ; eq { hop { filter_eq { all_rows ; format ; double cd } ; date } ; 2002 } } } = true
select the rows whose format record fuzzily matches to double cd . there is only one such row in the table . the region record of this unqiue row is scandinavia . the date record of this unqiue row is 2002 .
{'and_7': 'and', 'result_8': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_9': 'all_rows', 'format_10': 'format', 'double cd_11': 'double cd', 'and_6': 'and', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'region_12': 'region', 'scandinavia_13': 'scandinavia', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'date_14': 'date', '2002_15': '2002'}
['region', 'date', 'label', 'format', 'catalog']
[['united states', '1 august 1976', 'epic records', 'stereo lp', 'pe 34149'], ['europe', '1 august 1976', 'epic records', 'stereo lp', 'epc 81436'], ['australia', '15 november 1976', 'epic records', 'stereo lp', 'elps 3781'], ['japan', '1976', 'epic records', 'stereo lp', '25ap 301'], ['scandinavia', '2002', 'sony music entertainment', 'double cd', 'sm 2965 - 05']]