"Bad" answers to questions that include code.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

select case when q.body like '%<code>%' then 'yes'
            else 'no' end as IncludesCode
     , count(*) as Count
  from posts q
 where q.posttypeid = 1
   and q.viewcount > 10
   and ( q.score < 0
         or q.closeddate is not null )
   and q.answercount > 0
   and q.creationdate > ( select max(creationdate)
                           from posts ) - 30
   and not exists ( select 1
                      from posts
                     where parentid = q.id
                       and posttypeid = 2
                       and ( score > 0
                            or id = q.acceptedanswerid )
                            )
 group by case when q.body like '%<code>%' then 'yes'
               else 'no' end

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results