URL
Visitas a todos los sites @ 2017-09-19 02:21 PM
SELECT `site`,`pais_ip`,sum(`visitas`) as `visitas`,max(date_add(`ultima_visita`,interval 90 minute)) as `ultima_visita` FROM `visitas_al_site` where (`site` like '%%' OR `abreviador` = '') and `ultima_visita` BETWEEN DATE_SUB(NOW(), INTERVAL 60 MINUTE) AND NOW() group by `site`,`pais_ip` order by `visitas` desc LIMIT 500