sun sun
the album sun sun by the japanese fusion group casiopea was first released as a cd by alfa records on september 10 , 1986 .
{'scope': 'subset', 'row': '2', 'col': '2', 'order': '1', 'col_other': '3', 'max_or_min': 'min_to_max', 'value_mentioned': 'yes', 'subset': {'col': '4', 'criterion': 'equal', 'value': 'cd'}}
{'func': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'nth_min', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'format', 'cd'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; format ; cd }', 'tointer': 'select the rows whose format record fuzzily matches to cd .'}, 'date', '1'], 'result': 'september 10 , 1986', 'ind': 1, 'tostr': 'nth_min { filter_eq { all_rows ; format ; cd } ; date ; 1 }', 'tointer': 'select the rows whose format record fuzzily matches to cd . the 1st minimum date record of these rows is september 10 , 1986 .'}, 'september 10 , 1986'], 'result': True, 'ind': 2, 'tostr': 'eq { nth_min { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; september 10 , 1986 }', 'tointer': 'select the rows whose format record fuzzily matches to cd . the 1st minimum date record of these rows is september 10 , 1986 .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmin', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'format', 'cd'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; format ; cd }', 'tointer': 'select the rows whose format record fuzzily matches to cd .'}, 'date', '1'], 'result': None, 'ind': 3, 'tostr': 'nth_argmin { filter_eq { all_rows ; format ; cd } ; date ; 1 }'}, 'label'], 'result': 'alfa records', 'ind': 4, 'tostr': 'hop { nth_argmin { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; label }'}, 'alfa records'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { nth_argmin { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; label } ; alfa records }', 'tointer': 'the label record of the row with 1st minimum date record is alfa records .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { nth_min { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; september 10 , 1986 } ; eq { hop { nth_argmin { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; label } ; alfa records } } = true', 'tointer': 'select the rows whose format record fuzzily matches to cd . the 1st minimum date record of these rows is september 10 , 1986 . the label record of the row with 1st minimum date record is alfa records .'}
and { eq { nth_min { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; september 10 , 1986 } ; eq { hop { nth_argmin { filter_eq { all_rows ; format ; cd } ; date ; 1 } ; label } ; alfa records } } = true
select the rows whose format record fuzzily matches to cd . the 1st minimum date record of these rows is september 10 , 1986 . the label record of the row with 1st minimum date record is alfa records .
{'and_6': 'and', 'result_7': 'true', 'eq_2': 'eq', 'nth_min_1': 'nth_min', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_8': 'all_rows', 'format_9': 'format', 'cd_10': 'cd', 'date_11': 'date', '1_12': '1', 'september 10 , 1986_13': 'september 10 , 1986', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'nth_argmin_3': 'nth_argmin', 'date_14': 'date', '1_15': '1', 'label_16': 'label', 'alfa records_17': 'alfa records'}
['region', 'date', 'label', 'format', 'catalog']
[['japan', 'september 10 , 1986', 'alfa records', 'stereo lp', 'alr - 28085'], ['japan', 'september 10 , 1986', 'alfa records', 'cd', '32xa - 90'], ['japan', 'march 21 , 1992', 'alfa records', 'cd', 'alca - 285'], ['japan', 'august 31 , 1994', 'alfa records', 'cd', 'alca - 9015'], ['japan', 'august 29 , 1998', 'alfa records', 'cd', 'alca - 9210'], ['japan', 'february 20 , 2002', 'village records', 'ed remaster cd', 'vrcl - 2215'], ['japan', 'march 13 , 2002', 'village records', 'ed remaster cd', 'vrcl - 2235'], ['japan', 'may 27 , 2009', 'sony music direct', 'ed remaster cd', 'mhcl - 20017']]