as I am using latest version of MariaDB that has that function available, which makes the difference.
I guess you are right and making it more resilient by taking the SQL functions and moving the logic into Javascript.
Thank you Justin for looking at this. I can also confirm that this is actually the problem,