Query SQL Database and Add to Excel Doc - BJB Backstage

Watch video

Open Pantheon

Get the database connection info.

Download MySQL Workbench

1. Add the pantheon connection info.
2. Add the below SQL query & click lightning bolt.
3. Click the export button and choose tab separated file.

USE pantheon;
SELECT
	wp_users.user_email,
	wp_pmpro_membership_orders.billing_name,
	wp_onelive_fanclub_presell_codes.`code`,
	wp_pmpro_memberships_users.`status`,
	wp_pmpro_memberships_users.startdate AS presale_order_date,
	wp_pmpro_memberships_users.enddate AS presale_expires
FROM
	wp_pmpro_memberships_users
INNER JOIN wp_pmpro_membership_orders ON wp_pmpro_membership_orders.user_id = wp_pmpro_memberships_users.user_id
INNER JOIN wp_users ON wp_users.ID = wp_pmpro_memberships_users.user_id
INNER JOIN wp_onelive_fanclub_presell_codes ON wp_onelive_fanclub_presell_codes.user_id = wp_pmpro_memberships_users.user_id
WHERE
	wp_pmpro_memberships_users.`status` = 'active'
AND wp_pmpro_memberships_users.startdate NOT LIKE '0000-00-00 00:00:00'
AND wp_pmpro_memberships_users.enddate NOT LIKE '0000-00-00 00:00:00'
GROUP BY
	wp_users.user_email

Convert Tab Separated File to Excel Table

1. Open Excel or Google Sheets
2. Import file
3. Under Selector Type choose Tab