popularity

Posts of the Month

Database error: No database selected

SQL Query:
SELECT uid as url_id, u.site_id, url, sum( cc ) c, title FROM (SELECT `site_id` , `url_id` as uid, count( `url_id` ) `cc` FROM `wp_firestats_hits` h, `wp_firestats_useragents` ua WHERE 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(1224601828) GROUP BY `site_id` , `url_id` UNION ALL SELECT `site_id` , `url_id` as uid, `views` AS cc FROM `wp_firestats_archive_pages` d, `wp_firestats_archive_ranges` r WHERE d.range_id = r.range_id AND `site_id` = '1' AND `range_start` >= SUBSTRING(FROM_UNIXTIME(1224601828),1,10)) `u2` , `wp_firestats_urls` `u` WHERE u.id = uid AND type = '1' GROUP BY `site_id`, `uid` ORDER BY c DESC LIMIT 10