Reframing the SQL query

Hello All,

I am trying to reframe the below SQL query so that the

select concat(concat(concat(concat(concat(concat(concat(concat(concat (concat (geo.name, '-'), pc1.value),'-'),pc2.value),'-'), pc3.value),'-'), pc4.value),'-'),pc5.value) from geographicplace geo
inner join place_char pc1 on pc1.charowner=geo.entityid
inner join place_char pc2 on pc2.charowner=geo.entityid
inner join place_char pc3 on pc3.charowner=geo.entityid
inner join place_char pc4 on pc4.charowner=geo.entityid
inner join place_char pc5 on pc5.charowner=geo.entityid
where pc1.name='id_thoroughfare'