226
227
228
229
230
231
232
233
234
235
|
from parsav_rels as r
left join ntimes as nt on nt.uid = r.relatee
where
r.since >= coalesce(nt.when,0) and
r.kind = <rel:follow>
), allnotices as (table acts union table replies union table follows)
table allnotices order by (notice).when desc
);
|
|
226
227
228
229
230
231
232
233
234
235
236
|
from parsav_rels as r
left join ntimes as nt on nt.uid = r.relatee
where
r.since >= coalesce(nt.when,0) and
r.kind = <rel:follow>
), allnotices as (table acts union table replies union table follows)
select * from allnotices where rcpt <> (notice).who
order by (notice).when desc
);
|