[SOLVED] MySQL Queries

I'm not great with MySql queries. I was wondering if there's a list or user resource of common queries to return results for Expired Members, Members Expiring in XX days, etc.

My client has admins that are not comfortable with the backend of the site and so I'm building out some JDBExport queries for them on the front end. But I am a true beginner on this stuff and would like to see some successful queries and/or steal a few already worked out.

As an alternative, I'd love a way to put some of the backend filter functions on the front page as a menu item.

Why doesn't Joomlapolis have a plugin or something that can generate these queries? I'd pay for it.

Or is there something I'm missing (most likely.)

Any thoughts?

Best,
Mark

Enable debug mode, navigate to CBSubs > Subscriptions, filter the list, then expand the query debugging at the bottom of the page and find the query that looks like it's filtered for the _cbubs_subscriptions table. That'll give you the raw query that you can use in phpmyadmin, etc..

OMG! That's fantastic! I love it.

Thank you!!!

Mark