list of artists who reached number one on the french singles chart
for artists who reached number one on the french singles chart , when the country is france , the only single that spent 8 weeks at number 1 is n'importe quoi .
{'scope': 'subset', 'row': '2', 'col': '5', 'col_other': '3', 'criterion': 'equal', 'value': '8', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'france'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'france'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; country ; france }', 'tointer': 'select the rows whose country record fuzzily matches to france .'}, 'weeks at 1', '8'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose country record fuzzily matches to france . among these rows , select the rows whose weeks at 1 record is equal to 8 .', 'tostr': 'filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } }', 'tointer': 'select the rows whose country record fuzzily matches to france . among these rows , select the rows whose weeks at 1 record is equal to 8 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'country', 'france'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; country ; france }', 'tointer': 'select the rows whose country record fuzzily matches to france .'}, 'weeks at 1', '8'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose country record fuzzily matches to france . among these rows , select the rows whose weeks at 1 record is equal to 8 .', 'tostr': 'filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 }'}, 'number - one single ( s )'], 'result': "n'importe quoi", 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } ; number - one single ( s ) }'}, "n'importe quoi"], 'result': True, 'ind': 4, 'tostr': "eq { hop { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } ; number - one single ( s ) } ; n'importe quoi }", 'tointer': "the number - one single ( s ) record of this unqiue row is n'importe quoi ."}], 'result': True, 'ind': 5, 'tostr': "and { only { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } } ; eq { hop { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } ; number - one single ( s ) } ; n'importe quoi } } = true", 'tointer': "select the rows whose country record fuzzily matches to france . among these rows , select the rows whose weeks at 1 record is equal to 8 . there is only one such row in the table . the number - one single ( s ) record of this unqiue row is n'importe quoi ."}
and { only { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } } ; eq { hop { filter_eq { filter_eq { all_rows ; country ; france } ; weeks at 1 ; 8 } ; number - one single ( s ) } ; n'importe quoi } } = true
select the rows whose country record fuzzily matches to france . among these rows , select the rows whose weeks at 1 record is equal to 8 . there is only one such row in the table . the number - one single ( s ) record of this unqiue row is n'importe quoi .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_eq_1': 'filter_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'country_8': 'country', 'france_9': 'france', 'weeks at 1_10': 'weeks at 1', '8_11': '8', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'number - one single (s)_12': 'number - one single ( s )', "n'importe quoi_13": "n'importe quoi"}
['artist', 'country', 'number - one single ( s )', 'year', 'weeks at 1', 'straight to 1']
[['paco', 'viet nam', 'amor de mis amores', '1988', '5', 'no'], ['pagny , florent', 'france', "n'importe quoi", '1988', '8', 'no'], ['pagny , florent', 'france', 'savoir aimer', '1997', '9', 'no'], ['pagny , florent', 'france', 'ma liberté de penser', '2003', '6', 'no'], ['pakito', 'france', 'living on video', '2004', '4', 'no'], ['paradis , vanessa', 'france', 'joe le taxi', '1987', '11', 'no'], ['parker jr , ray', 'united states', 'ghostbusters', '1984', '5', 'no'], ['parker , tony', 'france', 'balance - toi', '2007', '1', 'yes'], ['passi', 'france', 'laisse parler les gens 1', '2003', '3', 'no'], ['patti , guesch', 'france', 'étienne', '1987', '5', 'no'], ["pep 's", 'france', 'liberta', '2009', '2', 'yes'], ['peter & sloane', 'france', 'besoin de rien , envie de toi', '1984', '9', 'no'], ['pietri , julie', 'france', 'ève lève - toi', '1986', '1', 'no'], ['pigloo', 'france', 'le papa pingouin', '2006', '3', 'no'], ['pitbull', 'united states', 'i know you want me ( calle ocho )', '2009', '8', 'no'], ['plage , la', 'france', 'coup de boule', '2006', '3', 'no'], ['m pokora', 'france', 'dangerous', '2008', '1', 'yes'], ['pow wow', 'france', 'le chat', '1992', '7', 'no'], ['product g & b , the', 'united states', 'maria maria 1', '2000', '4', 'no']]