SELECT votes object_id COUNT FROM votes INNER JOIN blog_post ON votes

SELECT votes.object_id, COUNT(*)
FROM votes
INNER JOIN blog_post
ON votes.object_id = blog_post.id
WHERE CURRENT_DATE -7 < blog_post.date and blog_post.date < CURRENT_TIMESTAMP 
GROUP BY object_id;