with PostsTaggedWithLoop as ( select PostId from PostTags...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

with PostsTaggedWithLoop as (
    select PostId 
    from PostTags
    where exists (
        select 1
        from tags
        where TagName = 'loop'
        and Id = TagId
    )
)
select --top 10 
  p.Id as [Post Link], 
  p.Tags,
  p.CreationDate
from PostsTaggedWithLoop as looped
join Posts as p 
    on looped.PostId = p.Id
    and p.PostTypeId = 1 --Question
    and p.ClosedDate is null
    and p.DeletioNDate is null
order by p.CreationDate desc;

Enter Parameters

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