0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT 
    c.id As [Post Link],
    c.Text As [Comments Link],

    CASE 
        
        WHEN c.PostId = 1 THEN 'Question'
        ELSE 'Answer'
        
  
    END AS PostId
FROM 
  
    Comments c
JOIN 
  
    PostTags pt ON pt.PostId = c.Id
JOIN 
    Tags t ON pt.TagId = t.Id
  
WHERE 
    t.TagName IN ('access-control', 'cloud security best practices', 'principle of least priviledge in devops', 'best practice for improving access control', 'Common Access Control Vulnerabilities')
ORDER BY 

    c.CreationDate DESC

fork query

edited aug 1

created jul 31 anonymous