All-lowercase Stack Overflow questions asked in the last three days

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT PostId AS [Post Link],
       'http://stackoverflow.com/posts/' + cast(p.Id AS varchar(100)) + '/revisions', Text
FROM PostHistory ph
JOIN Posts p ON p.Id = ph.PostId
WHERE PostHistoryTypeId = 2
    AND Text = upper(Text) COLLATE SQL_Latin1_General_CP1_CS_AS
    AND ph.CreationDate >
        (SELECT CreationDate
         FROM Posts
         WHERE Id =
                 (SELECT max(Id)
                  FROM Posts)) - 3
    AND p.PostTypeId = 1

Enter Parameters

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