Gauravk Posted November 9, 2020 Share Posted November 9, 2020 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. Link to comment Share on other sites More sharing options...
Morrigan Posted November 9, 2020 Share Posted November 9, 2020 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. Gauravk 1 Link to comment Share on other sites More sharing options...
Gauravk Posted November 10, 2020 Author Share Posted November 10, 2020 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 Link to comment Share on other sites More sharing options...
bfarber Posted November 11, 2020 Share Posted November 11, 2020 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. Gauravk 1 Link to comment Share on other sites More sharing options...
Gauravk Posted November 11, 2020 Author Share Posted November 11, 2020 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? Link to comment Share on other sites More sharing options...
CoffeeCake Posted November 25, 2020 Share Posted November 25, 2020 Welcome, time traveler. Here's a solution: Link to comment Share on other sites More sharing options...
Recommended Posts