They are same subscriptions, one is expired one is active for members. In the export function in amember, its listing in Excel they are expired members.what is the fix to show only those who hold an expired subscription that doesn't have an active subscription?
Ok that is great for me I guess but the one that will be using the system to export into a mail merge will not be able to do this. How can this be done without using an SQL statement? Thanks
OK. Great I think that is providing the same results. I noticed it didn't export the expiration date from the sql statement results. How would I include the expiration date and the subscription in which is expired? (It's required since its being included in the mailmerge) Thank you
I'm on version 3.1.9. I need a easy method to export all members between 1/1/2011 and the current date that has an any expired subscription between that date, BUT do not include members who has an active subscription of any sort during that time frame. Members renew using the same subscription (5 different types). If it expires on 2/20/2011 but they renew on 2/25/2011 they are exported to the list as expired. Any thoughts? Thanks
You can do this using this query: Code: select * from amember_members m left join amember_payments p on m.member_id = p.member_id where m.status =2 and p.expire_date > '2011-01-01' This will return all members who expired after 01/01/2011