'Return the id, name and email of partners listening to the given channel'

@api.model
def channel_fetch_listeners(self, uuid):

    self._cr.execute('\n                                                SELECT    P.id,    P.name,    P.email\n                                                FROM    mail_channel_partner    CP\n                                                                INNER    JOIN    res_partner    P    ON    CP.partner_id    =    P.id\n                                                                INNER    JOIN    mail_channel    C    ON    CP.channel_id    =    C.id\n                                                WHERE    C.uuid    =    %s', (uuid,))
    return self._cr.dictfetchall()
