SQL query to access specific s2member information of users

[Arpana]

Hi Jason

I am struggling to get the correct SQL query to access s2member information, given a user id. Could you please help me with the following questions:
(1) What is the SQL query to retrive the current access level of the user, given any one of the user's info: a) user name b) user id or c) user email
(2) What is the output value format?
(3) Which table is this information stored and against which reference (is it stored per uid/username/ etc)?

Thank you.
Regards
Arpana

[Arpana]

Hi

Could someone please answer my queries? This is quite crucial for my site to live

thank you.

Regards
Arpana