Q&A about the site for members of the workforce navigating the professional setting
select count(*) from posts /*can use id,parentid etc*/ where posttypeid=2 and parentid in ( /*qid*/ SELECT id FROM ( SELECT ROW_NUMBER() OVER(ORDER BY id) NUM, * FROM posts where posttypeid=1 and tags like '%<c>%' and creationdate between '20080101' and '20140101' )A WHERE NUM<=50000 )