You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pro.estoque > 0
GROUP BY pro.codigo
ORDER BY  estoque DESC,  pro.titulo  

 ' at line 8