Notificação "Oi" em massa

[MateusONunes]

hermes_monitor._checkNotify

        select mm.id, mm.res_id, mm.body, mm.author_id
          from hermes_token ht,
               mail_channel_partner mcp left join hermes_monitor hm 
                                               on (hm.partner_id = mcp.partner_id and hm.channel_id = mcp.channel_id),
               mail_message mm 
         where mcp.partner_id = ht.partner_id
           and mm.id > ht.idlastmessage /*consider from the moment the token loaded*/
           and mm.res_id = mcp.channel_id
           and mm.author_id <> mcp.partner_id /*disregard the author of the message*/
           and mm.id > greatest(coalesce(hm.idlastmessage, 0), coalesce(hm.idlastnotify, 0))
           and mm.message_type = 'comment'
        order by hm.partner_id, mm.id

select * from mail_message mm where mm.id = 191 -- Mensagem que ficou em loop

4