I am trying, in MariaDB, to transponse a unknow number of rows from a query to columns in order to get a single row.
I search about it but mostly examples were related to a knowing number of rows using pivot tables.
what I am trying to obtain is this:
