Upcoming REIC Events
Register for a live REIC event here: http://bit.ly/drvnUh
Register for a REIC Webinar here: http://bit.ly/bWFsNE
Popular posts
Database error: Table 'db321540837.wp_35_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_35_firestats_hits h WHERE `url_site_id` = 35 AND `timestamp` >= FROM_UNIXTIME(1329623319) GROUP BY url_id UNION ALL SELECT site_id, url_id, sum(views) AS cc FROM wp_35_firestats_archive_pages d, wp_35_firestats_archive_ranges r WHERE d.range_id = r.range_id AND `site_id` = 35 AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1329623319),1,10) GROUP BY url_id) u , wp_35_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