Posted November 9, 20204 yr Hi There, Can any SQL expert please help in creating a query to fetch following data in excel for our paid members (only)? email phone fn ln zip ct st country gen value Email: Email address Phone: Mobile Number fn: First Name ln: Last Name Zip: PO Box ct: City st: City country: Country Gen: Gender Value: Total Spent Thanks in advance.
November 9, 20204 yr I believe you can do this via the "Download member list thing: Change things to "expired" and cancelled active I think the "Total Spent" there at the bottom should work.
November 10, 20204 yr Author I tried it and it didn't have any options for fn: First Name ln: Last Name Zip: PO Box ct: City Value: Total Spent
November 11, 20204 yr That data is stored in Commerce and would need to be pulled separately. Members can have more than one address so it's a bit trickier than just a specific SQL query.
November 11, 20204 yr Author Thanks, so is there any way out I can fetch half details with "members list" and then remaining ones with SQL and then rebuild excel manually?
