num

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

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
            )

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results