Popular posts
Database error: Table 'db321540837.wp_21_firestats_hits' doesn't exist
MySQL Version: 5.0.92-1~ui40+1
SQL Query:
SELECT url_id, u.site_id, url, sum(cc) c, title FROM (SELECT url_site_id site_id, url_id, count(url_id) cc FROM wp_21_firestats_hits h WHERE `url_site_id` = 21 AND `timestamp` >= FROM_UNIXTIME(1329877291) GROUP BY url_id UNION ALL SELECT site_id, url_id, sum(views) AS cc FROM wp_21_firestats_archive_pages d, wp_21_firestats_archive_ranges r WHERE d.range_id = r.range_id AND `site_id` = 21 AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1329877291),1,10) GROUP BY url_id) u , wp_21_firestats_urls urls WHERE u.url_id = urls.id AND type = '1' GROUP BY url_id ORDER BY c DESC LIMIT 10
Powered by FireStats
Powered by FireStats