Missing typescript tag for angular

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

-- Find posts tagged with specific tag, but not with the generic tag.

SELECT TOP 200 p.Title,
               'https://codereview.stackexchange.com/questions/' + CAST(p.id AS VARCHAR) as URL,
               p.Tags,
               p.CreationDate
FROM   posts p
CROSS APPLY (
       SELECT t.TagName TagSpecific
       FROM tags t
       INNER JOIN posttags pt on pt.tagid = t.id
       WHERE pt.postid = p.id
       AND t.TagName like 'angular-%'
) t_specific
OUTER APPLY (
       SELECT t.TagName TagGeneric
       FROM tags t
       INNER JOIN posttags pt on pt.tagid = t.id
       WHERE pt.postid = p.id
       AND t.TagName = 'typescript'
) t_generic
OUTER APPLY (
       SELECT t.TagName TagGenericBackup
       FROM tags t
       INNER JOIN posttags pt on pt.tagid = t.id
       WHERE pt.postid = p.id
       AND t.TagName = 'javascript'
) t_generic_backup
WHERE  1 = 1
AND    TagGeneric is NULL
AND    TagGenericBackup is NULL
AND    p.DeletionDate is NULL
AND    p.Body is NOT NULL
AND    p.ClosedDate is NULL
AND    ((SELECT count(*) FROM PostTags WHERE PostId = p.Id) < 5)
ORDER  BY p.CreationDate DESC
;

Enter Parameters

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