Burnination to untagged Helper

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

create table #toburn (
    tagid int not null,
    tagname NVarchar(25))
;

insert into #toburn
select id, tagName
from Tags
where tagname in (
    'refactoring', 'clean-code', 'code-smell', -- phase 1
    'readability', 'best-practice', -- future phase
    '', ''
    )

;

create table #languages (
    tagid int not null,
    tagname NVarchar(25))

insert into #languages
select id, tagName
from Tags
where tagName in (
    'assembly',
    'actionscript', 'actionscript-3',
    'script', 'scripting', 'bash', 'tcsh', 'shell', 'powershell',
    'brainfuck',
    'c', 'c++',
    'clojure',
    'cobol',
    'c#', '.net', 'vb.net', 'f#', 'vba', 'vbscript',
        'asp.net', 'asp-classic', 'xaml',
    'd',
    'dart',
    'delphi', 'pascal',
    'haskell',
    'html','html5','css',
    'go',
    'java', 'scala', 'groovy',
    'javascript', 'jquery', 'nodejs', 'node.js', 'angular.js',
    'lisp','elisp','common-lisp',
    'moq',
    'nginx',
    'objective-c', 'coffeescript', 'swift',
    'ocaml',
    'perl',
    'php', 'php5',
    'postscript',
    'prolog',
    'python',
    'r',
    'regex',
    'rebol',
    'ruby', 'ruby-on-rails',
    'scheme',
    'sql', 't-sql', 'mysql',
    'vimscript',
    '')

;

with AffectedPosts as (
    select PostId
    from PostTags pt, #toburn tb
    where tb.TagId = pt.TagId),
    
    WellTagged as (
    select PostId
    from PostTags pt, #languages l
    where l.TagId = pt.TagId)
select Id as [Post Link], Id as [Id], tags as [Tags]
from Posts
where PostTypeId = 1 -- question
  and Id in (select PostId from AffectedPosts)
  and Id not in (select postId from WellTagged)

Enter Parameters

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