User Tools

Site Tools


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 revision
Previous revision
Next revisionBoth sides next revision
sample_user_queries [2012/10/19 20:46] danielsample_user_queries [2014/07/22 13:15] daniel
Line 35: Line 35:
 SELECT mail_id FROM mail_addresses WHERE addr_type in (2,3) GROUP BY mail_id having count(*)>20 SELECT mail_id FROM mail_addresses WHERE addr_type in (2,3) GROUP BY mail_id having count(*)>20
 </code> </code>
 +
 +Messages for which any sender or recipient is from a given domain
 +<code sql>
 +select a.mail_id from mail_addresses a join addresses using(addr_id) where email_addr like '%@example.com'
 +</code>
 +
 +
 +----
 +
 +See the [[http://www.manitou-mail.org/doc/mdx/database-schema.html|database schema documentation]] for definitions of tables and columns.
  
sample_user_queries.txt · Last modified: 2014/08/04 11:23 by daniel