jayd3e · August 29, 2015 14:02
diff --git a/gistfile1.txt b/gistfile1.txt
 select count(distinct(posts.id)) from posts 
 left outer join comments on posts.id = comments.post_id 
 where comments.id is not null and posts.deleted is null and comments.deleted is null;
	select count(distinct(posts.id)) from posts
	left outer join comments on posts.id = comments.post_id
	where comments.id is not null and posts.deleted is null and comments.deleted is null;