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 ')  )  AND pro.codigo IN(SELECT codigo_tribox FROM trbx_produtos_imagens GROUP...' at line 14