select tagname , p.body , count , case when meta.title is...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select tagname
     , p.body
     , count
     , case 
       when meta.title is not null 
       then
       concat('https://meta.stackoverflow.com/q/'
       , meta.id
       , '|'
       , meta.title)
       else 
       null 
       end [Has Burninate Request]
from tags t
inner join posts p 
   on p.id = t.excerptpostid
left outer join [stackoverflow.meta].dbo.Posts meta 
  on meta.title like '%[[]' + tagname + ']%' collate sql_latin1_general_cp1_ci_ai
where charindex('DO NOT USE', upper(p.body)) between 1 and 10 
and (meta.id is null or meta.tags like '%<burninate-request>%')
order by count desc

Enter Parameters

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