[quassel.git] / src / core / SQL / SQLite / 1 / select_buffers.sql

SELECT DISTINCT buffer.bufferid, buffername, network.networkid, networkname
FROM buffer
JOIN network ON buffer.networkid = network.networkid
JOIN backlog ON buffer.bufferid = backlog.bufferid
WHERE buffer.userid = :userid AND time >= :time