Somehow my SQL Export stopped working, or possibly I am confused.
I added this Query:
SELECT
l.id AS list_id,
l.name AS list_name,
l.active AS list_active,
l.visible AS list_visible,
l.display_name AS list_display_name,
u.id AS user_id,
u.name AS user_name,
u.email AS user_email,
u.creation_date AS user_creation_date,
u.active AS user_active,
u.source AS user_source,
ul.status AS subscription_status,
ul.subscription_date,
ul.unsubscribe_date
FROM
#__acym_list AS l
JOIN
#__acym_user_has_list AS ul ON l.id = ul.list_id
JOIN
#__acym_user AS u ON ul.user_id = u.id
ORDER BY
l.id, ul.subscription_date;
But when I want to run it, ROCSVI asks me to add fields. But in the field Section there are no fields. Also not if I update the list of available fields.
What am I doing wrong?
Also, formerly working SQL Exports somehow have been reverted to custom table exports and the query is gone?
Elisa