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

Q&A about the site for administrators, end users, developers and designers for ExpressionEngine® CMS

SELECT PostTypes.Name, Posts.Id AS [Post Link]
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]%' COLLATE Latin1_General_CS_AS OR
    --(
    --    Title NOT LIKE '%?' AND
    --    (
    --        LOWER(Title) LIKE 'is %' OR
    --        LOWER(Title) LIKE 'are %' OR
    --        LOWER(Title) LIKE '%wh%' OR
    --        LOWER(Title) LIKE '%how%'
    --    )
    --) OR
    --Body LIKE '%[a-zZ]([a-rt-zZ]%' OR
    --Body LIKE '%[a-rt-zZ])[a-zZ]%' OR
    --Body LIKE '%[a-zZ],[a-zZ]%' --OR
    LOWER(Body) LIKE '%?[abcdefghijklmnopqrstuvwxyz]%'
)
ORDER BY PostTypeId ASC

view current version

edited nov 13 16

created nov 6 16 Gao