mysql 访问量 统计_MySQL页面访问统计及排名情况

MySQL页面访问统计及排名情况

统计访问页面数量，以分辨率进行排名

SELECT CONCAT(`height` , '*', `width`) AS `resolution` , COUNT(CONCAT(`height`, '*', `width`)) AS `total`

FROM `wifi_status_page`

GROUP BY CONCAT(`height`, '*', `width`)

ORDER BY `total` DESC

LIMIT 0 , 30

最近7天页面访问量，每日统计数量，以日期为序

SELECT td AS showdate, COALESCE( totalcount, 0 ) AS totalcount

FROM (

SELECT CURDATE( ) AS td

UNION ALL SELECT DATE_ADD( CURDATE( ) , INTERVAL -1 DAY )

UNION ALL SELECT DATE_ADD( CURDATE( ) , INTERVAL -2 DAY )

UNION ALL SELECT DATE_ADD( CURDATE( ) , INTERVAL -3 DAY )

UNION ALL SELECT DATE_ADD( CURDATE( ) , INTERVAL -4 DAY )

UNION ALL SELECT DATE_ADD( CURDATE( ) , INTERVAL -5 DAY )

UNION ALL SELECT DATE_ADD( CURDATE( ) , INTERVAL