#NEWLINE# def get_statement( self , langs ) : #NEWLINE# #INDENT# "Get the participant's statement in the language that best matches\n        the list provided.\n        " #NEWLINE# return self . db . one ( '\n            SELECT content, lang\n              FROM statements\n              JOIN enumerate(%(langs)s) langs ON langs.value = statements.lang\n             WHERE participant=%(id)s\n          ORDER BY langs.rank\n             LIMIT 1\n        ' , dict ( id = self . id , langs = langs ) , default = ( None , None ) )