select tagname , p.body , count , concat('https://meta.st...

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
     , concat('https://meta.stackoverflow.com/q/'
       , meta.id
       , '|'
       , meta.title) [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