SELECT COUNT(*) AS result
FROM table2 
WHERE YEAR(_data) = YEAR(CURRENT_DATE())
AND DAYOFYEAR(_data) = DAYOFYEAR(CURRENT_DATE())
UNION ALL
SELECT COUNT(*) AS result
FROM table2 
WHERE YEAR(_data) = YEAR(CURRENT_DATE())
AND MONTH(_data) = MONTH(CURRENT_DATE())
UNION ALL
SELECT COUNT(*) AS result
FROM table2 

SELECT
       COUNT(IF(YEAR(_data) = YEAR(CURRENT_DATE())
                AND DAYOFYEAR(_data) = DAYOFYEAR(CURRENT_DATE()),
                ip,
                NULL
                )
            )
       AS today,

       COUNT(IF(YEAR(_data) = YEAR(CURRENT_DATE())
                AND MONTH(_data) = MONTH(CURRENT_DATE()),
                ip,
                NULL
               )
            )
       AS current_month,

       COUNT(*)
       AS total

FROM table2