Here is a part of the mysql query.
SELECT
GROUP_CONCAT(DISTINCT CONCAT('<a href="?rubriqueid=intranet&pageid=gestion§ionid=oeuvres&detail=ok&sourcerub=intranet&sourcepg=gestion¶m1=sectionid&vparam1=volumes_preparation&signet=ovr',O.PK_OEUVRE_OVR, '&id_oeuvre=', O.PK_OEUVRE_OVR,'">', O.TX_TITRE_LATIN_OVR, '</a>') ORDER BY O.TX_TITRE_LATIN_OVR SEPARATOR ', ') AS la_works_links,
GROUP_CONCAT(DISTINCT CONCAT('<a href="?rubriqueid=intranet&pageid=gestion§ionid=oeuvres&detail=ok&sourcerub=intranet&sourcepg=gestion¶m1=sectionid&vparam1=volumes_preparation&signet=ovr',O.PK_OEUVRE_OVR, '&id_oeuvre=', O.PK_OEUVRE_OVR,'">', O.`TX_TITRE_FRANCAIS_OVR`, '</a>') ORDER BY O.`TX_TITRE_FRANCAIS_OVR` SEPARATOR ', ') AS fr_works_links
FROM sc_t_oeuvre AS O
Here is a part of the php/html script to display the outputs.
<tbody>
<?php
while ($pmt = mysqli_fetch_assoc($oRecordset)) {
$works = $pmt['la_works_links'] ?: $pmt['fr_works_links'];
?>
<tr class="datagrid-lignesA text-center" style="line-height: 14px;">
<td style="overflow-wrap: break-word; white-space: pre-wrap; font-weight: bold; font-size:13px;"><?php echo $works; ?></td>
</tr>
<?php } ?>
</tbody>
Here is the display in the browser (chrome, firefox), only in production (stage and local are OK). After displaying four outputs (‘works’), we have the following tag:
<a class="datagrid-lignesA"
href="?rubriqueid=intranet&pageid=gestion§ionid=oeuvres&detail=ok&sourcerub=intranet&sourcepg=gestion¶m1=sectionid&vparam1=volumes_preparation&sig</td>
</tr>
<tr align="
center"="" style="line-height: 14px;">
</a>
Each time, the url is truncated in the middle and the td tag is closed.