select tagname , p.body , count , concat('


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
     , concat(''
       , '|'
       , meta.title) [Has Burninate Request]
from tags t
inner join posts p 
   on = t.excerptpostid
left outer join [stackoverflow.meta].dbo.Posts meta 
  on meta.title like '%\[' + tagname + ']%' ESCAPE '\' collate sql_latin1_general_cp1_ci_ai
where charindex('DO NOT USE', upper(p.body)) between 1 and 10 
and is not null
  and meta.tags like '%<burniate-request>%'
order by count desc

Enter Parameters

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