I am looking for a way to have either one or multiple mysql query statements. I want to be able to do a mysql search that will return the total number of active member for a specific product or by product. No difference. Either way, what I want to do is be able to capture the totals. I have several sites running amember and want to be able to have from one php page, get stats for all my different domains. Only way to do this is by querying the amember databases separately. However, I do not how to format the mysql query statement. Please help. Been trying to figure this out for months and it is beyond me.