Web-Assistant.eu
Track your website users
Change language: Register | Log in
Click here for free registration and you will be able to see what visitors do on your website!

TOP websites

SELECT `log`.`cid`, `count`, `count2`, `count`*100/`count2`-100 AS `perc`, `websites`.* FROM `log` LEFT JOIN (SELECT `cid`, COUNT(DISTINCT `wau`) AS `count` FROM `log` WHERE `date` >= DATE_SUB(NOW(), INTERVAL 30 DAY) GROUP BY `cid`) AS `visitors` ON `visitors`.`cid`=`log`.`cid` LEFT JOIN (SELECT `cid`, COUNT(DISTINCT `wau`) AS `count2` FROM `log` WHERE `date` < DATE_SUB(NOW(), INTERVAL 30 DAY) AND `date` >= DATE_SUB(NOW(), INTERVAL 60 DAY) GROUP BY `cid`) AS `visitors2` ON `visitors2`.`cid`=`log`.`cid` LEFT JOIN `websites` ON `websites`.`id`=`log`.`cid` WHERE NOT `id` IS NULL AND NOT `count` IS NULL GROUP BY `log`.`cid` ORDER BY `count` DESC
Incorrect key file for table '/tmp/#sql_2eb_2.MYI'; try to repair it
NoWebpageLast 30 daysPrevious periodChange
000%


Copyright © 2013-2017 www.web-assistant.eu