Re: [Dbmail] imap search query

2015-03-05 Thread Jure Pečar
On Wed, 4 Mar 2015 13:21:04 +0100 Jure Pečar wrote: > SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts p > LEFT JOIN dbmail_partlists l ON p.id=l.part_id > LEFT JOIN dbmail_physmessage s ON l.physmessage_id=s.id > LEFT JOIN dbmail_messages m ON m.physmessage_id=s.id >

Re: [Dbmail] imap search query

2015-03-05 Thread Thomas Raschbacher
Am 05.03.2015 um 17:28 schrieb Jure Pečar: > On Wed, 4 Mar 2015 13:21:04 +0100 > Jure Pečar wrote: > >> SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts p >> LEFT JOIN dbmail_partlists l ON p.id=l.part_id >> LEFT JOIN dbmail_physmessage s ON l.physmessage_id=s.id >> LEFT JOI

Re: [Dbmail] imap search query

2015-03-05 Thread Claas Kähler
Is there really somebody that uses DBMail with SQLite??? Does this make sense? Am 06.03.15 um 07:48 schrieb Thomas Raschbacher: Am 05.03.2015 um 17:28 schrieb Jure Pečar: On Wed, 4 Mar 2015 13:21:04 +0100 Jure Pečar wrote: SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts p LEFT