Manitou-Mail Wiki

User Tools

Site Tools

Trace:
sample_user_queries

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
sample_user_queries [2012/10/05 01:24] – danielsample_user_queries [2012/10/19 20:44] – daniel
Line 24: Line 24:
 <code sql> <code sql>
 SELECT m.mail_id FROM mail m WHERE msg_date>=now()-'1 month'::interval AND status&256=256 SELECT m.mail_id FROM mail m WHERE msg_date>=now()-'1 month'::interval AND status&256=256
 +</code>
 +
 +Messages that have a lot of recipients (example: more than 20)
 +<code sql>
 +SELECT mail_id FROM mail_addresses WHERE addr_type=2 GROUP BY mail_id having count(*)>20
 </code> </code>
  
sample_user_queries.txt · Last modified: 2014/08/04 11:23 by daniel