Stuff

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 langFROM http_domains AS hd1WHERE hd1.domain = 'geebooks.xom'