list of number - one singles of 1999 ( canada )
livin ' la vida loca spent the 2nd highest number of weeks on top among all number one singles of 1999 in canada .
{'row': '12', 'col': '3', 'order': '2', 'col_other': '4', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'scope': 'all', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'weeks on top', '2'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; weeks on top ; 2 }'}, 'song'], 'result': "livin ' la vida loca", 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; weeks on top ; 2 } ; song }'}, "livin ' la vida loca"], 'result': True, 'ind': 2, 'tostr': "eq { hop { nth_argmax { all_rows ; weeks on top ; 2 } ; song } ; livin ' la vida loca } = true", 'tointer': "select the row whose weeks on top record of all rows is 2nd maximum . the song record of this row is livin ' la vida loca ."}
eq { hop { nth_argmax { all_rows ; weeks on top ; 2 } ; song } ; livin ' la vida loca } = true
select the row whose weeks on top record of all rows is 2nd maximum . the song record of this row is livin ' la vida loca .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_4': 'all_rows', 'weeks on top_5': 'weeks on top', '2_6': '2', 'song_7': 'song', "livin' la vida loca_8": "livin ' la vida loca"}
['volume : issue', 'issue date ( s )', 'weeks on top', 'song', 'artist']
[['68:10 - 12', '30 november - 4 january 1999 §', '6 §', 'thank u', 'alanis morissette'], ['68:13', '11 january - 18 january ≠', '2 ≠', "it 's all been done", 'barenaked ladies'], ['68:14', '25 january', '1', 'hands', 'jewel'], ['68:15', '1 february', '1', 'you get what you give', 'new radicals'], ['68:16', '8 february', '1', '… baby one more time', 'britney spears'], ['68:17 - 18', 'information still to be obtained for these weeks', 'information still to be obtained for these weeks', 'information still to be obtained for these weeks', 'information still to be obtained for these weeks'], ['68:19', '1 march', '1', 'believe', 'cher'], ['68:20 - 24', '8 march - 5 april', '5', 'every morning', 'sugar ray'], ['68:25 - 26', '12 april - 19 april', '2', 'love song', 'sky'], ['69:1 - 2', '26 april - 3 may', '2', 'no scrubs', 'tlc'], ['69:3 - 5', '10 may - 24 may', '3', 'kiss me', 'sixpence none the richer'], ['69:6 - 13', '31 may - 19 july', '8', "livin ' la vida loca", 'ricky martin'], ['69:14 - 15', '26 july - 2 august', '2', 'beautiful stranger', 'madonna'], ['69:16 - 21', '9 august - 13 september', '6', 'if you had my love', 'jennifer lopez'], ['69:22 - 26 , 70:1 - 6', '20 september - 29 november', '11', 'mambo no 5', 'lou bega'], ['70:7', '6 december', '1', 'smooth', 'santana featuring rob thomas'], ['70:8 - 9', '13 december - 3 january 2000 ÷', '2 ÷', 'blue', 'eiffel 65']]