Q&A for people interested in the history and origins of science and mathematics
select id as [Post Link] /* , title , charindex('[', title) , charindex(']', title, charindex('[', title)) , case when charindex('[', title) > 0 then substring( title, charindex('[', title) + 1, charindex(']', title, charindex('[', title)) - charindex('[', title) - 1 ) else '?' end */ , (select [count] from stackoverflow.dbo.tags where tagname = case when charindex('[', title) > 0 then substring( title, charindex('[', title) + 1, charindex(']', title, charindex('[', title)) - charindex('[', title) - 1 ) else '?' end collate sql_latin1_general_cp1_ci_ai ) as [Number of Questions] , score , (select count(*) from votes where postid = p.id and votetypeid = 2) as upvotes , (select count(*) from votes where postid = p.id and votetypeid = 3) as downvotes , answercount , commentcount , favoritecount , owneruserid as [User Link] , lastactivitydate , creationdate from posts p where p.closeddate is null and acceptedanswerid is null and tags like '%<burninate-request>%' and tags not like '%<status-%' and score > 20 order by score desc