Get SSL certificates IP and Domain names

plesk_access_ssl_ip_domain.sql

SELECT        domains.name, ip_addresses.ip_address, certificates.name AS cert_name, certificates.ca_file
FROM            ((domains INNER JOIN
                         hosting ON domains.id = hosting.dom_id) INNER JOIN
                         (ip_addresses INNER JOIN
                         certificates ON ip_addresses.ssl_certificate_id = certificates.id) ON hosting.ip_address_id = ip_addresses.id)
ORDER BY ip_addresses.ip_address