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_19_firestats_hits h
WHERE `url_site_id` = 19 AND `timestamp` >= FROM_UNIXTIME(1329616279)
GROUP BY url_id UNION ALL SELECT site_id, url_id, sum(views) AS cc
FROM wp_19_firestats_archive_pages d, wp_19_firestats_archive_ranges r
WHERE d.range_id = r.range_id AND `site_id` = 19
AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1329616279),1,10) GROUP BY url_id) u , wp_19_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