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 'pro.estoque > 0
GROUP BY pro.codigo
ORDER BY  estoque DESC, ordem,  pro.tit...' at line 8