SELECT 
hd1.alias, 
hd1.domain, 
hd1.dbm,
hd1.domain_lang_code, 
IF(hd1.alias IS NULL,(SELECT hd2.domain FROM http_domains AS hd2 WHERE hd2.id = hd1.alias),hd1.domain) AS domain_base,
IF(hd1.alias IS NULL,(SELECT hd2.dbm FROM http_domains AS hd2 WHERE hd2.id = hd1.alias),hd1.dbm) AS dbmx,
IF(hd1.alias IS NULL,(SELECT hd2.domain_lang_code FROM http_domains AS hd2 WHERE hd2.id = hd1.alias),hd1.domain_lang_code) AS lang
FROM http_domains AS hd1
WHERE hd1.domain = 'geebooks.xom'