SELECT
    (SELECT CONCAT("<b><font size=6 color=green>",COUNT(DISTINCT usuario_login),"</font></b>") FROM core_auditoria WHERE fecha=DATE(NOW()) ) as "Hoy",
    (SELECT CONCAT("<b><font size=6 color=navy>",COUNT(DISTINCT usuario_login),"</font></b>") FROM core_auditoria WHERE fecha >= date_sub(now(),INTERVAL 1 WEEK) ) as "Semana",
    (SELECT CONCAT("<b><font size=6 color=red>",COUNT(DISTINCT usuario_login),"</font></b>") FROM core_auditoria WHERE fecha >= date_sub(now(),INTERVAL 4 WEEK) ) as "Mes"


