Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!

In Partnership with Media Temple

Mint Forum

SQL queries

Bakkel
Minted
Posted on Jan 02, '09 at 07:56 am

Does anyone have some good sql queries to summaries 2008??? Like total amount of posts, best visited post, worst post etc…

Or maybe there’s a pepper to do this for me, but I can’t seem to find one where I can influence the period (01-01-2008 thru 31-12-2008).

Shaun Inman
Mint/Pepper Developer
Posted on Jan 05, '09 at 08:42 am

Mint expires older data (that’s how it stays current, relevant and quick) so even if you were to write some SQL queries to summarize the data in the database it would only reflect the past 5 weeks or 25 MB of data—which ever limit Mint hit first.

You must be logged in to reply. Login above or create an account