Estadísticas de envios de correo en Plesk 12 con mysql

1. Estadísticas de tráfico SMTP del mes actual, ordenada por dominios

SELECT name, CONCAT(YEAR(date),’-‘,MONTH(date)) fecha,
SUM(smtp_out/1024/1024) as smtp_out,  SUM(smtp_in/1024/1024) as
smtp_in
FROM DomainsTraffic
INNER JOIN domains ON domains.id = DomainsTraffic.dom_id
WHERE YEAR(date)=YEAR(now()) and MONTH(date)=MONTH(now())
GROUP BY name
ORDER BY name

2. Estadísticas diarias para un dominio

SELECT name, date fecha, SUM(smtp_out/1024/1024) as smtp_out,
SUM(smtp_in/1024/1024) as smtp_in
FROM DomainsTraffic
INNER JOIN domains ON domains.id = DomainsTraffic.dom_id
WHERE name = ‘dominio.com’
AND YEAR(date)=YEAR(now())
AND MONTH(date)=MONTH(now())
GROUP BY date
ORDER BY name;