Cacher is the code snippet organizer for pro developers

SELECT concat(c.category_key, concat('.', t.name)) AS fullname,
       c.category_key,
       t.name,
       l.locale_name,
       v.value
FROM locale_term t
JOIN locale_category c ON t.category_id = c.id
JOIN locale_value v ON v.term_id = t.id
JOIN locale l ON l.id = v.locale_id
WHERE t.name = 'transfers-link'
  AND c.category_key = 'portal.label';