:  []

SELECT prov,count(*)AS cont FROM snegozi LEFT JOIN comuni ON  snegozi.idcitta=comuni.idcitta WHERE (categoria=) GROUP BY prov ORDER BY prov 

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 ') GROUP BY prov ORDER BY prov' at line 1