SELECT
core_org_chart.id_dir,
CONCAT('/oc_', cast(core_org_chart.id_dir AS CHAR)) CONCATENATO
from core_org_chart
WHERE translation='Addetti'

questo che ti fa?