How to query the SQLite table for emails

[URExplorer]

Hi,

What sql can I use - without a WHERE clause - to return From, To, Date of Message, Subject and Body from the Sqlite Urd table?

I imported an mbox file into UltraRecall, which was exported from Thunderbird. The folder in Ultra Recall where all the emails start, is called emails.