SELECT
(
SELECT CONCAT(CONCAT(SUBSTRING_INDEX(a.ent_tag,'|',1), CONCAT('|', CONCAT(GROUP_CONCAT(b.tag_name), '|'))),SUBSTRING_INDEX(a.ent_tag,'|',-1)) FROM
(
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(a.ent_tag,'|',1),'&', b.help_topic_id + 1), '&', -1) tagCode
FROM mw_ent_post a JOIN mysql.help_topic b ON b.help_topic_id < (LENGTH(SUBSTRING_INDEX(a.ent_tag,'|',1)) - LENGTH(REPLACE(SUBSTRING_INDEX(a.ent_tag,'|',1), '&', '')) + 1)
WHERE a.id = 7
) a
LEFT JOIN mw_code_ent_tag b ON a.tagCode = b.tag_code
) tagName FROM mw_ent_post a WHERE a.id = 7