select postid as [Post Link] , count(*) [# of times] from...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

select postid as [Post Link]
     , count(*) [# of times]
from posthistory
where posthistorytypeid in (3,6,9)
and text like '%<featured>%'
group by postid
order by min(creationdate)


select concat('site://q/', id,'|', deletiondate) [Link]
from postswithdeleted
where posttypeid = 1
and deletiondate is not null
and tags like '%<featured>%'

Enter Parameters

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