SELECT
a.pwd,
b.help_topic_id,
substring_index(substring_index(a.addr, '|', b.help_topic_id + 1), '|', - 1) AS address
FROM pwd_addr a
JOIN mysql.help_topic b
ON b.help_topic_id < (length(a.addr) - length(REPLACE(a.addr, '|', '')) + 1)
order by a.pwd
