X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fselect_messagesRange.sql;h=4b7de10cddcea5e2489ca87789fa1c5effb45c36;hb=HEAD;hp=b7af909157e23e4e3b5419ce4c683195f4ac3b6f;hpb=3cf5c49e7753be48a994917fe898730add4292b1;p=quassel.git diff --git a/src/core/SQL/PostgreSQL/select_messagesRange.sql b/src/core/SQL/PostgreSQL/select_messagesRange.sql index b7af9091..4b7de10c 100644 --- a/src/core/SQL/PostgreSQL/select_messagesRange.sql +++ b/src/core/SQL/PostgreSQL/select_messagesRange.sql @@ -1,4 +1,4 @@ -SELECT messageid, time, type, flags, sender, message +SELECT messageid, time, type, flags, sender, senderprefixes, realname, avatarurl, message FROM backlog JOIN sender ON backlog.senderid = sender.senderid WHERE backlog.messageid >= $1