consulta que muestre vacios

[vani18]

hola no funciona,..

Código MySQL:

SELECT u.usuario as usuariost
COUNT(*) as comento
FROM comentarios as c
LEFT JOIN usuarios as u ON c.id_usuario = u.id_usu
 

ni aun si le agrego...group by

me tira este error..

con group by o sin, me dice esto..

...........

#1064 - 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 'COUNT(*) as comento FROM comentarios as c LEFT JOIN usuarios as u ON c.id_usuari' at line 2

-----------------------