1 INSERT INTO backlog (time, bufferid, type, flags, senderid, senderprefixes, message)
2 VALUES (:time, :bufferid, :type, :flags,
3 (SELECT senderid FROM sender WHERE sender = :sender AND coalesce(realname, '') = coalesce(:realname, '') AND coalesce(avatarurl, '') = coalesce(:avatarurl, '')),
4 :senderprefixes, :message