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

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT PostTypes.Name
      ,Posts.Id AS [Post Link]
      ,Posts.Body
FROM Posts
INNER JOIN PostTypes
ON Posts.PostTypeId = PostTypes.Id
INNER JOIN Users
ON Posts.OwnerUserId = Users.Id
WHERE
ClosedDate IS NULL AND
Score > -2 AND
Reputation < 3000 AND
LEN(Body) < 2000 AND
(
    Title LIKE '[abcdfhijklmnopqrstuvwxyz]%' 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
    Body LIKE '%[abcdefghijklmnopqrstuvwxyz]. [abcdefghijklmnopqrstuvwxyz]%' OR
    Body LIKE '%[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz](%' OR
    Body LIKE '%)[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]%'
    COLLATE Latin1_General_CS_AS
) AND
PostTypeId NOT IN (6, 7)
ORDER BY PostTypeId ASC

view current version

edited nov 12 16

created nov 6 16 Gao