SELECT p.ID, p.post_title, SUM(wp_popularpostsdatacache.pageviews) AS comment_count, p.post_excerpt FROM wp_posts AS p RIGHT JOIN wp_popularpostsdatacache ON p.ID = wp_popularpostsdatacache.id LEFT JOIN wp_postmeta m ON p.ID = m.post_id AND m.meta_key = 'exclude_homepage_popularposts' WHERE p.post_status = 'publish' AND p.post_password = '' AND wp_popularpostsdatacache.day >= NOW() - INTERVAL 7 DAY AND p.post_type = 'post' AND (m.meta_value <> '1' OR m.meta_value IS NULL) GROUP BY p.ID ORDER BY pageviews DESC LIMIT 5