|
|
Click here for free registration and you will be able to see what visitors do on your website!TOP websitesSELECT `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
| No | Webpage | Last 30 days | Previous period | Change |
|---|
| | 0 | 0 | 0% |
|