SELECT TOP 20 Q.Id as [Post Link] ,Q.Body ,Q.CreationDate...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT TOP 20
  Q.Id as [Post Link]
  ,Q.Body
  ,Q.CreationDate
FROM Posts Q
WHERE
  Q.PostTypeId = 1 -- Question
  AND Q.Score <= 7
  AND Q.ClosedDate IS NULL
  AND Q.DeletionDate IS NULL
  AND Q.Tags COLLATE Latin1_General_BIN LIKE '%aws%'
  AND UPPER(Q.Body) COLLATE Latin1_General_BIN LIKE '%AWS_SECRET_ACCESS_KEY=["''A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=][A-Z0-9/+=]%'
  AND UPPER(Q.Body) COLLATE Latin1_General_BIN NOT LIKE '%XXXXX%'
  AND Q.Body COLLATE Latin1_General_BIN NOT LIKE '%EXAMPLEKEY%'
--ORDER BY Q.CreationDate
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results