SQL Query: SELECT uid as url_id, u.site_id, url, sum( cc ) c, title
FROM (SELECT `site_id` , `url_id` as uid, count( `url_id` ) `cc`
FROM `wp_7_firestats_hits` h, `wp_7_firestats_useragents` ua
WHERE h.useragent_id = ua.id AND `excluded_ip` = '0'
AND `excluded_by_user` = '0'
AND `excluded_user` = '0'
AND `match_bots`='0'
AND h.`site_id` = '7' AND `timestamp` >= FROM_UNIXTIME(1275704061)
GROUP BY `site_id` , `url_id` UNION ALL SELECT `site_id` , `url_id` as uid, `views` AS cc FROM `wp_7_firestats_archive_pages` d, `wp_7_firestats_archive_ranges` r
WHERE d.range_id = r.range_id AND `site_id` = '7'
AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1275704061),1,10)) `u2` , `wp_7_firestats_urls` `u`
WHERE u.id = uid AND type = '1'
GROUP BY `site_id`, `uid`
ORDER BY c DESC LIMIT 10 Powered by FireStats
SQL Query: SELECT COUNT(*) FROM `wp_7_firestats_hits` h,`wp_7_firestats_useragents` u WHERE h.useragent_id=u.id AND `excluded_ip` = '0'
AND `excluded_by_user` = '0'
AND `excluded_user` = '0'
AND `match_bots`='0'
AND `site_id` = '7' AND 1
SQL Query: SELECT SUM(u.c) c FROM (SELECT COUNT(DISTINCT(ip)) c
FROM `wp_7_firestats_hits` h,`wp_7_firestats_useragents` u
WHERE h.useragent_id=u.id AND `excluded_ip` = '0'
AND `excluded_by_user` = '0'
AND `excluded_user` = '0'
AND `match_bots`='0'
AND `site_id` = '7' AND 1
GROUP BY SUBSTRING(`timestamp`,1,10),site_id) u
Pages displayed in last 24 hours : Database error: Table 'greenpar_wpmu.wp_7_firestats_hits' doesn't exist
SQL Query: SELECT COUNT(*) FROM `wp_7_firestats_hits` h,`wp_7_firestats_useragents` u WHERE h.useragent_id=u.id AND `excluded_ip` = '0'
AND `excluded_by_user` = '0'
AND `excluded_user` = '0'
AND `match_bots`='0'
AND `site_id` = '7' AND `timestamp` >= FROM_UNIXTIME(1283394972)
Unique visitors in last 24 hours : Database error: Table 'greenpar_wpmu.wp_7_firestats_hits' doesn't exist
SQL Query: SELECT SUM(u.c) c FROM (SELECT COUNT(DISTINCT(ip)) c
FROM `wp_7_firestats_hits` h,`wp_7_firestats_useragents` u
WHERE h.useragent_id=u.id AND `excluded_ip` = '0'
AND `excluded_by_user` = '0'
AND `excluded_user` = '0'
AND `match_bots`='0'
AND `site_id` = '7' AND `timestamp` >= FROM_UNIXTIME(1283394972)
GROUP BY SUBSTRING(`timestamp`,1,10),site_id) u