Hi! We have deployed a system which uses aMember's authentication. In the echo system there are tools that lists aMember's users status (Expired or Never bought any product etc). Users' normally don't use aMembers portal unless they require to buy any product or renew his product. We have few questions: 1. Is there any SQL query to know the list of users with their membership expiry date? 2. If users pay for a product his status becomes 1 (active). If the users never logins to the portal how his status will be changed. aMember authenticates users even he doen't buy or his subscription expires. 3. When a customer buys a product he automatically becomes recursive (no end date) though our product is a one time purchase for certain days and there no recurrence set. We enforce users to buy product as soon as it expires. We want the expire_date of access table should be something our product suggests. Like DATE_ADD(NOW(), INTERVAL 30 DAY). Is it posible? Thanks for your help. --Marlon