SQL code to retrieve the current address.

SELECT value FROM dns_map WHERE
id =
(
SELECT id FROM dns_map WHERE
value = 'www.automobile.org' AND
sdate IS NULL
) AND
type = DNS_ADDRESS AND
sdate IS NULL