German English  
  -MySQL Error: FUNCTION stellatechsql1.lang does not exist
SELECT tr.tr FROM `text` LEFT OUTER JOIN translation tr ON tr.rowid = `text`.id and tr.column = 'text' and tr.table = 'text' and tr.language = lang() WHERE `text`.`text` LIKE 'HOMEPAGE'