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/30 23:23] – daniel | adv_sample_user_queries_plus [2016/03/13 22:24] – daniel | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ==== Advanced | + | ==== Advanced |
=== Messages sent, with senders or recipients from a specific domain, but not tagged with a specified tag: === | === Messages sent, with senders or recipients from a specific domain, but not tagged with a specified tag: === | ||
Line 22: | Line 22: | ||
</ | </ | ||
+ | === Old messages, not archived or trashed, that belong to a thread whose most recent message | ||
+ | <code sql> | ||
+ | SELECT mail_id FROM mail m | ||
+ | WHERE status& | ||
+ | AND msg_date< | ||
+ | AND thread_id is not null | ||
+ | AND not exists | ||
+ | | ||
+ | WHERE m2.thread_id=m.thread_id | ||
+ | AND m2.msg_date> | ||
+ | </ | ||
---- | ---- | ||
See the [[http:// | See the [[http:// | ||
adv_sample_user_queries_plus.txt · Last modified: 2021/05/15 12:21 by daniel