Feature request questions that are upvoted and answered

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

declare @fr nvarchar(35) = '%<feature-request>%';
declare @answers int = ##answers:int?1##;
declare @scoreconstraint int = ##score:int?10##;

declare @forbidden table ( 
  search nvarchar(39) collate SQL_Latin1_General_CP1_CS_AS
);

insert into @forbidden values
  ('%<status-completed>%'),
  ('%<status-declined>%'),
  ('%<status-review>%'),
  ('%<status-planned>%'),
  ('%<status-deferred>%'),
  ('%<status-bydesign>%')

select rank() over(order by Score desc), * from
(
  select distinct
    Id as [Post Link],
    year(CreationDate) as Created,
    year(getdate()) - year(CreationDate) as Age,
    Score, 
    AnswerCount as Answers, 
    Tags
  from
  (
  select *
  from
    Posts
    left join PostTags on PostId = Id
  where
    PostTypeId = 1 and Tags like @fr and
    Score > @scoreconstraint and AnswerCount > @answers and 
    AcceptedAnswerId is not null
    and not exists (
      select search, TagName 
      from @forbidden inner join Tags 
      on '%<' + TagName + '>%' = search
      where Tags like search
    )
  ) main
) dist

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results