Merry Christmas and a Happy New Year
Wishing everyone a Great Christmas and Joyous New Year
All the best
Andy
FireStats
- Pages displayed : 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 1 - Unique visitors : 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 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(1283370783) - 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(1283370783) GROUP BY SUBSTRING(`timestamp`,1,10),site_id) u
Powered by FireStats- Pages displayed : Database error: Table 'kob_recover.wp_firestats_hits' doesn't exist
Popular posts
Database error: Table 'kob_recover.wp_firestats_hits' doesn't exist
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(1275681183) 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(1275681183),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