1
SELECT messageid, bufferid, time, type, flags, sender, message
3
JOIN sender ON backlog.senderid = sender.senderid
4
WHERE backlog.bufferid IN (SELECT bufferid FROM buffer WHERE userid = :userid)
5
AND backlog.messageid >= :firstmsg
6
AND backlog.messageid < :lastmsg
7
ORDER BY messageid DESC