CiviCRM Community Forums (archive)

I am trying to find out if when a member signs up and changes their membership to a lower level membership, if their Joomla! access changes as well back.  I can’t seem to do this kind of query from the admin panel but I think if I could run a query from my cPanel I think I could tell if this is happening.  Can some of you SQL gurus help me with this?

I need to know if a ‘civicrm_membership’ ‘contact_id’ has a ‘civicrm_membership’ ‘membership_type_id’ = “<number A>”

where the ‘het_user_usergroup_map’ ‘user_id’ has a ‘<db>_user_usergroup_map’ ‘group_id’ = “<number B>”

given that ‘civicrm_uf_match’ ‘contact_id’ is linked to ‘civicrm_uf_match’ ‘uf_id’
provide from ‘<db>_users’ ‘username’ where ‘<db>_users’ ‘id’ = ‘<db>_user_usergroup_map’ ‘user_id’

Notes
<db> is my database prefix
<number A> is the number of a specific CiviCRM membership type
<number B> is the number of specific Joomla security level