Exporting Dedicated IP in custom format

[alex.bumbacea]

Hello,

Few days ago i needed to get all dedicated ips and the domains assigned to it in a custom format. I tried to make the connections in the pas db, but i wasn't able to print the dedicated ips with multiple domains on them since ip_addresses.default_domain_id is 0 for that ones. Could you please provide help in this matter?

Thank you,

Alexandru Bumbacea

 

[alex.bumbacea]

For to tell. This is the task i run under mysql

SELECT name, ip_address FROM domains
INNER JOIN ip_addresses ON
ip_addresses.default_domain_id=domains.id
WHERE type='exclusive'
LIMIT 0, 10;