Posts that probably need editing

4

Please login or register to vote for this query.

(click on this box to dismiss)

Updated with feedback from CodeReview.SE: https://codereview.stackexchange.com/q/176680/54092

Physics

Q&A for active researchers, academics and students of physics

SELECT PostTypes.Name, Posts.Id AS [Post Link], Score
FROM Posts
INNER JOIN PostTypes
ON Posts.PostTypeId = PostTypes.Id
INNER JOIN Users
ON Posts.OwnerUserId = Users.Id
WHERE
ClosedDate IS NULL AND
Score > 0 AND
(
    Reputation < 1000 OR
    (
        Reputation >= 1000 AND
        LastAccessDate < GETDATE() - 90
    )
) AND
PostTypeId NOT IN (6, 7) AND
(
    Title LIKE '[abcdefghijklmnopqrstuvwxyz]%' OR
    (
        Title NOT LIKE '%?' AND
        (
            LOWER(Title) LIKE 'is %' OR
            LOWER(Title) LIKE 'are %' OR
            LOWER(Title) LIKE '%wh[aeoy]%' OR
            LOWER(Title) LIKE '%how%'
        )
    ) OR
    Body LIKE '[abcdefghijklmnopqrstuvwxyz]%' OR
    Body LIKE '%[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]([ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrtuvwxyz]%' OR
    Body LIKE '%[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrtuvwxyz])[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]%' OR
    Body LIKE '%[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz],[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]%'
)
ORDER BY PostTypeId ASC, Score DESC

Enter Parameters

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