SQL Query: SELECT h.url_id,u.`site_id`,`url`, COUNT(h.url_id) `c`, title
FROM `wp_firestats_hits` h, `wp_firestats_useragents` ua , `wp_firestats_urls` u
WHERE h.url_id = u.id
AND type = '1'
AND h.useragent_id = ua.id
AND `excluded_ip` = '0'
AND `excluded_by_user` = '0'
AND `excluded_user` = '0'
AND `match_bots`='0'
AND h.`site_id` = '1'
AND `timestamp` >= FROM_UNIXTIME(1228739709)
GROUP BY `site_id` , h.url_id ORDER BY c DESC LIMIT 5 由FireStats提供支持