Here is the reply I got back for TMD hosting:
Thank you for the update.
It appears that the written query is not suitable for this version of MariaDB:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%webm’ AND status IN(‘pending’, ‘processing’, ‘delete’)' at line 1
We have reviewed the MySQL Documentation in an attempt to locate what syntax should be used for your version of MairaDB (10.2.27-MariaDB) - to no avail.
You should possibly contact a database specialist or the team behind UNA, for the proper syntax that should be used for this version of MariaDB.
Additionally, we cannot be certain why this issue would occur, given that all server requirements for the UNA script are beyond covered.
Genius Support Team