Error exporting Accounts:
.SELECT accounts.*,email_addresses.email_address email_address, accounts.name as account_name, users.user_name as assigned_user_name , teams.name AS team_name ,accounts_cstm.selected_c FROM accounts INNER JOIN (select tst.team_set_id from team_sets_teams tst INNER JOIN team_memberships team_memberships ON tst.team_id = team_memberships.team_id AND team_memberships.user_id = '986ab3e3-8713-1677-bd67-510c34e929a1' AND team_memberships.deleted=0 group by tst.team_set_id) accounts_tf on accounts_tf.team_set_id = accounts.team_set_id LEFT JOIN users ON accounts.assigned_user_id=users.id LEFT JOIN team_sets ts ON accounts.team_set_id=ts.id AND ts.deleted=0 LEFT JOIN teams teams ON teams.id=ts.id AND teams.deleted=0 AND teams.deleted=0 LEFT JOIN email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where ( accounts.deleted IS NULL OR accounts.deleted=0 ) ORDER BY accounts.id, email_addr_bean_rel.primary_address DESC Query Failed: SELECT DISTINCT accounts.*,email_addresses.email_address email_address, accounts.name as account_name, users.user_name as assigned_user_name , teams.name AS team_name ,accounts_cstm.select DISTINCT d_c FROM accounts INNER JOIN team_sets_teams tst ON tst.team_set_id = accounts.team_set_id INNER JOIN team_memberships team_memberships ON tst.team_id = team_memberships.team_id AND team_memberships.user_id = '986ab3e3-8713-1677-bd67-510c34e929a1' AND team_memberships.deleted=0 LEFT JOIN users ON accounts.assigned_user_id=users.id LEFT JOIN team_sets ts ON accounts.team_set_id=ts.id AND ts.deleted=0 LEFT JOIN teams teams ON teams.id=ts.id AND teams.deleted=0 AND teams.deleted=0 LEFT JOIN email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where ( accounts.deleted IS NULL OR accounts.deleted=0 ) ORDER BY accounts.id, email_addr_bean_rel.primary_address DESC: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT d_c FROM accounts INNER JOIN team_sets_teams tst ON tst.team_set_id =' at line 3