Search for a getAlias: Returned empty set
SELECT a.alias, a.language
FROM cor_tbl_alias AS a, cor_tbl_module AS b
WHERE
CASE
WHEN a.language = 'en' THEN a.language = 'en'
ELSE a.language = 'en'
END
AND a.aliastype = 1
AND a.itemkey = 'cor_tbl_module'
AND a.itemvalue = b.id
AND b.itemkey = 'fst_cd=AIAC773'
item...
