SELECT
Domain.*,
Pkgaccount.account_name,
CONCAT(User.first_name,' ',User.last_name) AS Subscriber,
Package.*
FROM
zp_subscription_domain_user AS DomainUser
INNER JOIN zp_subscription_domain_info AS Domain ON DomainUser.domain_id = Domain.domain_id
INNER JOIN zp_subscription_account AS Pkgaccount ON Domain.ac_id = Pkgaccount.ac_id
INNER JOIN zp_subscription_package AS Package ON Package.domain_id = Domain.domain_id
INNER JOIN zp_subscription_payment AS Payment ON Package.session_id = Payment.session_id
INNER JOIN zp_users AS User ON User.id = Package.user_id
WHERE
DomainUser.user_id=''
AND (Payment.payment_status ='CONFIRMED' OR Payment.payment_status ='PAYMENTDUE')
AND (DomainUser.is_admin = 'ADMINISTRATOR' || DomainUser.is_admin = 'MODERATOR')
AND DomainUser.status = 'ACTIVE'
GROUP BY
Domain.domain_id
ORDER BY
Package.add_date Unknown column 'Payment.session_id' in 'on clause'
Sales Pipeline Automation