This is not possible from within EV or SQL. Specific item information like you indicate is stored in the indexes, not in the archive information itself. The only option I can think of is if you have Discovery Accelerator.
You can then run a search against 1 archive. When done, export the resultset. this will create 3 additional files (after the export completes) (html, txt, xml) where at least the txt file contains such info. This will show (amongst other information) Author, Subject, Content, Mail Date, NumAttachments and the Original Location (in the mailbox)
Well if only you had mentioned that it is a very big archive instead of asking a generic question :)
As @GertjanA mentioned there is no easy way to do this as the information is not stored in SQL but in the Indexes. You can try and export from the browser (copy paste the results from EV Search) but pagination in Archive Explorer (and infinite scrolling in the new EV Search) makes it much more inconvenient.
I would second @GertjanA and use DA to retrieve this information.
If the requirement is to do this in bulk and using automation, you may incorporate the EV cmdlet Export-EVArchive to export to PST, followed by a PST import to Exchange and then an export to CSV using Powershell / EWS. Let us know if that is what you are looking for :)