adv_sample_user_queries_plus
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
adv_sample_user_queries_plus [2014/08/04 11:14] – daniel | adv_sample_user_queries_plus [2014/08/30 23:23] – daniel | ||
---|---|---|---|
Line 14: | Line 14: | ||
</ | </ | ||
+ | === Latest outgoing message per distinct recipient (to which a message was ever addressed): === | ||
+ | <code sql> | ||
+ | select mail_id from (select distinct on (m1.addr_id) m.mail_id, | ||
+ | from mail_addresses m1 join mail m using(mail_id) | ||
+ | where m1.addr_type=2 and m.status& | ||
+ | order by m1.addr_id, | ||
+ | </ | ||
---- | ---- |
adv_sample_user_queries_plus.txt · Last modified: 2021/05/15 12:21 by daniel