MySQL Version: SQL Query: SELECT url_id,`site_id`, COUNT(h.url_id) `c`, title
FROM `wp_firestats_hits` h, `wp_firestats_urls` urls
WHERE
h.url_id = urls.id
AND type = '1'
AND urls.`site_id` = 1
AND `timestamp` >= FROM_UNIXTIME(1223674189)
GROUP BY h.url_id ORDER BY c DESC LIMIT 10 Powered by FireStats
Till Canada
-11 Weeks -4 Days -20 Hours -74 Days -20 Hours 211.7283% of the way