SELECT xj_materieltype.code maxCode, (SELECT max(xj_materieltype.sort) from xj_materieltype ) maxSort from xj_materieltype
WHERE xj_materieltype.code like 'LH%' AND xj_materieltype.parentid = '909a06fa64c94f5aa790f298b0b5fcff'
ORDER BY
(SUBSTRING_INDEX(xj_materieltype.`code`,'-',1)+0),(SUBSTRING_INDEX(xj_materieltype.code,'-',-1)+0) DESC
LIMIT 0,1