testing CE+CW

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism Meta

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

/**
select * from
    (
    --Part 1
    Select t.TagName 
      ,count
      (case when p.Tags in ('<compiler-errors>') then 1 else null end) as CE_AND_MORE
      ,count
      (case when p.Tags in ('<compiler-warnings>')
      and p.Tags not in('<compiler-errors>') then 1 else null end) as Just_CW
--      ,count
--        (case when p.AcceptedAnswerId IS NOT NULL and p.Tags in('<compiler-errors>', '<compiler-warnings>') then 1 else null end)as NumAccepted    
    from Posts p, Tags t, PostTags pt
    --where p.Tags like '%compiler-errors%'
    where p.PostTypeId=1 and p.Id = pt.PostId and pt.TagId = t.Id
--    and t.TagName not in ('compiler-errors', 'compiler-warnings')
    group by t.TagName
) part1


**/


/**
select *
from Posts p
where p.Tags like ('%<compiler-errors>%') or P.Tags like ('%<compiler-warnings>%')
and p.PostTypeId=1 
-- returns 13289 rows
**/

/**
select count(*) 
from Posts p where p.Tags in ('<compiler-errors>', '<compiler-warnings>')
and p.PostTypeId=1
-- returns 41
**/


--select count(*) from Posts p where p.Tags like('<compiler-errors>', '<compiler-warnings>')

/**
select *
from Posts p
where p.Tags like ('%<compiler-errors>%') and P.Tags like ('%<compiler-warnings>%')
and p.PostTypeId=1 
--137 rows returned
**/

select *
from Posts p
where p.Tags like ('%swift%') or P.Tags like ('%ios%')
and p.PostTypeId=1 
-- returns 13289 rows

Enter Parameters

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