MySQL Version: 5.0.91-community SQL Query: SELECT COUNT(*)
FROM `wp_firestats_hits` h, `wp_firestats_urls` urls
WHERE
urls.id = h.url_id AND
urls.`site_id` = '22' AND
1
MySQL Version: 5.0.91-community SQL Query: SELECT SUM(u.c) c FROM (SELECT COUNT(DISTINCT ip_int1, ip_int2) c
FROM `wp_firestats_hits` h, `wp_firestats_urls` urls
WHERE h.url_id = urls.id
AND urls.`site_id` = '22' AND 1
GROUP BY SUBSTRING(`timestamp`,1,10),site_id) u
Pages displayed in last 24 hours : Database error: Table 'kob_recover.wp_firestats_hits' doesn't exist
MySQL Version: 5.0.91-community SQL Query: SELECT COUNT(*)
FROM `wp_firestats_hits` h, `wp_firestats_urls` urls
WHERE
urls.id = h.url_id AND
urls.`site_id` = '22' AND
`timestamp` >= FROM_UNIXTIME(1283373684)
Unique visitors in last 24 hours : Database error: Table 'kob_recover.wp_firestats_hits' doesn't exist
MySQL Version: 5.0.91-community SQL Query: SELECT SUM(u.c) c FROM (SELECT COUNT(DISTINCT ip_int1, ip_int2) c
FROM `wp_firestats_hits` h, `wp_firestats_urls` urls
WHERE h.url_id = urls.id
AND urls.`site_id` = '22' AND `timestamp` >= FROM_UNIXTIME(1283373684)
GROUP BY SUBSTRING(`timestamp`,1,10),site_id) u
MySQL Version: 5.0.91-community 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_firestats_hits` h, `wp_firestats_urls` urls
WHERE h.url_id = urls.id AND urls.`site_id` = '22' AND `timestamp` >= FROM_UNIXTIME(1275684084)
GROUP BY `url_id` UNION ALL SELECT `site_id` , `url_id` as uid, `views` AS cc
FROM `wp_firestats_archive_pages` d, `wp_firestats_archive_ranges` r, `wp_firestats_urls` urls
WHERE d.range_id = r.range_id AND urls.id = d.url_id AND urls.`site_id` = '22'
AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1275684084),1,10)) `u2` , `wp_firestats_urls` `u`
WHERE u.id = uid AND type = '1'
GROUP BY `site_id`, `uid`
ORDER BY c DESC LIMIT 10 Powered by FireStats