0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT p.Body
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
WHERE (LOWER(t.TagName) LIKE '%security%'
   OR LOWER(t.TagName) LIKE '%cybersecurity%'
   OR LOWER(t.TagName) LIKE '%information-security%'
   OR LOWER(t.TagName) LIKE '%network-security%'
   OR LOWER(t.TagName) LIKE '%application-security%'
   OR LOWER(t.TagName) LIKE '%web-security%'
   OR LOWER(t.TagName) LIKE '%data-security%'
   OR LOWER(t.TagName) LIKE '%privacy%'
   OR LOWER(t.TagName) LIKE '%encryption%'
   OR LOWER(t.TagName) LIKE '%authentication%'
   OR LOWER(t.TagName) LIKE '%authorization%'
   OR LOWER(t.TagName) LIKE '%vulnerability%'
   OR LOWER(t.TagName) LIKE '%malware%'
   OR LOWER(t.TagName) LIKE '%phishing%'
   OR LOWER(t.TagName) LIKE '%firewall%'
   OR LOWER(t.TagName) LIKE '%intrusion-detection%'
   OR LOWER(t.TagName) LIKE '%pentesting%'
   OR LOWER(t.TagName) LIKE '%ethical-hacking%'
   OR LOWER(t.TagName) LIKE '%cybercrime%'
   OR LOWER(t.TagName) LIKE '%digital-forensics%'
   OR LOWER(t.TagName) LIKE '%risk-management%'
   OR LOWER(t.TagName) LIKE '%compliance%'
   OR LOWER(t.TagName) LIKE '%regulation%'
   OR LOWER(t.TagName) LIKE '%incident-response%'
   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-architecture%'
   OR LOWER(t.TagName) LIKE '%security-engineering%'
   OR LOWER(t.TagName) LIKE '%secure-coding%'
   OR LOWER(t.TagName) LIKE '%secure-software-development%'
   OR LOWER(t.TagName) LIKE '%cryptography%'
   OR LOWER(t.TagName) LIKE '%identity-management%'
   OR LOWER(t.TagName) LIKE '%access-control%'
   OR LOWER(t.TagName) LIKE '%biometrics%'
   OR LOWER(t.TagName) LIKE '%iot-security%'
   OR LOWER(t.TagName) LIKE '%cloud-security%'
   OR LOWER(t.TagName) LIKE '%mobile-security%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-framework%'
   OR LOWER(t.TagName) LIKE '%incident-management%'
   OR LOWER(t.TagName) LIKE '%threat-intelligence%'
   OR LOWER(t.TagName) LIKE '%threat-hunting%'
   OR LOWER(t.TagName) LIKE '%security-training%'
   OR LOWER(t.TagName) LIKE '%security-certification%'
   OR LOWER(t.TagName) LIKE '%security-compliance%'
   OR LOWER(t.TagName) LIKE '%security-governance%'
   OR LOWER(t.TagName) LIKE '%security-operations%'
   OR LOWER(t.TagName) LIKE '%security-monitoring%'
   OR LOWER(t.TagName) LIKE '%security-analytics%'
   OR LOWER(t.TagName) LIKE '%security-orchestration%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-awareness%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-education%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-training%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-certification%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-framework%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-governance%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-operations%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-monitoring%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-analytics%'
   OR LOWER(t.TagName) LIKE '%cybersecurity-orchestration%'
   OR LOWER(t.TagName) LIKE '%it-security%'
   OR LOWER(t.TagName) LIKE '%it-governance%'
   OR LOWER(t.TagName) LIKE '%it-risk-management%'
   OR LOWER(t.TagName) LIKE '%it-compliance%'
   OR LOWER(t.TagName) LIKE '%it-audit%'
   OR LOWER(t.TagName) LIKE '%it-policy%'
   OR LOWER(t.TagName) LIKE '%it-architecture%'
   OR LOWER(t.TagName) LIKE '%it-operations%'
   OR LOWER(t.TagName) LIKE '%it-monitoring%'
   OR LOWER(t.TagName) LIKE '%it-analytics%'
   OR LOWER(t.TagName) LIKE '%it-orchestration%')
   AND p.CreationDate >= '2024-02-10'
   AND p.CreationDate <= '2024-03-10'

fork query

created mar 15 anonymous