0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

SELECT p.Body
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
WHERE (
   LOWER(p.Body) LIKE '%sql injection%'
   OR LOWER(p.Body) LIKE '%$unsafe_variable%'
   OR LOWER(p.Body) LIKE '%input validation%'
   OR LOWER(p.Body) LIKE '%prepared statements%'
   OR LOWER(p.Body) LIKE '%injection attack%'
   OR LOWER(p.Body) LIKE '%buffer overflow%'
   OR LOWER(p.Body) LIKE '%code injection%'
   OR LOWER(p.Body) LIKE '%command injection%'
   OR LOWER(p.Body) LIKE '%path traversal%'
   OR LOWER(p.Body) LIKE '%remote code execution%'
   OR LOWER(p.Body) LIKE '%cross site scripting%'
   OR LOWER(p.Body) LIKE '%persistent xss%'
   OR LOWER(p.Body) LIKE '%reflected xss%'
   OR LOWER(p.Body) LIKE '%stored xss%'
   OR LOWER(p.Body) LIKE '%xss payload%'
   OR LOWER(p.Body) LIKE '%cross-origin resource sharing%'
   OR LOWER(p.Body) LIKE '%csrf%'
   OR LOWER(p.Body) LIKE '%clickjacking%'
   OR LOWER(p.Body) LIKE '%script injection%'
   OR LOWER(p.Body) LIKE '%xml injection%'
   OR LOWER(p.Body) LIKE '%ldap injection%'
   OR LOWER(p.Body) LIKE '%xpath injection%'
   OR LOWER(p.Body) LIKE '%ssi injection%'
   OR LOWER(p.Body) LIKE '%xml external entity%'
   OR LOWER(p.Body) LIKE '%xxe%'
   OR LOWER(p.Body) LIKE '%server-side request forgery%'
   OR LOWER(p.Body) LIKE '%ssrf%'
   OR LOWER(p.Body) LIKE '%file inclusion%'
   OR LOWER(p.Body) LIKE '%remote file inclusion%'
   OR LOWER(p.Body) LIKE '%local file inclusion%'
   OR LOWER(p.Body) LIKE '%rfi%'
   OR LOWER(p.Body) LIKE '%lfi%'
   OR LOWER(p.Body) LIKE '%os command injection%'
   OR LOWER(p.Body) LIKE '%rce%'
   OR LOWER(t.TagName) LIKE '%security%'
   OR LOWER(t.TagName) LIKE '%authentication%'
   OR LOWER(t.TagName) LIKE '%authorization%'
   OR LOWER(t.TagName) LIKE '%cryptography%'
   OR LOWER(t.TagName) LIKE '%encryption%'
   OR LOWER(t.TagName) LIKE '%privacy%'
   OR LOWER(t.TagName) LIKE '%network-security%'
   OR LOWER(t.TagName) LIKE '%web-security%'
   OR LOWER(t.TagName) LIKE '%data-security%'
   OR LOWER(t.TagName) LIKE '%cybersecurity%'
   OR LOWER(t.TagName) LIKE '%vulnerability%'
   OR LOWER(t.TagName) LIKE '%penetration-testing%'
   OR LOWER(t.TagName) LIKE '%secure-coding%'
   OR LOWER(t.TagName) LIKE '%security-audit%'
   OR LOWER(t.TagName) LIKE '%security-awareness%'
   OR LOWER(t.TagName) LIKE '%security-policy%'
   OR LOWER(t.TagName) LIKE '%security-engineering%'
   OR LOWER(t.TagName) LIKE '%identity-management%'
   OR LOWER(t.TagName) LIKE '%access-control%'
   OR LOWER(t.TagName) LIKE '%cloud-security%'
   OR LOWER(t.TagName) LIKE '%mobile-security%'
   OR LOWER(t.TagName) LIKE '%iot-security%'
   OR LOWER(t.TagName) LIKE '%security-architecture%'
)
AND p.CreationDate >= '2017-09-21'
AND p.CreationDate <= '2021-09-21'

fork query

created mar 17 anonymous