Execute SQL Query

[nautiqeman]

I need to manually run a query to generate a list.

I'm in a transition from one site to another with my members. I need to find out all the member's email address and User ID that have paid for a certain subscription.

How would I run this so that I can get the list to copy and paste into an Excel sheet?

[rake]

SELECT subscriptionlog.*,user.username,user.userid,user.e mail FROM subscriptionlog LEFT JOIN user USING(userid) WHERE subscriptionid=X

try that query.