I'm not seeing where the cancellation of a membership is stored in amember. I've tried to follow the script, but I'm just not seeing it. For example, in member.html, it will show a user's specific subscription as cancelled if $p.data.CANCELLED. But I've been unable to find where this is pulled from in the db. Basically, I want to get a listing of all my active members of product_id 3 who have cancelled and thus will not renew at the end of the month. I'm using the following query to get my active members. What additional AND do I need to add to the WHERE to show only cancelled people? SELECT login, email, name_f, amember_payments.member_id FROM amember_members, amember_payments WHERE amember_payments.product_id =3 AND amember_payments.completed =1 AND amember_payments.expire_date > '2008-07-01' AND amember_members.member_id = amember_payments.member_id