Made old ChatLine's code even more ugly by adding some more write-only code to it.

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

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