0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

declare @fr nvarchar(35) = '%<feature-request>%';

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>%')

select rank() over(order by Score desc), * from
(
  select distinct
    Id as [Post Link],
    datepart(year, CreationDate) as Created, 
    Score, 
    AnswerCount as Answers, 
    Tags
  from
  (
  select *
  from
    Posts
    left join PostTags on PostId = Id
  where
    PostTypeId = 1 and Tags like @fr and
    Score > 10 and AnswerCount > 1 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

view current version

edited aug 7 20

created aug 7 20 0Valt