Click here to view a recorded seminar
Recorded Seminar
Popular posts
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_11_firestats_hits h WHERE `url_site_id` = 11 AND `timestamp` >= FROM_UNIXTIME(1335061974) GROUP BY url_id UNION ALL SELECT site_id, url_id, sum(views) AS cc FROM wp_11_firestats_archive_pages d, wp_11_firestats_archive_ranges r WHERE d.range_id = r.range_id AND `site_id` = 11 AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1335061974),1,10) GROUP BY url_id) u , wp_11_firestats_urls urls WHERE u.url_id = urls.id AND type = '1' GROUP BY url_id ORDER BY c DESC LIMIT 10
