SELECT p.post_title, p.post_date, st.post_ID, st.hits as cnt
FROM wp_most_read_hits st, wp_posts p
WHERE p.ID = st.post_ID AND p.post_status = 'publish'
AND DATE_SUB(CURDATE(),INTERVAL 100 DAY) < p.post_date
GROUP BY st.post_ID ORDER BY cnt DESC LIMIT 0, 5