Facturas a 30,45,60,90 y 120 dias. como hacerlo?

[[enecumene]]

Hola ContraVeneno, Mira lo que me sale:

Error

consulta SQL:
SELECT CASACOMERCIAL, FACTURA,
CASE WHEN datediff( FECHAFACTURA, CurDate( ) ) <30
THEN VALOR
ELSE 0
END AS dias30,
CASE WHEN datediff( FECHAFACTURA, Curdate( ) )
BETWEEN 31
AND 45
THEN VALOR
ELSE 0
END AS dias45,
CASE WHEN datediff( FECHAFACTURA, Curdate( ) )
BETWEEN 46
AND 60
THEN VALOR
ELSE 0
END AS dias60,
CASE WHEN datediff( FECHAFACTURA, CurDate( ) ) >60
THEN VALOR
ELSE 0
END AS masdias60,
FROM TABLA2
LIMIT 0 , 30
MySQL ha dicho:
#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 'From TABLA2
LIMIT 0, 30' at line 1

Saludos