Posts that probably need editing

5

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

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

SELECT Posts.Id AS [Post Link], PostTypes.Name
FROM Posts
INNER JOIN PostTypes
ON Posts.PostTypeId = PostTypes.Id
WHERE
ClosedDate IS NULL AND
Score > -2 AND
PostTypeId <> 6 AND
(
    Title LIKE '[abcdefghijklmnopqrstuvwxyz]%' OR
    Title LIKE '%.%' OR
    Title LIKE '%(%' OR
    (
        Title NOT LIKE '%?' AND
        (
            LOWER(Title) LIKE 'is %' OR
            LOWER(Title) LIKE 'are %' OR
            LOWER(Title) LIKE '%what%' OR
            LOWER(Title) LIKE '%where%' OR
            LOWER(Title) LIKE '%when%' OR
            LOWER(Title) LIKE '%who%' OR
            LOWER(Title) LIKE '%why%' OR
            LOWER(Title) LIKE '%how%' OR
            LOWER(Title) LIKE '%there%'

        )
    ) OR
    (
        Title IS NULL AND
        (
            Body LIKE '%<p>[abcdefghijklmnopqrstuvwxyz]%' OR
            Body LIKE '%. [abcdefghijklmnopqrstuvwxyz]%' OR
            Body LIKE '%.[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]%' OR
            Body LIKE '%[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz](%' OR
            Body LIKE '%)[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]%'
            COLLATE Latin1_General_CS_AS
        )
    )
)
ORDER BY NEWID()

Enter Parameters

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