Plesk get Current Active Domain

pleskexpiredomain.sql

SELECT d.name dateexpire, FROM_UNIXTIME(l.value) expiredate FROM SubscriptionProperties sp 
LEFT JOIN Subscriptions s ON s.id = sp.subscription_id
LEFT JOIN domains d ON d.id = s.object_id
LEFT JOIN Limits l ON l.id = sp.value
WHERE sp.`name` = 'limitsId' AND l.limit_name = 'expiration' AND FROM_UNIXTIME(l.value) > CURDATE()
ORDER BY l.value desc