I answer to mysqelf.
Form some mysterious reason that relationship is now in dom_param.
dom_id points to hosting.dom_id
look for a param = 'ip_addr_id'
Its value points to IP_Addresses.
So, for example...
SELECT domains.name, IP_Addresses.ip_address
FROM domains
INNER JOIN...